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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will calendar procedure do?

609


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

554


What commands are used in the case of including or excluding any specific variables in the data set?

602


What are the special input delimiters used in SAS?

666


Explain input and put function?

657






What is PDV?

736


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

698


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

864


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

2440


What is connection profile? : sas-grid-administration

656


What is the role of sas grid administrator? : sas-grid-administration

841


Mention what is the difference between nodupkey and nodup options?

604


Explain the use of proc print and proc contents?

565


what is factor analysis? : Sas-administrator

625


What is interleaving in SAS?

685