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
Difference between informat and format?
What is the difference between INPUT and INFILE ?
how to change the execute of macro
What are the table names in oracle database...?
what is the Population you used in your project, is it ITT or PP?
describe about metadata object? : Sas-di
What is the difference between one to one merge and match merge? Give an example.
What are the features of SAS?
What would you change about your job?
What are the features of base sas system?
what is sas olap server? : Sas-di
What is the difference between %local and %global? : sas-macro
In sas, what are the areas that you are most interested in? : sas-grid-administration
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming