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 |
how could you generate test data with no input data? : Sas programming
SAS System ?
How would you code the criteria to restrict the output to be produced?
what is information maps?
Which is the best training Institute for SAS Business Intelligence course?
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
how can you create zero observation dataset? : Sas programming
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
what is program data vector? : Sas-administrator
What is proc sort?
what versions of sas have you used (on which platforms)? : Sas programming
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,