Hi,
I played with this a bit, but wasn't successful. : )
I was thinking to just write the PDF and Excel file to work directory, then stream them back to the user. I was playing with something like:
ods tagsets.excelxp file="%sysfunc(pathname(work))/myExcel.xls";
proc print data=sashelp.class;
run;
ods tagsets.excelxp close;
ods pdf file="%sysfunc(pathname(work))/MyPDF.pdf";
proc print data=sashelp.shoes;
run;
ods pdf close;
data _null_;
file _webout (no_bottom_matter);
infile "%sysfunc(pathname(work))/myExcel.xls";
if _n_ = 1 then do;
rc = stpsrv_header('Content-type','application/vnd.ms-excel');
rc = stpsrv_header('Content-disposition',"attachment; filename=MyExcel.xls");
end;
input ;
put _infile_;
run;
data _null_;
file _webout (no_top_matter) recfm=s;
infile "%sysfunc(pathname(work))/MyPDF.pdf" recfm=n;
if _n_ = 1 then do;
rc = stpsrv_header('Content-type','application/pdf');
rc = stpsrv_header('Content-disposition',"attachment; filename=MyPDF.pdf");
end;
input c $char1.;
put c $char1. @@;
run;
But that doesn't work, I suspect for a number of reasons. Basically trying to send two posts (?) back to the browser. And not allowed 2 different headers. Even when I tried just 2 pdf files, couldn't get it working. Looks like no_bottom_matter can't be used with file _webout ???
Anyway, despite my lack of success, I think if you are willing to keep the approach of having 2 different stored processes, something like above might work, if you use sessions. So the first stored process writes the 2 reports to work dir, and streams back the Excel file. The second stored proecss connects to the same session as the first stored process (so can see the 2 reports in the work dir), and streams the pdf file back to the user. It's just a thought, I haven't played with sessions yet.
Hopefully something in this will help, or perhaps encourage someone else to jump in.
--Q.
.
The Boston Area SAS Users Group is hosting
free webinars!
Next webinar will be in January 2025. Until then, check out our archives:
https://www.basug.org/videos. And be sure to subscribe to our our email list.
