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 |
How many tiers in sas architecture?
what is sas and what are the functions? : Sas-administrator
How are the analysis data sets structured?
how do you read binary data in sas?
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
What are the statements that are executed only?
What is the basic structure of the SAS base program?
how does sas handle missing values in procs? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
Which is the best training institute for SAS in Delhi. Please reply
where are dashboard components are created and maintained? : Sas-bi
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?