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


Please Help Members By Posting Answers For Below Questions

Name any two sas spawners? : sas-grid-administration

727


Can you execute macro within another macro? : sas-macro

679


what is sas and what are the functions? : Sas-administrator

692


How would you identify a macro variable?

784


what is sas database server? : Sas-di

774






What are the difference between the sas data step and sas procs?

773


What’s the difference between var b1 – b3 and var b1 — b3?

999


What are the scrubbing procedures in sas?

708


In sas, what are the areas that you are most interested in? : sas-grid-administration

771


Describe the ways in which you can create a macro variable?

769


What is the use of divide function?

747


What is the difference between the proc sql and data step?

815


Give an example where SAS fails to convert character value to numeric value automatically?

767


What are the implications?

1341


how will you location sas platform applications available from web browser? : Sas-bi

735