Solved: Creating Age Groups

mshelmike · Posted 12-15-2019 12:59 PM

Please help me out. I am trying to group Age variable say <10, 11-20, 30-40 and 40> and compute the number of occurence that falls within the range but I have been having challenge doing it. I am using the SAS studio

mkeintz · Posted 12-15-2019 01:32 PM

You can do a frequency of AGE using proc freq. But the problem is that it will tabulate individual age values, rather than the age groups of interest to you.

You could create a new variable, AGE_GROUP, calculated from AGE, and then get a frequency table of the new variable. Or I recommend you create a format for AGE, which establishes age groups. And then tell PROC FREQ to do a frequency of AGE using the format you have defined.

Have you set up the proc freq (without grouping) yet? I recommend you show that code, and then we can be more useful in helping you.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

View solution in original post

mkeintz · Posted 12-15-2019 01:32 PM

You can do a frequency of AGE using proc freq. But the problem is that it will tabulate individual age values, rather than the age groups of interest to you.

You could create a new variable, AGE_GROUP, calculated from AGE, and then get a frequency table of the new variable. Or I recommend you create a format for AGE, which establishes age groups. And then tell PROC FREQ to do a frequency of AGE using the format you have defined.

Have you set up the proc freq (without grouping) yet? I recommend you show that code, and then we can be more useful in helping you.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

mshelmike · Posted 12-20-2019 05:42 AM

Thank you for the suggestion. I created AGE_GROUP, calculated from AGE, and then got a frequency table of the new variable.

Creating Age Groups

Re: Creating Age Groups

Re: Creating Age Groups

Re: Creating Age Groups

Creating Age Groups

Re: Creating Age Groups

Re: Creating Age Groups

Re: Creating Age Groups

The 2025 SAS Hackathon Kicks Off on June 11!

SAS Training: Just a Click Away