counting number of events by three different variables

[psnorrod]

Hello,

New-ish SAS user here.

I want to count the number of events that occur by year, sex, and age_group. I have attached two data sets where "sample1" represents my data and "sample2" represents what I need for a final product.

Using the code below, SAS will count the number of events but is combining age groups. For example, during 2003 combines the events for age_group=3 into the count of events for age_group=3 for state=27.

/* count code */

proc sort data = one;
by year state;
run;

data two;
set one;
by year state ;
if first.state then count = 0;
count + 1;
if last.state;
keep year count Sex age_group;
run;

"Sample1" represents my data and "Sample2" represents the what I want in a final product.

Thank you!

[ed_sas_member]

Hi @psnorrod

Could you please put your sample data directly in the question as many of us won't download files due to security issues.

Thank you!

[psnorrod]

Yes, thank you for the reminder @ed_sas_member