Download SAS dataset from stored process

[mrg1212005]

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

[Vince_SAS · Accepted solution]

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