how to remove the duplicates by proc sql?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

1292


Which command is used to perform sorting in sas program?

676


If you could design your ideal job, what would it look like?

2480


what is null hypothesis? why do you consider that?

2527


what are the considerations when picking a SAS/STAT procedure?

2995






how does sas handle missing values in sort order? : Sas programming

619


what are _numeric_ and _character_ and what do they do? : Sas programming

777


Explain data_null_?

699


Mention common programming errors committed in sas ?

722


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

1707


How can I remove header from output data set?

2202


What is the basic syntax style in SAS?

713


If money were no object, what would you like to do?

2789


What does PROC print, and PROC contents do?

846


What are all the problems you faced while validating tables and reports?

3111