how to display duplicated observations in a data using base
sas.
- 13 Answers
- 28717 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 do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
how do you test for missing values? : Sas programming
how do you pull data from equifax?tell me the process?
0 Answers Synchrony Financial,
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what do the pad and dim functions do? : Sas programming
What are the features of base sas system?
how do we mail reports from SAS environment to our team leader
How to sort in descending order?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
Teradata 
