how to display duplicated observations in a data using base
sas.
Answers were Sorted based on User's Feedback
Answer / ganesh k
data dset1;
set dset;
by var1;
if last.var1>1 then output;
run;
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / suresh babu prattipati
hi,
to display the dups in seperate dataset please find the
below program.
eg:
data dups;
input var1;
1
2
3
4
4
3
5
6
;
run;
/*to find the dups*/
data dups1;
set dups;
by var1;
if not(first.var1 and last.var1) then output;
run;
*now you can see the dups ;
If any one have any sas question please e.mail me to
suresh.sasv9@gmail.com
thanks
suresh
| Is This Answer Correct ? | 5 Yes | 9 No |
Answer / harish
we can find duplicated by using missover&scanover
| Is This Answer Correct ? | 2 Yes | 17 No |
what is the difference between floor and ceil functions in sas? : Sas-administrator
Explain how merging helps to combine data sets.
how we can create optional or required parameters in SAS macro...
What are the criticality that you have faced during your project in SAS?
what is sas olap server? : Sas-di
How to convert .xls file into CSV format?
What sas features do you use to check errors and data validation?
for what purpose would you use the retain statement? : Sas programming
What is the difference between proportion and average?
Of all your work, where have you been the most successful?
What is a pdv and what are its functions?
What are the differences between proc means and proc summary?