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

explain the concepts and capabilities of business object? : Sas-bi

which features do you use to check the data validations and errors? : Sas-administrator

how will you locate the sas platform applications? : Sas-bi

What would you change about your job?

how does sas handle missing values in an update? : Sas programming

What is a pdv and what are its functions?

What report output formats can you generate using SAS?

How to write duplicate records into a separate dataset using sort?

What is the use of function Proc summary?

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

How would you remove a format that has been permanently associated with a variable? ________________

what is the difference between proc report and proc format?

For more SAS Interview Questions Click Here