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 |
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
What are the statements in proc sql?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
How would you invoke a macro? : sas-macro
What does PROC print, and PROC contents do?
what are the differences between proc report and proc tabulate?
At compile time when a SAS data set is read, what items are created?
what is sas? is a package or tool? give me introduction about sas?
What is the difference between where and if statement?
Are you involved in writing the inferential analysis plan? Tables specfications?
How would you create multiple observations from a single observation?
i want to upload titles and footnotes to excel file?how it is possible?