## Creating Age Groups from Age Variable

Solved
Occasional Contributor
Posts: 7

# Creating Age Groups from Age Variable

Hello team,

i am trying to group the variable "age" to assign a dummy with groupings 0-14 years, 15-65 years and above 65 years. My variable representing age is z2. How do I set the codes please?

James

Accepted Solutions
Solution
‎06-26-2017 02:35 PM
Super User
Posts: 13,941

## Re: Creating Age Groups from Age Variable

If you use formats such as @Jim_G suggested then you can avoid adding variables to the data set for almost any analysis tasks. The groups assigned by a format will be used in almost all of the analysis procedures and have the very signficant advantage of if you want to see what the difference may be when you change the boundary for one of the categories you make a new custom format and use that in the procecure code for the age variable. No added variables and if you data is largish then you don't spend extra time with multiple data sets.

All Replies
SAS Super FREQ
Posts: 508

## Re: Creating Age Groups from Age Variable

x1 = 0 le z2 le 14;

x2 = 15 le z2 le 65;

x3 = z2 gt 65;

Occasional Contributor
Posts: 7

## Re: Creating Age Groups from Age Variable

Thank you although I did not want to add extra variables x1, x2 and x3. I have apparently used

if age <= 15 then z2=1;else if 12 <= age < 65 then z2=2;else if age >=65 then z2=3; and it has worked.

Thanks so much.

James
Frequent Contributor
Posts: 102

## Re: Creating Age Groups from Age Variable

` proc format; value  age  0-14='0-14  ' 15-65='15-65'  65-120='gt 65';      data;   input name \$ age ;    format age age.;    cards;  mary 12  joe  60  ;    proc print;  run`
` proc format; value  age  0-14='0-14  ' 15-65='15-65'  65-120='gt 65';      data;   input name \$ age ;    format age age.;    cards;  mary 12  joe  60  ;    proc print;  run`

` proc format; value  age  0-14='0-14  ' 15-65='15-65'  65-120='gt 65';      data;   input name \$ age ;    format age age.;    cards;  mary 12  joe  60  ;    proc print;  run`

You can use proc format   like this;

proc format; value  age

0-14='0-14  '
15-65='15-65'
65-120='gt 65';

data;   input name \$ age ;
format age age.;
cards;
mary 12
joe  60
;

proc print;  run

Jim

Solution
‎06-26-2017 02:35 PM
Super User
Posts: 13,941

## Re: Creating Age Groups from Age Variable

If you use formats such as @Jim_G suggested then you can avoid adding variables to the data set for almost any analysis tasks. The groups assigned by a format will be used in almost all of the analysis procedures and have the very signficant advantage of if you want to see what the difference may be when you change the boundary for one of the categories you make a new custom format and use that in the procecure code for the age variable. No added variables and if you data is largish then you don't spend extra time with multiple data sets.

☑ This topic is solved.