how to delete the duplicates by using proc sql?
- 3 Answers
- 8206 Views
- Genpact, I also Faced
- E-Mail Answers
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 are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
how to remove duplicates using proc sql?
what are validation tools that are used in sas? : Sas-administrator
What are the different operating system platforms in which we can use sas? : sas-grid-administration
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Which command is used to save logs in the external file?
Mention what is the difference between nodupkey and nodup options?
Differentiate input and infile.
what is the difference between unique key and primary key? : Sas-di
what is the difference between infile and input? : Sas-administrator
Are you involved in writing the inferential analysis plan? Tables specfications?
What is the difference between proportion and average?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is interleaving in SAS?
