How to create a categorical age variable based on separate variables month and year of birth?

racekarrz2 — Thu, 08 Jun 2023 17:10:56 GMT

I have 2 separate variables for age, month and year of birth. I want to categorize it into (40-49, 50-59, 60+). I am not sure how to format this new variable? I do not have day of birth.

Thank you!

Re: How to create a categorical age variable based on separate variables month and year of birth?

Tom — Thu, 08 Jun 2023 17:22:49 GMT

@racekarrz2 wrote:

I have 2 separate variables for age, month and year of birth. I want to categorize it into (40-49, 50-59, 60+). I am not sure how to format this new variable? I do not have day of birth.

Thank you!

You need to assume some day of the month for their BIRTH to generate a DATE OF BIRTH. Perhaps the first of the month?

You need a second DATE to be able to calculate AGE from a DATE OF BIRTH. Perhaps the day you run the program?

data want;
  set have;
  dob = mdy(month,1,year);
  age = intnx('year',dob,today(),'s');
  format dob date9.;
run;

To analyze the age groups create a format.

proc format ;
value agegrp
 low-39='Too young'
 40-50='40-50'
 50-59='50-59'
 60-high='60+'
 other='Invalid Age'
;
run;

topic How to create a categorical age variable based on separate variables month and year of birth? in SAS Programming

How to create a categorical age variable based on separate variables month and year of birth?

Re: How to create a categorical age variable based on separate variables month and year of birth?