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 |
Explain the special input delimiters used in sas programming.
What is the difference between proportion and average?
What are the statements in proc sql?
What areas of SAS are you most interested in?
what are several options for creating reports in web report studio? : Sas-bi
When merging 2 datasets with a common variable (not merge key), how to keep both?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
what versions of sas have you used (on which platforms)? : Sas programming
what is the difference between SET and MERGE?
Tell e how how dealt with..
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
what is operational data and operational system? : Sas-di