Counting the number of obs based on soc sec num

[GreggB]

I have a data set sorted by social security number.  I want to use (I think) a proc summary with an OUT = option that reports the number of times each social security number appears in the data set.

Maybe something like

proc sort data=allsets;

by ssn;

proc summary data=allsets out=ssn_count;

var ssn.

...<not sure about the rest>

[Reeza · Accepted solution]

Since it's a frequency count, perhaps use PROC FREQ instead?

proc freq data=allsets noprint;

table ssn/out=want;

run;

[GreggB]

Yes, perfect.  Thanks.