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 |
What commands are used in the case of including or excluding any specific variables in the data set?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
name several ways to achieve efficiency in your program? : Sas programming
who is the best SAS clinical Trainer in Hyderabad?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
what are the three main credit bureau names
1 Answers Synchrony Financial,
WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
what is the effect of the options statement errors=1? : Sas programming
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 Answers Verinon Technology Solutions,
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.