how to display duplicated observations in a data using base
sas.
- 13 Answers
- 27015 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 |
what is the use of proc sql?
. Which date advances a date, time or date/time value by a given interval?
how to intersect the tables by using PROC MIXED?
What is the difference between the proc sql and data step?
Tell me about % include and % eval? : sas-macro
Do you need to rearrange the order of the data for the report?
Describe the function and untility of the most difficult SAS macro that you have written.
how can you create zero observation dataset? : Sas programming
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
tell me about intnx, intcx functions?
Name and describe few sas character functions that are used for data cleaning in brief.
Explain translate function?
Teradata 
