tagsets.excelxp XML file not opening

[ssaha]

When I am trying to run this below piece of code from SAS EG, the xml file is opening with the required data

ods tagsets.excelxp file="/trnapp/sas/dev/projects/so/shovan/&rep_name._9.xml" style=printer;
proc report data=p.testing;
columns _all_;
define road_number / 'road_number' style={tagattr="format:@"};
run;
ods tagsets.excelxp close;

But when I am trying to run this code from a stored process( The stored process contain several macros and in one of the macro contains the above code) through SAS Portal, I am able to download the file and when I am opening it it is saying "Unable to Read File". The file is getting created in the physical location and the size is only of some KBs and also when I am opening that file it is giving that error. FYI,This code is within a %do; %end clause in one of the macro from the stored process but from SAS EG i was running it without %do; %end.

Can you please help me regarding this.

[ChrisHemedinger]

It's difficult to determine exactly what's going on from your description.  Are you running at least SAS 9.4 Maint 3?  If so, I recommend using ODS EXCEL instead of EXCELXP tagset.  You'll get a native XLSX file (not XML file) that will have fewer problems downstream.

This might not solve this problem, which might be caused by differences in your stored process environment versus standard SAS workspace.