As suggested by Reeza, I am trying to reorganize my data into a long structure opposed to wide to reduce processing time as well as make the coding faster. Currently, the data is organized a structure where it has main variables such as Recreation, Financial Plan, Legal, Housing, Gift, Education. However, these variables were created in a way that works like Pre_ResYr6thM_Recre and so forth. I am looking for some sample code to pull the "Pre_ResYrNthM" part from each variable to make a several new variables for the Month, Quarter, Half Year and Year as well as variables for Recreation. I have tried something to the effect of : data Org;
set infl.arc_inflation_jb_102618;
if Preresyr1stM: then Month = 1;
else if Preresyr2ndM: then Month = 2;
else if Preresyr3rdM: then Month = 3;
else if Preresyr4thM: then Month =4;
else if Preresyr5thM: then Month =5;
else if Preresyr6thM: then Month =6;
else if Preresyr7thM: then Month =7;
else if Preresyr8thM: then Month =8;
else if Preresyr9thM: then Month =9;
else if Preresyr10thM: then Month =10;
else if Preresyr11thM: then Month =11;
else if Preresyr12thM: then Month =12;
run; I was then going to just keep the main variables and have a structure like StudyNo PID Day_1826 Day_InitialIW Month Quarter Half_year PreRes_Consume PreRes_COnsume_Total PostRes_Consume PostRes_Consume_Total PreRes_Durable PreRes_Durable_Total 1 1 30Dec1992 05Oct1993 1 1 1 600 600 1 1 30Dec1992 05Oct1993 2 1 1 600 1200 I was hoping to find some sample code or an old forum for the code but not sure how to pull main character strings from the variables to create the new variables I also tried an iteration that looked like this: data Org;
set infl.arc_inflation_jb_102618;
if var like %Preresyr1stM% then Month = 1;
.
.
.
.
run;
... View more