Hi, I'm having trouble getting ODS Excel to output a .xlsx file in the format I'd like. I have the code: %MACRO print (cat=, colcat=, subcat=, blank=); ods excel file= "&outpt.&filedate Target All Bed Day Variance.xlsx"; ods excel options(sheet_name= "&subcat &colcat" sheet_interval='none' absolute_column_width = "8,9,7,7,6,6,9,7,7,6,6,9,7,7,6,6,9,7,7,6"); /* lots of unshown, not relevant to question code here */ run; ods excel close; %MEND print; %print (cat=PCSA, colcat=PCSA, subcat=NORTH, blank=mob); %print (cat=PCSA, colcat=PCSA, subcat=EAST, blank=mob); Because I'm restating the file location within the macro, the file is overwritten each time I call the macro, and instead of getting a .xlsx file with two sheets (one for each time the macro is called), I only get the sheet created for the last time the macro is called. If I remove the file path outside (above) the macro, I get the error: ERROR: Insufficient authorization to access /apps/sas/sas94/config/Lev1/NWWest/sasexcl.xlsx. The macro then doesn't know where to look for the file. Any suggestions? Thank you!
... View more