Excel multiple sheet output using Stored Process

[dipanarya1]

Hi Team, We are trying to provide an options to generate the RTF, PDF and Excel file using STP. We are able to generate an output in RTF and in PDF format, but while trying to generate the Excel file the STP is giving the _webout related error, attached log file and below is the code snippet.

[dipanarya1]

Attached log file.

[dipanarya1]

Please note the macro attached in first post is being called up in SAS STP.

[AllanBowe · Accepted solution]

How are you calling the STP?  From EG, a web browser, Excel?

If you are calling it from a web browser I'd suggest setting to `stream` output and removing the automatic `%STPBEGIN;` / `%STPEND;` macros.  This will ensure that any output sent to the `_webout` fileref will be received 'cleanly' by the client.  If downloading files then you will also have to set the http headers, eg:

data _null_;
  rc = stpsrv_header('Content-type','application/excel');
  rc = stpsrv_header('Content-disposition',"attachment; filename=myfile.xls");
run;