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

What is maximum number of rows and cols can be handled in SAS?

866


Name validation tools used in SAS

708


What is the basic syntax of a sas program?

675


What is the basic structure of a sas program?

612


what r the job openings SAS for fresher graduates !

2023






how does sas handle missing values in functions? : Sas programming

610


How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

1959


what type of graphs we will create(for 2+years candidates)?

1914


What are the features of base sas system?

623


Tell me about % include and % eval? : sas-macro

689


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

1854


What system options would you use to help debug a macro? : sas-macro

650


How can I remove header from output data set?

2083


What is by-group processing?

588


Which command is used to save logs in the external file?

579