SAS Studio - Couple questions

[RupaJ]

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?

[Pmyosh]

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

[Kurt_Bremser]

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.

[RupaJ · Accepted solution]

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>

<Shortcut type="disk" name="<Name>" dir="/<Dir path>"/>

</Shortcuts>

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

Thanks