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 are the limitations for memory allocation for SAS variables

931

How to create an external dataset with sas code?

588

Explain what is data step?

728

how does sas handle missing values in functions? : Sas programming

601

what is ae onset date n what is RDS

1936

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

1797

How does proc sql work?

618

Explain the use of proc gplot? : sas-grid-administration

555

What function CATX syntax does?

689

In ARRAY processing, what does the DIM function do?

710

What are the prime responsibilities of data integration administrator? : Sas-di

587

what is data access? : Sas-di

607

what is proc Index? and what is proc document?

1996

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

592

Explain the special input delimiters used in sas programming.

583