If you can post some sample that, that will help us try out various solutions.   To be coded like the example you referenced (https://blogs.sas.com/content/graphicallyspeaking/files/2014/06/Swimmer_93.txt), you'll need to add nocycleattrs to the proc sgplot line   proc sgplot data = all_therapy dattrmap=attrmap nocycleattrs;   Also, make sure that all the values in your 'attrmap' dataset are reading in correctly. I assume the way your code is written that your code & datalines is in the correct columns it's looking for(?), but that when you copy-n-pasted it into the comment above it collapsed the spaces(?) Here's a slightly different version of the code that doesn't depend on the datalines being column-delimited, if you need it:   data attrmap; length id $10 value $20 linecolor fillcolor $20; infile datalines dlm=','; input ID value linecolor fillcolor; datalines; trtcat1,Any immuno,blue,blue trtcat1,Any other,charcoal,charcoal trtcat1,Chemo,orange,orange trtcat1,SRS,green,green trtcat1,Targeted,purple,purple trtcat1,WBRT,black,black trtcat1,cranio,gold,gold trtcat1,radio,pink,pink trtcat2,Any immuno,blue,blue trtcat2,Any other,charcoal,charcoal trtcat2,Chemo,orange,orange trtcat2,SRS,green,green trtcat2,Targeted,purple,purple trtcat2,WBRT,black,black trtcat2,cranio,gold,gold trtcat2,radio,pink,pink trtcat3,Any immuno,blue,blue trtcat3,Any other,charcoal,charcoal trtcat3,Chemo,orange,orange trtcat3,SRS,green,green trtcat3,Targeted,purple,purple trtcat3,WBRT,black,black trtcat3,cranio,gold,gold trtcat3,radio,pink,pink trtcat4,Any immuno,blue,blue trtcat4,Any other,charcoal,charcoal trtcat4,Chemo,orange,orange trtcat4,SRS,green,green trtcat4,Targeted,purple,purple trtcat4,WBRT,black,black trtcat4,cranio,gold,gold trtcat4,radio,pink,pink ; run; ... View more

You can create a dynamic piece of code and store it in a macro variable for use in the data step: data have; input age first_exvar other_var_1 other_var_2; cards; 60 1 2 1 ; run; proc sql noprint; select "first_exvar = " !! name into :compare_str separated by " or " from dictionary.columns where libname = 'WORK' and memname = 'HAVE' and upcase(name) like '%OTHER_VAR%'; quit; %put &compare_str.; Log excerpt: 40 %put &compare_str.; first_exvar = other_var_1 or first_exvar = other_var_2 ... View more

Sample data would help a lot in explaining your problem.  Also having a working SAS program before trying to figure out how to generate it with macro logic would help a lot.   Sounds like you want to place the list of values into separate macro variables and then also have a macro variable that lists the macro variables? In that case list the NAMES of the macro variables, not their values. %let color='red' 'green'; %let style='modern' 'classic'; %let allfactors = color style ; And the code you want to generate is essentially  color = MYVAR in ('red' 'green'); style = MYVAR in ('modern' 'classic'); So your %DO loop should look like: %local i factor ; %do i=1 %to %sysfunc(countw(&allfactors)); %let factor=%scan(&allfactors,&i); &factor = MYVAR in (&&&factor) ; %end;  If you just want to name the factors FACTOR1, FACTOR2, etc then you don't need the list. Instead you just need to know how many factors there are. %local i; %do i=1 %to &n_factors ; factor&i = MYVAR in (&&factor&i) ; %end; ... View more