DATA Step, Macro, Functions and more

SAS Stored Process

Reply
Contributor
Posts: 36

SAS Stored Process

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,

MS

Super User
Posts: 7,868

Re: SAS Stored Process

Posted in reply to Micheal_S

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

rc = stpsrv_header('Content-disposition','attachment; filename="test.xls"');
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,441

Re: SAS Stored Process

Posted in reply to Micheal_S
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"?
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 262 views
  • 0 likes
  • 3 in conversation