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
In proc transpose and data step with arrays which one you pick?
how will you locate the sas platform applications? : Sas-bi
Approximately what date is represented by the SAS date value of 730?
Describe the ways in which you can create a macro variable?
Mention some common errors that are usually committed in sas programming.
how many display types available in sas bi dashboard? : Sas-bi
Differentiate between proc means and proc summary.
What are types of transport files?
How sas treats the dsd delimiters?
Define run-group processing?
What is PDV?
describe the interaction table in sas di? : Sas-di
what is data access? : Sas-di
what is operational data and operational system? : Sas-di
If money were no object, what would you like to do?