how to display duplicated observations in a data using base
sas.
- 13 Answers
- 28924 Views
- HCL, TCS, I also Faced
- E-Mail Answers
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 does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
What is the registered Key word is sas????
What are the difference between ceil and floor functions in sas?
What are the features of base sas system?
what type of reports you are generating in your company...???
2 Answers GSK GlaxoSmithKline,
Name statements that are execution only.
How would you determine how far down on a page you have printed in order to print out footnotes?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
how are numeric and character missing values represented internally? : Sas programming
what is operational data and operational system? : Sas-di
What is difference between rename and lable in sas?
how can get the first and last observations in a dataset using Proc SQl?
Teradata 
