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

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

how to do user inputs and command line arguments in sas?

Explain proc sort?

What is by-group processing?

One way of creating a new variable in Macros is by % Let....What is the other way..?

What is a put statement?

what do you mean by data staging area? : Sas-di

Given an unsorted data set, how to read the last observation to a new data set?

What does PROC print, and PROC contents do?

What is the difference between reading data from an external file and reading data from an existing data set?

Name statements that function at both compile and execution time.

Mention what is PROC in SAS?

For more SAS Interview Questions Click Here