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 is sas application server? : Sas-di
What is the order of application for output data set options, input data set options and SAS statements?
Compare sas with other data analytics tools.
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
Explain input and put function?
what is change analysis in sas di ? : Sas-di
what is the purpose of _error_? : Sas programming
Explain the difference between using drop = data set option in set and data statement?
How we can call macros with in data step? : sas-macro
what is the difference between nodup and nodupkey options? : Sas programming
What do you understand by the term Normal Distribution?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What does the trace option do?
I need level 2 to 5 sas using companies in india
If a variable contains only numbers, can it be a character data type?