How to write duplicate records into a separate dataset using
sort?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How do you define proc in sas? : sas-grid-administration
How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?
What is the difference between order and group variable in proc report?
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
What is the order of application for output data set options, input data set options and SAS statements?
is QUALCOMM using SAS ?
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
What is Linear Regression?
Explain the message 'Merge has one or more datasets with repeats of by variables'.
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;
Describe a time when you were really stuck on a problem and how you solved it?
What SAS statements would you code to read an external raw data file to a DATA step?