topic create macro var-error in SAS Programming

create macro var-error

Ronein — Sun, 21 Jun 2020 08:14:42 GMT

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;

Patrick — Sun, 21 Jun 2020 08:27:03 GMT

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);

Kurt_Bremser — Sun, 21 Jun 2020 10:21:54 GMT

Please supply your dataset in a data step with datalines. I suspect you have macro triggers in variable x.