topic SAS Stored Process in SAS Programming

SAS Stored Process

Micheal_S — Wed, 03 Aug 2016 12:17:43 GMT

Hello,

I am trying to create a stored process, which will pull out one .xls file from server(pre created) and show a pop up to save when execute. i am using below code but its not working, please help

filename in "path/test.xls";

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

run;

Thanks,

Re: SAS Stored Process

Kurt_Bremser — Wed, 03 Aug 2016 12:57:30 GMT

I'd try to change the second function call to this:

rc = stpsrv_header('Content-disposition','attachment; filename="test.xls"');

Re: SAS Stored Process

LinusH — Wed, 03 Aug 2016 12:58:03 GMT

Thus should be better posted in the Stored Process forum (under BI).
What is not working?
Do you get any error/warning?

And what do you mean by "save when execute"?