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

how to remove the duplicates by proc sql?

Question Posted / xxx

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the purpose of _error_? : Sas programming

1093

Have you ever used the SAS Debugger?

1714

Describe the function and untility of the most difficult SAS macro that you have written.

2175

how are numeric and character missing values represented internally? : Sas programming

1110

for whom is sas data integration studio designed? : Sas-di

975

Enlist the syntax rules followed in sas statements.

1051

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

1111

In ARRAY processing, what does the DIM function do?

1132

for report generation which one you used proc report or data_null_?

7686

Mention sas system options to debug sas macros.

1150

List out some key concept of SAS

1064

What is data _null_?

1099

what is program data vector? : Sas-administrator

1026

How do you use the do loop if you don’t know how many times you should execute the do loop?

1235

What is the difference between one to one merge and match merge? Give an example.

1016