how to delete the duplicates by using proc sql?
- 3 Answers
- 8209 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the difference between unique key and primary key? : Sas-di
In sas admin differentiate between roles and capabilities? : sas-grid-administration
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
What is the differnce between SDTM 3.1.2 to 3.1.1 version
Describe the ways in which you can create a macro variable?
In SAS explain which statement does not perform automatic conversions in comparisons?
why is sas data integration studio important? : Sas-di
Explain input and put function?
What is the difference between INPUT and INFILE ?
What is substr function?
Explain bmdp procedure?
What are symget and symput? : sas-macro
What are the automatic variables for macro? : sas-macro
what is sas and what are the functions? : Sas-administrator
How to create list output for cross-tabulations in proc freq?
