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 sas and what are the functions? : Sas-administrator

1031

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1120

what are the types of interactive display types? : Sas-bi

1146

What do you code to create a macro? : sas-macro

1189

what do the pad and dim functions do? : Sas programming

1072

What are the different types of sas functions?

1361

what are validation tools that are used in sas? : Sas-administrator

1115

Where do you use proc means over proc freq?

1188

Mention the difference between ceil and floor functions in sas?

1208

what is data governance? : Sas-di

1067

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1189

what is business intelligence? : Sas-bi

1107

what r the job openings SAS for fresher graduates !

2502

Mention the category in which sas informats are placed?

1076

What is Linear Regression?

1221