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
I'd try to change the second function call to this:
rc = stpsrv_header('Content-disposition','attachment; filename="test.xls"');
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.