Hello,
I have created a text prompt "Variable_List" with Multiple Values. I want to resolve this Text Type macro in my code.
Previously, I was using limited number of variables with manual input in the macro variable " varlist".
%let varlist = TBM_STAGE1 TBM_STAGE2 SHIFT_BUILD_DATE BLADDER;
I was using the below format for count and then loop across these variables to get the output.
/*4.Looping through the Variables and checking the Data Type with Put Statement at the end*/
%do I=1 %to %sysfunc(countw(&varlist));
%let var = %scan(&varlist, &I);
My question is I just have to Substitute the &varlist with &Variable_List. in the Do statement? Kindly let me know if you need further input.
SAS creates an additional variable named "Variable_List_Count" and sets it to the number of values selected. If more than one value was selected, than the values are in the variables "Variable_List1", "Variable_List2" ...
The following step should create the macro-variable varlist in the already used format.
data _null_;
length varList $ 1000;
do i = 1 to &Variable_List_Count.;
if i = 1 then do;
varlist = catx(' ', varList, symget("Variable_List"));
end;
else do;
varlist = catx(' ', varList, symget(cats("Variable_List", i)));
end;
end;
call symputx('varList', varList);
run;
SAS creates an additional variable named "Variable_List_Count" and sets it to the number of values selected. If more than one value was selected, than the values are in the variables "Variable_List1", "Variable_List2" ...
The following step should create the macro-variable varlist in the already used format.
data _null_;
length varList $ 1000;
do i = 1 to &Variable_List_Count.;
if i = 1 then do;
varlist = catx(' ', varList, symget("Variable_List"));
end;
else do;
varlist = catx(' ', varList, symget(cats("Variable_List", i)));
end;
end;
call symputx('varList', varList);
run;
Perfect!!! Thanks @andreas_lds for explaining the concept behind the work and the code is working exactly what I needed
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.