topic Re: Downloading a pdf report via SAS VIYA jobs in SAS Programming

Downloading a pdf report via SAS VIYA jobs

jins — Fri, 27 May 2022 15:31:24 GMT

How do we make the file downloadable once the submit button is pressed at the client side?. I'm creating a job definition in SAS Viya 3.5 and want the client to download a pdf or any other file format. Kind of new of new to stored process as well as its equivalent Jobs in SAS VIYA. Not sure if I am reading the job execution web application doc correctly.

filename f_pdf filesrvc parenturi="&SYS_JES_JOB_URI" 
  name='Class.pdf' 
  contenttype='application/pdf';
ods pdf file=f_pdf style=&_ODSSTYLE;
proc print data=xxxxx;
run;
ods pdf close;

The above code saves it but does not download into the downloads folder at the client site. How can we achieve that?

Thanks in advance!

Re: Downloading a pdf report via SAS VIYA jobs

AllanBowe — Mon, 30 May 2022 00:18:51 GMT

Hi @jins - you were close! Here are the things I changed to make your code work:

Changed the name to _webout.pdf - this is necessary for the result to stream
Added the contentdisp attribute - this is necessary for the file to auto-download
Removed the _odsstyle variable (not available in my 3.5 environment)

And here is a functional program you can run in SAS Studio to reproduce (just open the link in the log at the end):

/* compile sasjs core macros */
filename mc url "https://raw.githubusercontent.com/sasjs/core/main/all.sas";
%inc mc;

/* set up the sas program */
filename ft15f001 temp lrecl=1000;
parmcards4;
	filename f_pdf filesrvc parenturi="&SYS_JES_JOB_URI" 
	  name='_webout.pdf' 
	  contenttype='application/pdf'
      contentdisp="attachment; filename=my.pdf";
	ods pdf file=f_pdf /*style=&_ODSSTYLE */;
	proc print data=sashelp.class;
	run;
	ods pdf close;
;;;;

/* create the job in SAS Drive */
%mx_createwebservice(path=/Public/app/demo,name=sendpdf)

For reference there are a bunch of examples for streaming files from Viya (or SAS 9, or SASjs server) in this macro: https://core.sasjs.io/mp__streamfile_8sas_source.html

There's no PDF option yet, but feel free to raise an issue or PR!

Re: Downloading a pdf report via SAS VIYA jobs

jins — Mon, 30 May 2022 23:43:06 GMT

thanks for this.

Re: Downloading a pdf report via SAS VIYA jobs

jins — Tue, 31 May 2022 13:42:35 GMT

I had one more question - if the report link has to be shared, where should one store the job definition and the associated data sets. Currently it is under Users/Username... and this gives unable to read the Job definition error, if someone else tries to open it. This might be permission issue on my folder but where can this be moved to?

Thanks in advance.

Re: Downloading a pdf report via SAS VIYA jobs

AllanBowe — Tue, 31 May 2022 14:26:52 GMT

That's really up to you and your site policies. You can put it anywhere in SAS Drive you like, just set any relevant permissions.

Re: Downloading a pdf report via SAS VIYA jobs

jimbobob — Fri, 30 Sep 2022 21:00:39 GMT

Hi @AllanBowe ,

Trying to use this code as sample, what does this part of the code do:

filename ft15f001 temp lrecl=1000;
parmcards4;

Re: Downloading a pdf report via SAS VIYA jobs

AllanBowe — Fri, 30 Sep 2022 21:14:35 GMT

Hi @jimbobob - great question!

The strange looking filename is a special destination that - when used in combination with the parmcards statement - allows you to write arbitrary content to a fileref (in a very similar way to cards / datalines to a data set)

We use it in SASjs as a convenient way to deploy multiple stored processes in a single SAS program.

Re: Downloading a pdf report via SAS VIYA jobs

jimbobob — Fri, 30 Sep 2022 21:20:59 GMT

Ok very interesting, thanks for update

Re: Downloading a pdf report via SAS VIYA jobs

jimbobob — Fri, 30 Sep 2022 21:31:39 GMT

@AllanBowe ,

This is fascinating, so you code creates a job, so now all i need to do is associate the created job to a form right?

Re: Downloading a pdf report via SAS VIYA jobs

AllanBowe — Fri, 30 Sep 2022 21:38:39 GMT

Yes, that's one way of doing it!

We have a bunch of demo SAS web apps you can check out here: https://github.com/search?q=topic%3Asasjs-app+org%3Asasjs+fork%3Atrue&type=repositories

There is also a support group: https://matrix.to/#/#sasjs:4gl.io