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
What is the basic syntax of a sas program?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What would be the value of month at the end of data step execution and how many observations would be there?
What is the SAS data set?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is the use of sas management console? : Sas-di
Explain what is the use of proc gplot?
what is sas metadata repository? : Sas-bi
Name any two sas spawners? : sas-grid-administration
what are the considerations when picking a SAS/STAT procedure?
how would you create multiple observations from a single observation? : Sas programming
what is data integration? : Sas-di
What are types of transport files?
Explain translate function?
what is the difference between floor and ceil functions in sas? : Sas-administrator