I think this can be done. It is easiest to create 3 stored processes. One to generate the form that is initially displayed. Another to run the report to send results back to the viewer. Another to run a stp that exports it to ODS.
STP 1 would look similar to the following:
/**************************************************************
DATA _NULL_;
file _webout;
put "<html>";
put "<style>";
put "body {font-family: 'Calibri';}";
put "h3 {text-align: center;}";
put "div {font-size: small; font-weight: bold;}";
put "</style>";
put "<body>";
/* first form to run stored process to "return to start" */
put "<FORM ACTION='&_URL'>";
put '<input type="hidden" name="_program" value="/Projects/TLM/StoredProcess/TLM_DnM_FC_get_input">';
put '<div><input type="submit" value="RETURN TO START"></div></form>';
/* end of first form definition */
put '<br> </br>';
/* second form to run stored process that will export to excel */
put "<FORM ACTION='&_URL'>";
put '<input type="hidden" name="_program" value="/Projects/TLM/StoredProcess/TLM_DnM_export2Excel">';
put '<div><input type="submit" value="EXPORT TO EXCEL"></div></form>';
/* end of second form definition */
put "</body>";
put "</html>";
RUN;
/* ********************************************************************************************************** */
STP 2 would be the stp that you have already created making sure that it is wrapped with %stpbeing and %stpend
STP 3 would be your same code in STP 2, but you would use tags to Export to Excel like the following example:
The next step that you must have in place is to define the stored process TLM_DnM_export2Excel, and here is a short example of code that exports a PROC PRINT output to Excel. This stored process must be registered to execute on the "Stored Process Server only" and should produce Stream results.
/* Example: Create a HTML file for downloading to Excel. */
/* Using %STPBEGIN and %STPEND */
*ProcessBody;
data _null_;
rc = stpsrv_header('Content-type','application/vnd.ms-excel');
rc = stpsrv_header('Content-disposition','attachment; filename=report.xls');
run;
%stpbegin;
proc print data=sashelp.class;
run;
%stpend;
