Interested to Buy Any Domain ? << Click Here >> for more details...
how to display duplicated observations in a data using base
sas.
- 13 Answers
- 30507 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 is character variable converted into numeric variable and vice versa?
what is the difference between SET and MERGE?
What does PROC print, and PROC contents do?
Describe the function and utility of the most difficult SAS macro that you have written?
what is hash files in sas and why we are using this one in sas?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is data _null_?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
What is the difference between Proc tabulate and Proc print
which domain is better in sas? clinical trails or banking
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
Teradata 
