how do we get duplicate observations in a separate dataset?
- 6 Answers
- 12445 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bitla
ex:
data dup1 dup2;
set original;
by dup_var;
if first.dup_var then output dup1 else output dup2;
run;
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / mallikarjuna reddy.vanna
use DUPOUT option in proc sort statement.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / 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 |
Answer / vipin choudhary
Proc sort data = indata;
by name;
run;
Data outdata;
set indata;
by name;
if first.name and last.name then delete;
run;
proc print data = outdata;
run;
or else you can use the dupout option in proc sort
| Is This Answer Correct ? | 4 Yes | 2 No |
First sort them in descending order and then using first.var
separate all the first observations into a new dataset and
the remaining into another. So unique observations from each
group
will come into one dataset and the other duplicate
observations will enter into another dataset.
| Is This Answer Correct ? | 2 Yes | 1 No |
proc sql;
create table dup_obs as (
select * from <lib>.<dsn>
group by <dup var>,<list of other vars>
having count(*)>1 )
quit;
| Is This Answer Correct ? | 4 Yes | 3 No |
do you need to know if there are any missing values? : Sas programming
What can you learn from the SAS log when debugging?
What areas of SAS are you most interested in?
What is the work of tranwrd function?
is QUALCOMM using SAS ?
Where do the database management systems store data and how do u import them.
how to perform paired t-test using Base/SAS & SAS/Stat?
What report output formats can you generate using SAS?
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
which date function advances a date, time or datetime value by a given interval? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
how can you create zero observation dataset? : Sas programming
Teradata 
