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 metadata? : Sas-bi

602

What is the difference between where and if statement?

624

How many data types are there in SAS?

637

explain the function of substr in sas? : Sas-administrator

558

what is sas business intelligence? : Sas-bi

590

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

655

Describe the function and utility of the most difficult SAS macro that you have written?

2027

What does the trace option do?

671

Differentiate between format and informat? : sas-grid-administration

584

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1168

is data integration and etl programming is same? : Sas-di

578

what is transformation in sas data integration? : Sas-di

560

what is the use of proc sql? : Sas programming

600

How does proc sql work?

618

What are the difference between sas functions and procedures?

644