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
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.
x1 = 0 le z2 le 14;
x2 = 15 le z2 le 65;
x3 = z2 gt 65;
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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.