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

How to specify variables to be processed by the freq procedure?

1067

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1070

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

1265

What do the SAS log messages "numeric values have been converted to character" mean?

1371

How to include or exclude specific variables in a data set?

1110

What is the command used to find missing values?

1093

What is a put statement?

1193

What is the difference between proportion and average?

3327

Why and when do you use proc sql?

1240

What is program data vector (pdv)?

1277

How can you create a macro variable with in data step? : sas-macro

1036

Mention some common errors that are usually committed in sas programming.

1039

Tell e how how dealt with..

2218

why is a stop statement needed for the point=option on a set statement? : Sas programming

1076

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2069