topic SAS Studio - Couple questions in SAS Studio

SAS Studio - Couple questions

RupaJ — Mon, 13 Jan 2020 21:30:44 GMT

Hello,

1) How do you map network drives on SAS Studio? I am unable to access any n/w drives to load a SAS code/data sets. Our SAS is on Linux servers and the drives are mounted on compute server which are also accessible from windows server.

2) Also how do I export results from SAS studio to a file?

Re: SAS Studio - Couple questions

Pmyosh — Tue, 14 Jan 2020 03:00:20 GMT

Hi,

Datasets should can loaded by using Data Prepare module and can be exported by selecting export in the OUTPUT tab> select the SAS VIYA folder> find the file in the selected folder >right click, choose DOWNLOAD, then you can download to a network drive.

As for importing/exporting external files via PROC IMPORT/EXPORT one solution is to use SFTP.

Hope this helps

Re: SAS Studio - Couple questions

Kurt_Bremser — Tue, 14 Jan 2020 06:40:09 GMT

Ask your server admin(s) for the names of the mount points of the network shares, and use those in your code.

Use proc export to export data to an external file.

Re: SAS Studio - Couple questions

RupaJ — Thu, 23 Jan 2020 15:29:40 GMT

Here is how you can make the folders visible on SAS studio. Providing the steps so it's useful for others.

A shotcuts.xml file should be created in the folder "GlobalStudioSettings" in the path /<SASHome>/SASFoundation/9.4 where your network folders are mounted. You will have to create the "GlobalStudioSettings" folder. It's not there by default.

the contents of the shorcuts.xml should be below.

<?xml version="1.0" encoding="UTF-8"?>

</Shortcuts>

Opening a new SAS studio session will then reflect the folders on the left hand side .

Thanks