how do we get duplicate observations in a separate dataset?
Answer Posted / natrajboga
use the dupout= and nodupkey options in proc sort and
followed by BY statemet with list of vars
proc sort data=xxx dupout=dup_xxx nodupkey;
by var1;
run;
/* see the log window */
proc print data=dup_xxx;
run;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What does proc print, and proc contents are used for?
What is the function of Stop statement in a SAS Program?
What do the SAS log messages "numeric values have been converted to character" mean?
What was the last computer book you purchased? Why?
what are the component of range? : Sas-bi
In ARRAY processing, what does the DIM function do?
What is the basic structure of a sas program?
Difference between SAS STATA & SPSS?
Mention what are the data types does SAS contain?
how many display types available in sas bi dashboard? : Sas-bi
Where do you use proc means over proc freq?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what has been your most common programming mistake? : Sas programming
Describe the function and utility of the most difficult SAS macro that you have written?