Hi - thank you for your response! the following code works to put the date into the format I need. I had attempted this earlier, and kept getting an error I could not resolve. date_f1=catt('Q', put(qtr(date), 1.), put(year(date), 4.)); now, my issue is to use that process in the following code. "filedate" is a sas date that is on my incoming dataset. the objective is to re-label 7 quarters of wage data (labeled wage1, wage2, etc) with the name of the quarter it represents. the data is for 7 consecutive quarters, so I'm looking to rename 7 variables. the file (and thus the filedate and the variable names) update quarterly. my code below would work except yyq. (and all the other qtr formats) start with a number value (2018-1) and thus can't be used as a variable name. I am open to ANY easy workaround. call symput("wage_1", put(filedate, yyq.)); call symput("wage_2", put(intnx('QTR', filedate, -1), yyq.)); call symput("wage_3", put(intnx('QTR', filedate, -2), yyq.)); call symput("wage_4", put(intnx('QTR', filedate, -3), yyq.)); call symput("wage_5", put(intnx('QTR', filedate, -4), yyq.)); call symput("wage_6", put(intnx('QTR', filedate, -5), yyq.)); call symput("wage_7", put(intnx('QTR', filedate, -6), yyq.));
... View more