how to display duplicated observations in a data using base
sas.
- 13 Answers
- 27961 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / prakash hullathi
use frequency procedure with single column
data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc freq data=dups;
tables var1/norow nocol nopercent;
run;
The output will be like this
var1 frequency cumulative frequency
1 1 1
2 1 2
3 2 4
4 2 6
5 1 7
6 1 8
here the observations for the variable var1 3 and 4 are
appered 2 times and remaining appeared for 1 time by
seeing the frequency of corresponding variable and
observation
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the data types in sas?
What Proc glm does?
What system options would you use to help debug a macro? : sas-macro
is data integration and etl programming is same? : Sas-di
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
describe about metadata object? : Sas-di
What was the last computer book you purchased? Why?
Explain the use of proc gplot? : sas-grid-administration
What is the basic syntax of a sas program?
what is null hypothesis? why do you consider that?
Explain the difference between nodup and nodupkey options?
What are the parameters of scan function?
For what purposes have you used sas macros? : sas-macro
What is the good sas programming practices for processing large data sets?
Describe the function and untility of the most difficult SAS macro that you have written.
