Hello, I have a program I'm running every month, so I've set up %let statements at the beginning of my program for whoever is running this to change. I'd like to construct other variables from these values, and so far I can do this for numeric variables fine, but I'm struggling with string variables. Here's what I'm doing: ******************THESE LINES NEEDS TO BE CHANGED EVERY MONTH*****************;
%let year = 2023;
%let month = 08;
**********************************************************************************;
*---- this section constructs program-wide values from the month and year input above -------;
%let current_month = &year. *100 + &month.; *gets a numeric value in the 6-digit BLS format: e.g. 202002 for Feb 2020;
%let end_month = (&year. - 1) * 100 + (&month. - 1);
*%let length month_str $8.;
%let month_str = "";
if &month. = "01" then &month_str = "January";
else if &month. = "02" then &month_str = "February";
else if &month. = "03" then &month_str = "March";
else if &month. = "04" then &month_str = "April";
else if &month. = "05" then &month_str = "May";
else if &month. = "06" then &month_str = "June";
else if &month. = "07" then &month_str = "July";
else if &month. = "08" then &month_str = "August";
else if &month. = "09" then &month_str = "September";
else if &month. = "10" then &month_str = "October";
else if &month. = "11" then &month_str = "November";
else if &month. = "12" then &month_str = "December"; The month_str section is not working. I think it's due to the if statements being outside a data step. All suggestions or insights are appreciated!
... View more