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 do you use the do loop if you don’t know how many times you should execute the do loop?
what is study design in while working with SAS? what are screening variables in SAS?
name few built in sas transformation in DI studio ?
describe about joins? briefly?
what is the difference between the SAS v8 and SAS v9?
sas macros
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
How do you put an elephant in the refrigerator?
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
what do you mean by data staging area? : Sas-di
Identify statements whose placement in the DATA step is critical.
what is the difference between informat$8. $char8.