Hey there, So I've been spinning my wheels at this for way too long that I feel like there must be a better way. I have an excel workbook that I have assigned a libname and I would like to do formatting on the sheets which are labeled in a way that I thought would be conducive to set up a loop. Unfortunately the fact that the sheets are named with single quotes around them makes referencing a macro variable difficult. This is my closest attempt but the quotes get lost in the call symputx statement. Any help would be greatly appreciated libname &facil_export. "&path.\&facil_export._clean.xlsx"; %macro import_loop; %do i = 1 %to &periods.; %let sheet = "Period (&i.)$"; %let the_n = n; data _null_; format sheet_v2 $15.; sheet_v2 = tranwrd(&sheet.,'"',"'"); call symputx('sheet_final', sheet_v2); run; data &facil_export._&i.; set &facil_export..&sheet_final.&the_n.; run; %end; %mend; %import_loop;
... View more