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

Describe a time when you were really stuck on a problem and how you solved it?

2314


How to limit decimal places for the variable using proc means?

818


What Proc glm does?

843


What is the use of %include statement?

819


name several ways to achieve efficiency in your program? : Sas programming

768


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

922


For what purpose would you use the RETAIN statement?

1271


how do you want missing values handled? : Sas programming

726


Mention sas system options to debug sas macros.

918


Enlist the functions performed by sas.

871


What is the difference between class statement and by statement in proc means?

903


what are the categories that sas informats are used to the place the data? : Sas-administrator

807


what versions of sas have you used (on which platforms)? : Sas programming

811


How do you debug and test your SAS programs?

1277


In sas, what are the areas that you are most interested in? : sas-grid-administration

840