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 cummaltive frequency,and varience in proc unviarte
what is operational data and operational system? : Sas-di
how do the in= variables improve the capability of a merge? : Sas programming
do you need to know if there are any missing values? : Sas programming
How could you generate test data with no input data?
What's the difference between VAR A1 - A4 and VAR A1 - A4?
which features do you use to check the data validations and errors? : Sas-administrator
How to create an external dataset with sas code?
What is the length assigned to the target variable by the scan function?
What are the ways in which macro variables can be created in sas programming?
Are you involved in writing the inferential analysis plan? Tables specifications?
What areas of SAS are you most interested in?