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>
Since it's a frequency count, perhaps use PROC FREQ instead?
proc freq data=allsets noprint;
table ssn/out=want;
run;
Since it's a frequency count, perhaps use PROC FREQ instead?
proc freq data=allsets noprint;
table ssn/out=want;
run;
Yes, perfect. Thanks.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.