Another tip.  Only using the ancient CALL SYMPUT() routine if it is important that the resulting macro variable contains leading and/or trailing spaces.   Otherwise use the new (available since at least version 6 of SAS) CALL SYMPUTX() routine, which automatically remove the trailing and leading spaces. ... View more

I second @PaigeMiller 's request for an explanation of what you are trying to do.   As it stands, I don't have any idea.   But the code presented has the earmarks of a hammer looking for a nail.  You might be offered a simpler alternative if we had a clearer idea of the objective. ... View more

I like @Patrick's second solution.   data my_new_table; set my_old_table; format date date9.; if market = "xxxx" then do date = '01jan2022'd to '31dec2022'd; qtr=qtr(date); output; end; run; You say you want to calculate the number of days in each quarter but don't show how it's used.    If after all this you still do not have a solution that works, I would suggest taking a step back as this is definitely an xy problem. Rather than posting your non working code, please show us a small sample of your input data and what you want as output instead.    ... View more

Thanks a lot. It worked. ... View more

Thank you for your help. it worked/  ... View more