Actually, it does all work if yuo prepare the code properly for a stored process web app.
In my post I was trying to get across that the best way to troubleshoot this problem (and develop the application) is to simplify everything.
That is, get it all working in EG first before wrapping it in a stored process / web app.
Your problem was around not being able to create an excel workbook with multiple tabs for different tables. So I got this working for you in EG.
Now that that's working, you need to prepare the code and for the stored process / web app, like you've done for the original app that you have.
And one of those preparation steps is changing the file destination from disk to _webout
Here's the proof. I've prepared my code and put it into a stored process and executed the stored process in the Stored Process WebApp:
And here's the code I put into the stored process:
*ProcessBody;
data _null_;
rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
rc = stpsrv_header('Content-disposition','attachment; filename=test.xlsx');
run;
* create 3 test data sets;
data one(where=(age=12))
two(where=(age=13))
three(where=(age=14));
set sashelp.class;
run;
*create workbook;
ods excel file = _webout;
ods excel style = Plateau;
ods excel options(sheet_name= "12 year olds");
proc print noobs data=one;
run;
ods excel options(sheet_name= "13 year olds");
proc print noobs data=two;
run;
ods excel options(sheet_name= "14 year olds");
proc print noobs data=three;
run;
ods excel close;
... View more