Hi, I'm new to SAS programming and I'm trying to store different values in different macro variables automatically with the following code:
data _null_;
set TABLE_WITH_DAYS;
call symput ('dia'||left(_n_),trim(day);
call symput ('ndia',_n_);
run;
With this code, what I do is store in macrovariables with different names (&dia1, &dia2, &dia3, &dia4...) the following values (20220101,20220102,20220103,20220104...). The problem is that it returns macros with numerical values and I want the days to be in string like this: ('20220101','20220102','20220103','20220104').
I have tried to do it this way but it doesn't work for me, would someone know where I should put the "put" function or how I should do it?
data _null_;
set TABLE_WITH_DAYS;
call symput ('dia'||left(_n_),strip(put(day, best32.)));
call symput ('ndia',_n_);
run;
These are the macro variables that I generate with the first code, what I want is for it to return the values in string instead of numeric:
Thanks in advance.
... View more