Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicates by using proc sql?
- 3 Answers
- 9015 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 |
how to delete the duplicate columns permanently in SQL
what is AE onset date and what is RDS?
How would you code the criteria to restrict the output to be produced?
what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';
how do we mail reports from SAS environment to our team leader
What is the purpose of _error_?
how we can call macros with in data step?
in ods is there any lib's
what are the types of interactive display types? : Sas-bi
What is substr function?
What are the statements that are executed only?
Why is a STOP statement needed for the point=option on a SET statement?
Teradata 
