how to remove the duplicates by proc sql?
Answers were Sorted based on User's Feedback
Answer / xxx
proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;
| Is This Answer Correct ? | 1 Yes | 10 No |
explain the concepts and capabilities of business object? : Sas-bi
which features do you use to check the data validations and errors? : Sas-administrator
how will you locate the sas platform applications? : Sas-bi
What would you change about your job?
how does sas handle missing values in an update? : Sas programming
What is a pdv and what are its functions?
What report output formats can you generate using SAS?
How to write duplicate records into a separate dataset using sort?
What is the use of function Proc summary?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
How would you remove a format that has been permanently associated with a variable? ________________
what is the difference between proc report and proc format?