topic Re: Code to Download a File from SAS Studio (Viya) in SAS Programming

Code to Download a File from SAS Studio (Viya)

Balli — Tue, 05 Sep 2023 03:49:39 GMT

Hi All,

We are running SAS Viya on Unix and every time I create a file on SAS Studio, I need to manually download the file into windows. I am somehow trying to automate this.

Any idea what code runs in the background when you right click on a folder in SAS Viya and chose Download File ?

Or if anyone knows an alternate solution to automate the download of files from SAS Studio to Windows directory ?

Kind Regards and Thanks in Advance 🙂

Re: Code to Download a File from SAS Studio (Viya)

Kurt_Bremser — Tue, 05 Sep 2023 06:00:17 GMT

Have your admins set up a shared network resource which is mounted on the SAS server and accessible by the Windows clients. Once you know the UNIX path to the mountpoint, you use it in your SAS code.

Re: Code to Download a File from SAS Studio (Viya)

Ezhil_Michael — Tue, 24 Mar 2026 13:13:11 GMT

Is there a way to download the file from SAS Viya 4 using some simple scripts like path and file name as input parameters.

Re: Code to Download a File from SAS Studio (Viya)

SASKiwi — Tue, 24 Mar 2026 19:10:43 GMT

As @Kurt_Bremser has already stated, just a script wont work unless your administrators set up a network folder share that is accessible from your SAS server. Once that is done SAS code can be run on Viya 4 that will write to the share. PROC EXPORT would be one option to write SAS data to an Excel spreadsheet or a CSV file.

Re: Code to Download a File from SAS Studio (Viya)

Tom — Tue, 24 Mar 2026 20:25:32 GMT

You should be able to do this with a Viya JOB.

There should be examples you could module your JOB after that provide a download option for the user.

Re: Code to Download a File from SAS Studio (Viya)

Tom — Tue, 24 Mar 2026 20:38:31 GMT

This works in SAS/Studio used by SAS On Demand for Academics.

Not sure if it works in SAS/Studio for VIYA.

%let fname=example.xlsx;
filename _dataout "~/&fname";
%let _dataout_name=&fname;
%let _dataout_mime_type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet ;

Re: Code to Download a File from SAS Studio (Viya)

Kurt_Bremser — Tue, 24 Mar 2026 22:24:17 GMT

Please define "simple script". Shell script, SAS program, something else? Which client and server platform?

Re: Code to Download a File from SAS Studio (Viya)

Ezhil_Michael — Fri, 27 Mar 2026 08:02:05 GMT

Requesting for a SAS program. To be more precise on my requirement. We are in the phase of migration from SAS AML 7.1 on-prem solution to SAS AML on Viya 4 hosted as managed service on cloud. Our business need to move the old attachments (older than 5 years) and comments to be migrated in an archive folder in cloud and needed a facility to download it on demand based on CB or Internal auditors. So my request is to in request i will give the file name and path in content server so that sas program is required to download the file as per need.

Re: Code to Download a File from SAS Studio (Viya)

Kurt_Bremser — Fri, 27 Mar 2026 12:36:16 GMT

You need to set up storage that is accessible from your SAS server (e.g. through SSH or WEBDAV). Then a SAS program can write there.