how to delete the duplicates by using proc sql?
Answer Posted / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What is the difference between reading data from an external file and reading data from an existing data set?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what is the purpose of _error_? : Sas programming
What was the last computer book you purchased? Why?
What commands are used in the case of including or excluding any specific variables in the data set?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what techniques and/or procs do you use for tables? : Sas programming
Name any two sas spawners? : sas-grid-administration
what are sas bi dashboard components? : Sas-bi
What are the advantages of using sas?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
Do you know the features of sas?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
what are sas/access and sas/connect? : Sas programming
What are the difficulties u faced while doing vital signs table or dataset?