12-20-2017 11:00 AM
So my team has been using desktop/pc SAS for about 15 years now, we are being dragged into the Enterprise Guide platform kicking and screaming :-)
Our EG server is running Unix, our local machines are running Windows 7. Endpoint will be local machines with only SAS PC File Server, EG and the add-in for MS Office installed, in less than 60 days...
We need to be able to save SAS data sets to a folder on a local or network drive. I do have Proc Export working using PC File Server and I can get Excel output as we need but I cannot figure out how to set a SAS Libname to a local/network folder.
12-20-2017 12:19 PM
12-20-2017 11:10 AM
You can only define a libname for a directory that is visible on the SAS server, so you will need a common share on your environments.
12-20-2017 11:14 AM - edited 12-20-2017 11:14 AM
As you may know, the LIBNAME statement will be executed on the server where SAS Wirkspace server sessions are started.
So the path you use has to be relevant to that server.
For instance if you have a Windows server (I know yours is Unix but it is for the demonstration ) and you use 'libname test "c:\temp";', the path C:\temp will be the one on the server, not your local machine.
Samba drive or similar might be the way to go.
An alternative, native to SAS Enterprise Guide would be to use the Download Data Files to PC task, from Tasks => Data.
Hope that helps.
12-20-2017 11:32 AM
I'll look at that task - do you know if it can be set up to use macro variables for file and folder names? That might just do the trick.
12-20-2017 12:19 PM
12-20-2017 12:54 PM
That helps! Now I need to get our IT folks to upgrade us from 7.100.
Thanks, Chris, your SAS Dummy blog is helping a lot with this transition.
12-20-2017 01:11 PM
Glad to hear it!
You can use the Copy Files task in earlier versions as a custom task (links all in the blog) -- but upgrade is better
Need further help from the community? Please ask a new question.