BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

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;
2 REPLIES 2
Patrick
Opal | Level 21

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);
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 926 views
  • 0 likes
  • 3 in conversation