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 slibref?

1285

How would you define the end of a macro?

1097

Explain what is the use of proc gplot?

1200

Which command is used to perform sorting in sas program?

1050

What does the RUN statement do?

1308

it will become easy if uuu provide website linkssss and list of consultanciessssss

1981

what is sas metadata repository? : Sas-bi

1119

In proc transpose and data step with arrays which one you pick?

3112

What are the data types does SAS contain?

1118

explain what is factor analysis? : Sas-administrator

1115

AE datasets names? how many types?

2506

What does proc print, and proc contents are used for?

1136

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1163

What is the difference between SAS functions and procedures?

1153

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

1053