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

Answers were Sorted based on User's Feedback



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

Answer / guest

Dupout option

Is This Answer Correct ?    27 Yes 1 No

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

Answer / vimal

PROC SORT DATA=data_a DUPOUT=dup_data
NODUPKEY
OUT=nodup_data;
BY x;
RUN;

Is This Answer Correct ?    4 Yes 0 No

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

Answer / 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

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

Answer / charan araveti

if u dont want to use DUPOUT,hear is some code:

data dup(drpo temp_id);
set ds1;
retain temp_id;
if temp_id ne id then
output;
temp_id=id;

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SAS Interview Questions

How do you define proc in sas? : sas-grid-administration

0 Answers  


How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?

7 Answers   GSK, TNS,


What is the difference between order and group variable in proc report?

0 Answers  


CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

4 Answers   CybAge,


What is the order of application for output data set options, input data set options and SAS statements?

0 Answers   Quintiles,






is QUALCOMM using SAS ?

1 Answers  


what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

1 Answers   Max India,


What is Linear Regression?

0 Answers  


Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 Answers  


create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,


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

1 Answers  


What SAS statements would you code to read an external raw data file to a DATA step?

10 Answers   NIIT,


Categories