how to display duplicated observations in a data using base
sas.
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 that sas contain?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
describe about physical data integration? : Sas-di
What are all the problems you faced while validating tables and reports?
what is broad cast agent? : Sas-bi
what r the job openings SAS for fresher graduates !
Define run-group processing?
how to remove duplicates using proc sql?
What areas of SAS are you most interested in?
Intern stastical programmer written test
what is the purpose of _error_? : Sas programming
how can you import .csv file in to sas? : Sas programming
what is null hypothesis? why do you consider that?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;