how to display duplicated observations in a data using base
sas.
- 13 Answers
- 27021 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
two ways u can do ot.
1. proc sort with dupout option.
2. data step:
data nodups dups;
set sample;
by x;
if first. and last. then output nodups;
else output dups;
run;
proc print data=dups;
run;
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / m.sivakumar
data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc sort data=dups;
by var1;
run;
data dups1;
set dups;
by var1;
if not(first.var1 and last.var1) then output;
run;
proc print data=dups;
run;
proc print data=dups1;
run;
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / pratik
By using Dopout option we can display duplicate observation.
Proc sort data=datasetname1 nodupkey dopout=datasetname2;
by varaible.
run;
proc print data=datasetname2;
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lakshmi
proc sort data=data1 out=data2 dupout=dup_data1 nodupkey;
by usubjid;
run;
the dataset dup_data1 has the duplicate observation.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sheetal
If you are using SAS version 9 then use dupout option with
proc sort.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / prakash hullathi
use frequency procedure with single column
data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc freq data=dups;
tables var1/norow nocol nopercent;
run;
The output will be like this
var1 frequency cumulative frequency
1 1 1
2 1 2
3 2 4
4 2 6
5 1 7
6 1 8
here the observations for the variable var1 3 and 4 are
appered 2 times and remaining appeared for 1 time by
seeing the frequency of corresponding variable and
observation
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / pranitha patel
By using dupout option...
Proc sort data = X out = Xclean
Dupout = X dups nodupkey :
By variable :
Run:
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manoj
Dupout Option
It is available on V9.1 onwards.
proc sort data=demo dupout=demo1 out=demo3 nodupkey;
by var1;
run;
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / dilip
proc sort data=x out=y;
by v;
data m;
set y;
by v;
if first.v and last.v then delete;
run;
this is for extracting duplicate observations
from a dataset
| Is This Answer Correct ? | 1 Yes | 3 No |
how can u join the two tables without using proc sql Joins and nested queries ?
sas implimented companies in hyderabad
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
What is data _null_?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What is highest missing value for numeric?
What are the scrubbing procedures in sas?
What are the implications?
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
Name and describe three SAS functions that you have used, if any?
Teradata 
