Download SAS dataset from stored process

mrg1212005 — Wed, 19 Apr 2017 15:51:18 GMT

I am creating a stored process which uses the streaming output to generate a result in various format. One of the desired Output is to give business user ability to download result in form of SAS dataset so that they don't have to worry about importing the spreadsheet into sas everytime.

Please guide me with the best approach. Thanks

Re: Download SAS dataset from stored process

Vince_SAS — Fri, 21 Apr 2017 12:15:47 GMT

Try something like this:

*  Set up a test table in WORK, but could be a permanent library;

%let MYLIB=work;
data &MYLIB..class; set sashelp.class; run;

*  Write the data set to _WEBOUT;

%let RV=%sysfunc(appsrv_header(Content-type,application/x-sas-data)); 
%let RV=%sysfunc(appsrv_header(Content-disposition,%str(attachment; filename="Class.sas7bdat")));

filename temp "%sysfunc(pathname(&MYLIB))\class.sas7bdat";

data _null_;
infile temp   recfm=f lrecl=1;
file  _webout recfm=n;
input;
put _infile_;
run;

Vince DelGobbo

SAS R&D

topic Re: Download SAS dataset from stored process in Developers

Download SAS dataset from stored process

Re: Download SAS dataset from stored process