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 the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
What are Dashboard reports?And significance of these in analysis?
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
What Proc glm does?
tell me about intnx, intcx functions?
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
Did you used proc test? when?
0 Answers Accenture, Quintiles,
what is the use of proc sql? : Sas programming
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
how do u identify a macro variable
What is the difference between %put and symbolgen? : sas-macro
Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.