I have a dataset with years 2000-2019 and one variable for each year with the state that reported the data (e.g., STATE_2000, STATE_2001, STATE_2002). I need to populate a variable with the reporting state for each month and year of the data instead of just by year. For example, if I have STATE_2000, I need one for each month like STATE_012000, STATE_022000, STATE_032000, etc. This will just be a copy of the STATE_2000 variable with a new name, 12 times over for each year. I am trying to find a way to succulently write the code instead of writing it all out like this because I have 20 years of data:   data do_not_want; set have; STATE_012000=STATE_2000; STATE_022000=STATE_2000; STATE_032000=STATE_2000; run;   I tried playing around with a macro for the month but I don't think it likes the underscore.    I think I figured out a way to do it with a macro statement for the year but it's only outputting the last year. Here's an example with a couple of years of data:   %macro state_yrs; %do yr=2000 %to 2002; data want; set have; STATE_01&yr=STATE_&yr; STATE_02&yr=STATE_&yr; STATE_03&yr=STATE_&yr; STATE_04&yr=STATE_&yr; STATE_05&yr=STATE_&yr; STATE_06&yr=STATE_&yr; STATE_07&yr=STATE_&yr; STATE_08&yr=STATE_&yr; STATE_09&yr=STATE_&yr; STATE_10&yr=STATE_&yr; STATE_11&yr=STATE_&yr; STATE_12&yr=STATE_&yr; run; %end; %mend state_yrs; %state_yrs;   The output is giving me the variable name I want (STATE_MMYYYY), but in this example, it's only outputting the year 2002 and not 2000 or 2001. Thank you! ... View more

I'm conducting an analysis on SAS 9.4 with health insurance enrollment data and want to understand the enrollment patterns before and after a diagnosis. I have monthly data for several years which I want to select 24 rolling months based around a diagnosis date. I want to copy over the select months into new columns based on the start month range. I have a dummy example below where month1-month7 are the enrollment months 1 through 7 and start_month is the number of the start month and end _month is the number of the end month of the range. I want to copy the data into the "next" variables for a range of 4.  Adding "output" into the code doesn't solve the issue. The desired output at the end of this code. Thank you!   *table creation for 2 examples; data try1; input month1-month7 start_month end_month; datalines; 1 2 3 4 5 6 7 2 4 1 2 3 4 5 6 7 4 7 ; run;  proc print data=try1; run;     *This straight copies the data into the "next" variables, not based on start/end range; data try2; set try1; array month month1-month7; /*enrollment months*/ array next next1-next4; /*want to copy over select months here*/ do i=1 to 4; /*interested in range of 4 months*/ next{i}=month{i}; /*this straight copies the data*/ end; run; proc print data=try2; run;   *HERE IS WHERE I AM STUCK; *Trying to copy the select months based on the start and end range; *This code below only copies the last select month, which is wrong; data try3; set try1; array month month1-month7; /*enrollment months*/ array next next1-next4; /*want to copy over select months here*/ do k=start_month to end_month; /*start month and end month for each person*/ do i=1 to 4; /*interested in range of 4 months*/ next{i}=month{k}; /*this code is incorrect, it just copies the last month */ end; end; run; proc print data=try3; run;     /*This is the desired output*/  data want; input month1-month7 start_month end_month next1-next4; datalines; 1 2 3 4 5 6 7 2 4 2 3 4 . 1 2 3 4 5 6 7 4 7 4 5 6 7 ; run; proc print data=want; run;       ... View more