Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicates by using proc sql?
- 3 Answers
- 8906 Views
- Genpact, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
| Is This Answer Correct ? | 22 Yes | 2 No |
Answer / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chowdary
In constraints time using unique
In datasets using distinct()
| Is This Answer Correct ? | 1 Yes | 0 No |
In the flow of DATA step processing, what is the first action in a typical DATA Step?
How is character variable converted into numeric variable and vice versa?
What do you know about sas data set?
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.
How to select the observations randomly from a SAS dataset
for what purpose would you use the retain statement? : Sas programming
what is the need of INDEX in datasets?
tell me about use of arrays in sas
What is the use of the %include statement?
How sas treats the dsd delimiters?
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?
Teradata 
