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
What is the difference between nodupkey and nodup options?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
how can you import .csv file in to sas? : Sas programming
what are all the reports you generated in your recent project?
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?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
Which are the statements whose placement in the data step is critical?
Explain proc univariate?
Explain what is SAS informats?
what is sas application server? : Sas-di
what are some differences between proc summary and proc means? : Sas programming
What is the command used to find missing values?
What is SAS? What are the functions does it performs?
where to use sas business intelligence? : Sas-bi