how to display duplicated observations in a data using base
sas.
Answer Posted / 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 |
Post New Answer View All Answers
Explain how you can debug and test your SAS program?
how does sas handle missing values in sort order? : Sas programming
How does proc sql work?
What versions of SAS have you used (on which platforms)?
What are the statements in proc sql?
what is intially documentation in sas?
is data integration and etl programming is same? : Sas-di
Difference between nodup and nodupkey options?
How to convert a numeric variable to a character variable?
How does the internal authentication work in sas? : sas-grid-administration
Describe the function and utility of the most difficult SAS macro that you have written?
Tell e how how dealt with..
Did you used proc test? when?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
what are all the reports you generated in your recent project?