topic Re: Access data in SAS EG in SAS Enterprise Guide

Access data in SAS EG

dr2014 — Thu, 26 Apr 2018 17:37:51 GMT

Hi all,

I working with SAS EG which is new to me. Although I am connected to the server where we have our data I am unable to assign a library using the libname statement.

However, I see the dataset in one of the drives (e.g. G:\) within the 'Files' folder in the 'server window' of 'SAS EG'. How do I access it in SAS EG 'program' window? Please let me know as soon as possible.

Thanks!

Re: Access data in SAS EG

SuryaKiran — Thu, 26 Apr 2018 18:23:21 GMT

Is that a mapped drive? If your drive (e.g. G:\) is a mapped and your referencing G:\ in libname then it might not work. Try with the physical path that you used to map the drive.

Re: Access data in SAS EG

LinusH — Thu, 26 Apr 2018 19:10:02 GMT

Talk to your SAS server admin, whi should be able to guide you.
there could be several reason for this, even server side policy restrictions.

Re: Access data in SAS EG

dr2014 — Fri, 27 Apr 2018 11:06:33 GMT

Thanks for your reply. I tried using the physical path as well and it doesn't work.

Re: Access data in SAS EG

dr2014 — Fri, 27 Apr 2018 11:09:59 GMT

@LinushH I have reached out to them. It probably has to do with server policy restrictions itself. I was looking to see if I can access the dat from the Files folder as I see the data in the server window of SAS EG and can visualize the data but I guess there is no way to work with it in the local workspace other than using the 'libname'.

Re: Access data in SAS EG

SuryaKiran — Fri, 27 Apr 2018 20:11:32 GMT

You can maybe open data into your Project flow and then use Query Builder and copy it to other Library. This maybe a pain to open individual and copy them all into SAS.

Re: Access data in SAS EG

SASKiwi — Fri, 27 Apr 2018 23:06:14 GMT

What error do you get with the LIBNAME? Please post both the libname and the error message.

Re: Access data in SAS EG

dr2014 — Sun, 29 Apr 2018 11:18:45 GMT

H all,

Thanks for all your suggestions. I was able to resolve it with admin. The path where the data was mounted was different on the server from the one at the local workstation. So the libname had to include the 'g:' followed by the folder name on the server. That helped pull in the data into SAS EG.

Thanks!