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
how do you test for missing values? : Sas programming
why a stop statement is needed for the point= option on a set statement?
What are types of transport files?
Do you need to rearrange the order of the data for the report?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What are the difference between ceil and floor functions in sas?
what are all the reports you generated in your recent project?
what are sas bi dashboard components? : Sas-bi
Can you suggest us materials for sdtm mapping?
If you could design your ideal job, what would it look like?
What is the use of stop statement?
For clinical entire study how many tables will create approx?
Describe 5 ways to do a “table lookup” in SAS?
describe the interaction table in sas di? : Sas-di
What is the difference between one to one merge and match merge? Give an example.