topic Re: Add a download link in Developers

Add a download link

MarcTC — Wed, 05 Jan 2011 04:15:36 GMT

I am building a SPWA based web application. I want to add a download link to the web page for users to download the data to an Excel spreadsheet like "Donwload to Spreadsheet" link shown in the following Yahoo Historical Stock Price page:
http://finance.yahoo.com/q/hp?s=^GSPC

Any hints are appreciated!

Re: Add a download link

Vince_SAS — Wed, 05 Jan 2011 13:43:23 GMT

You will find many good references if you go to http://support.sas.com and then search for:

download csv

The key is to create to a streaming stored process that sets the appropriate MIME headers. Give this (untested) code a try:

[pre]
%let RV=%sysfunc(appsrv_header(Content-type, application/vnd.ms-excel));
%let RV=%sysfunc(appsrv_header(Content-disposition, %str(attachment; filename=temp.csv)));

ods listing close;
ods csv file=_webout;
proc print data=sashelp.class; run; quit;
ods csv close;
[/pre]

Vince DelGobbo
SAS R&D

Re: Add a download link

Attyslogin — Fri, 09 Feb 2018 12:33:27 GMT

what if that file is an image ?

how to download ?

Re: Add a download link

Vince_SAS — Mon, 12 Feb 2018 21:07:02 GMT

@Attyslogin - can you provide more details on what you want to do?

Vince DelGobbo

SAS R&D