how to download an xlsx with &_WEBIN_FILEURI/content

luca87 — Tue, 20 Sep 2022 07:10:52 GMT

Hi,

in sas studio V I create a Job Definiton in HTML.

At the end of the code I create a tables and then an xlsx with proc export.

How can I create a button to allow you to download this file?

if I use this procedure it doesn't work because the file doesn't exist

proc export 
  data=tmp 
  dbms=xlsx 
  outfile="&path./Test.xlsx" 
 replace;
run;

data vuoto;
SUCCESFUL="please download the file by right-clicking and save as";
run;
			
footnote link="&path.\Test.xlsx"  'Click here to download file';
			
proc print data=vuoto noobs;run;

From the available job definitions I see that sas uses

& _WEBIN_FILEURI/content.

How should I go about loading xlsx into this path?

Thanks

[SOLVED] Re: how to download an xlsx with &_WEBIN_FILEURI/content

luca87 — Wed, 21 Sep 2022 07:08:07 GMT

I found a solution adapting the code of Report with Download Links in SAS Help Center: Samples

topic how to download an xlsx with &_WEBIN_FILEURI/content in SAS Studio

how to download an xlsx with &_WEBIN_FILEURI/content

[SOLVED] Re: how to download an xlsx with &_WEBIN_FILEURI/content