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 |
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the main differences between sas versions 8.2, 9.0, 9.1?
how will you locate the sas platform applications? : Sas-bi
What is the difference between class statement and by statement in proc means?
where are dashboard components are created and maintained? : Sas-bi
Under what circumstances would you code a SELECT construct instead of IF statements?
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?
Name types of category in which SAS Informats are placed?
How necessary is it to be creative in your work?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
Code a PROC MEANS that shows both summed and averaged output of the data.