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

is there any differnce between proc means and proc summary?

How would you code the criteria to restrict the output to be produced?

What has been your most common programming mistake?

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

How to select the observations randomly from a SAS dataset

How do you control the number of observations and/or variables read or written?

Explain the difference between informat and format with an example.

Can we replace a dataset into view?

What's the difference between VAR A1 - A4 and VAR A1 - A4?

Describe 5 ways to do a “table lookup” in SAS?

For more SAS Interview Questions Click Here