Your SAS programs, embedded in web apps and elsewhere

Download SAS dataset from stored process

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Download SAS dataset from stored process

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


Accepted Solutions
Solution
‎04-25-2017 11:51 AM
SAS Super FREQ
Posts: 304

Re: Download SAS dataset from stored process

Posted in reply to mrg1212005

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

View solution in original post


All Replies
Solution
‎04-25-2017 11:51 AM
SAS Super FREQ
Posts: 304

Re: Download SAS dataset from stored process

Posted in reply to mrg1212005

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 163 views
  • 2 likes
  • 2 in conversation