Hello
x is a char column.
When I run this code I get an error
ERROR: Open code statement recursion detected.
What is the reason please?
proc sql noprint;
select distinct x into:month_list separated by '+'
from ttt
;
quit;
%put &month_list;
Bit hard to say if the error gets thrown by the code you show us without seeing the SAS Log.
You could try:
%put %nrbquote(&month_list);
Please supply your dataset in a data step with datalines. I suspect you have macro triggers in variable x.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.