Interested to Buy Any Domain ? << Click Here >> for more details...
how to display duplicated observations in a data using base
sas.
- 13 Answers
- 30971 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 |
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
How to save the log information in a file for future use
how can u create zero observation dataset?
how does sas handle missing values in a merge? : Sas programming
how to handle in stream data containing semicolon in it?
Why is SAS considered self-documenting?
Which function is used to count the number of intervals between two sas dates?
What is the difference between proportion and average?
why is sas considered self-documenting? : Sas programming
what is SAS/Graph?
what is function of retain statment
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
Teradata 
