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

How does the internal authentication work in sas? : sas-grid-administration

813


Hi, If anyone has base SAS certification dumps, please share.

1607


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

729


Explain translate function?

857


What is the difference between proportion and average?

2994


Can you explain the process of calendar?

856


What is the basic syntax of a sas program?

867


Differentiate between format and informat? : sas-grid-administration

793


Which statement does not perform automatic conversions in comparisons?

1439


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

849


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

738


Are you involved in writing the inferential analysis plan? Tables specfications?

1971


What do you code to create a macro? : sas-macro

799


Briefly explain input and put function?

823


For what purpose would you use the RETAIN statement?

1262