Since you don't tell us what these "various data tasks" are, I create my own. I will use each value of code in a text file (not an excel file) and then do, in my example: proc print data=real_data(where=(id=44123320)); run;   Here is the text file named example_data.txt   44123310 44123320 44123390   here is the SAS code   data _null_; infile "example_data.txt"; input code; call execute(cats('proc print data=real_data(where=(id=',code,')); run;')); run;   You will see in the log that the desired PROC PRINTs appear (they don't run because I don't really have data). You could also use macros inside CALL EXECUTE if that would work better. Depending on what you are trying to do (which you really didn't tell us), macros may or may not be needed.   ... View more

Adding, with the %INM macro, the code doesn't even require loops. This is the data step IN function, converted to work on macro variables   %macro inm(slist,s); /* SAS Macro %inm to see if &s is contained in a string or list &slist */ /* Borrowed from https://groups.google.com/forum/#!topic/comp.soft-sys.sas/fWcSDgg11tE */ %if %sysfunc(indexw(&slist,&s)) gt 0 %then 1 ; %else 0; %mend; %let current_date = %sysfunc(today()); /* Today is 11DEC2023, the integer value for this date is 23355 */ %let holiday_list = 25DEC2023 08DEC2023 ; /* Function to check if a date is in the holiday list */ %macro is_holiday(date); %let prev_working_date=%sysfunc(intnx(weekday,&date,-1)); /* Use INTNX with the WEEKDAY interval to find the previous weekday */ /* &DATE is 11DEC2023, which is 23355; &prev_working_date is the previous Weekday which is Friday which is 08DEC2023 which is 23352 */ %if %inm(&holiday_list,%sysfunc(putn(&prev_working_date,date9.))) %then %let holiday=1; /* Is holiday the previous weekday? */ %let prev_working_date=%eval(&prev_working_date-&holiday); %let human_readable_date=%sysfunc(putn(&prev_working_date,date9.)); %put &=date &=prev_working_date &=human_readable_date &=holiday ; %mend; %is_holiday(&current_date) ... View more

From now on, ALWAYS (that's 100% of the time, no exceptions) when you have to do arithmetic or logical operations on dates (like finding previous date, or comparing one date to another), you need to use valid SAS numeric dates, which are the number of days since 01JAN1960. Do not work with dates as strings like 08DEC2023 that you then have to pull apart and perform your own arithmetic on, and combine in some meaningful way.   SAS has already done the hard work by providing functions, formats and informats that make handling dates as valid numeric SAS dates very very easy, so you don't have to figure out how to handle them yourself. The INTNX function, with the WEEKDAY time interval and -1 as the increment, finds the previous weekday, it knows that the previous weekday from a Monday is the Friday before and does the arithmetic for you.   This code illustrates that   %let current_date = %sysfunc(today()); /* Today is 11DEC2023, the integer value for this date is 23355 */ %let holiday_list = 08DEC2023 25DEC2023; /* Function to check if a date is in the holiday list */ %macro is_holiday(date); %let holiday = 0; %do i = 1 %to %sysfunc(countw(&holiday_list)); %let this_holiday=%scan(&holiday_list,&i,%str( )); /* Find the i-th holiday from the list in &holiday_list */ %let this_holiday=%sysfunc(inputn(&this_holiday,date9.)); /* Convert to actual numeric SAS date value, which for 08DEC2023 is 22352 */ %let prev_working_date=%sysfunc(intnx(weekday,&date,-1)); /* Use INTNX with the WEEKDAY interval to find the previous weekday */ /* &DATE is 11DEC2023, which is 23355; &prev_working_date is the previous Weekday which is Friday which is 08DEC2023 which is 23352 */ %if &prev_working_date = &this_holiday %then %let holiday = 1; /* Is holiday the previous weekday? */ %let prev_working_date=%eval(&prev_working_date-&holiday); %let human_readable_date=%sysfunc(putn(&prev_working_date,date9.)); %put &=i &=date &=this_holiday &=prev_working_date &=holiday &=human_readable_date; %if &holiday=1 %then %goto finish; %end; %finish: %mend; %is_holiday(&current_date)     Only if you need dates that are readable by humans would you format the values. So this line in the code produces a human readable date, for example, 07DEC2023     %let human_readable_date=%sysfunc(putn(&prev_working_date,date9.));   ... View more

Data step #2 does not know about arrays created in data step #1. You would have to define the same arrays in data step #2 in order to work with arrays in data step #2. ... View more

What is the value of the macro variable &length_var ?   Can you show us the entire code instead of fragments?   You mention tagsets.excelxp but you are not using tagsets.excelxp, why? You are using ODS EXCEL, not tagsets.excelcp ... View more

Google finds an answer quickly https://blogs.sas.com/content/graphicallyspeaking/2013/11/21/comparative-histograms/   and other solutions are found via Google as well ... View more

After creating data set HAVE, run PROC SUMMARY to get the sums, and then run PROC SGPLOT on the output created by PROC SUMMARY. ... View more

@MILKYLOVE wrote:   How do I point to a file repository if I don't have one? You can't.   Your logic is flawed somewhere. The code requires reading something from the file identified as FIC, and yet you don't have such a file. You tell me how to fix this in words (not in SAS code), because I don't know what you are trying to do. ... View more

SAS doesn't know what fic is, because you haven't defined it. You need to tell SAS what file you want to denote as fic by using a FILENAME statement to point to the desired file. ... View more

I would try combining the two macros. You don't need a macro that creates one part of a compute block and a different macro to create another part of the compute block. ... View more