topic Re: Counting the number of obs based on soc sec num in SAS Procedures

Counting the number of obs based on soc sec num

GreggB — Fri, 10 Apr 2015 17:25:10 GMT

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>

Re: Counting the number of obs based on soc sec num

Reeza — Fri, 10 Apr 2015 17:41:01 GMT

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

proc freq data=allsets noprint;

table ssn/out=want;

run;

Re: Counting the number of obs based on soc sec num

GreggB — Fri, 10 Apr 2015 17:45:31 GMT

Yes, perfect. Thanks.