The code below references the attached data set. I know that I can drop three variables and even more at a time from the array 'month' by simply changing the number of elements in me array. Is there a simpler way for me to also add three or more variables at a time, without having to write them out one after the other as I have done with month16, month17, and month18 below? All new variables added would have the same value.
data hpi;
set example;
array month{15} month1-month15;
drop month13-month15;
month16=month15;
month17=month15;
month18=month15;
run;
data hpi;
set example;
array month{15} month1-month18; /* if a variable doesn't already exist but is referenced when creating an array the variable will be created*/
drop month13-month15;
do _i_ = 16 to 18; month[_i_] = month15; end;
run;
data hpi;
set example;
array month{15} month1-month18; /* if a variable doesn't already exist but is referenced when creating an array the variable will be created*/
drop month13-month15;
do _i_ = 16 to 18; month[_i_] = month15; end;
run;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.