how to remove the duplicates by proc sql?

Question Posted / ram chowdary

Answers were Sorted based on User's Feedback

how to remove the duplicates by proc sql? ..

Answer / gaurav gupta

SELECT DISTINCT statement in PROC SQL

Is This Answer Correct ?

20 Yes

3 No

how to remove the duplicates by proc sql? ..

Answer / xxx

proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;

Is This Answer Correct ?

1 Yes

10 No

More SAS Interview Questions

What does error:1 mean?

How to get part of string form the source string without using sub string function in SAS?

Tell e how how dealt with..

explain the main difference between the nodup and nodupkey options? : Sas-administrator

What Proc glm does?

What is the difference between verification and validation?

what is prime numbers? how we can get plc write sas code?

The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

Name and describe few sas character functions that are used for data cleaning in brief.

For what purpose(s) would use the RETURN statement?

Explain the purpose of retain statement.

What are the functions which are used for character handling functions?

For more SAS Interview Questions Click Here