First sort the data set by the key variable and then data dup; set ind

How to write duplicate records into a separate dataset using
sort?

Question Posted / yam

Answer Posted / yam

First sort the data set by the key variable and then

data dup;
set indata1;
if not(first.keyvar) then output dup;
run;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How would you identify a macro variable? : sas-macro

1008

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2218

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1242

What do the mod and int function do? : Sas programming

1207

What is interleaving in SAS?

1097

Differences between where and if statement?

1075

it will become easy if uuu provide website linkssss and list of consultanciessssss

1966

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?

1153

Name validation tools used in SAS

1168

how do you debug and test your sas programs? : Sas programming

1117

Mention what is the difference between nodupkey and nodup options?

1002

how to do user inputs and command line arguments in sas?

3033

Differentiate between sas functions and sas procedures.

1216

how do you pull data from equifax?tell me the process?

1786

What are the statements that are executed only?

1136