how do we get duplicate observations in a separate dataset?
Answer Posted / vipin choudhary
Proc sort data = indata;
by name;
run;
Data outdata;
set indata;
by name;
if first.name and last.name then delete;
run;
proc print data = outdata;
run;
or else you can use the dupout option in proc sort
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Name any two sas spawners? : sas-grid-administration
Can you execute macro within another macro? : sas-macro
what is sas and what are the functions? : Sas-administrator
How would you identify a macro variable?
what is sas database server? : Sas-di
What are the difference between the sas data step and sas procs?
What’s the difference between var b1 – b3 and var b1 — b3?
What are the scrubbing procedures in sas?
In sas, what are the areas that you are most interested in? : sas-grid-administration
Describe the ways in which you can create a macro variable?
What is the use of divide function?
What is the difference between the proc sql and data step?
Give an example where SAS fails to convert character value to numeric value automatically?
What are the implications?
how will you location sas platform applications available from web browser? : Sas-bi