how do we get duplicate observations in a separate dataset?

Answer Posted / bitla

ex:

data dup1 dup2;
set original;
by dup_var;
if first.dup_var then output dup1 else output dup2;
run;

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is program data vector (pdv)?

872


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

933


Have you used macros? For what purpose you have used? : sas-macro

828


Where do you use proc means over proc freq?

787


How do you connect the desktop application to metadata server? : sas-grid-administration

867


What is the difference between match merge and one to one merge?

939


what is transformation in sas data integration? : Sas-di

789


how are numeric and character missing values represented internally? : Sas programming

895


Explain substr function?

814


What do you know about symput and symget?

968


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

2101


What are the new features included in the new version of SAS Programming Language?

973


What do the put and input function do?

808


How many data types are there in SAS?

821


What Proc glm does?

865