Hi all,
I am very, very new to SAS and having some trouble using a library I create. For background on my particular situation, I'm using Enterprise Guide 7.15 HF3 on a Windows VM, and after I create a new library in Management Console, I can see it in Enterprise Guide but the icon is white and not yellow which I have read means it isn't active. After I double-click on the library, I get a message saying "An unexpected error has occurred: The library could not be assigned by the SAS Server" and I also read something about "User does not have appropriate authorization level for library TestLIB" in the error details.
I've discussed this with my SAS Admin at my workplace but he is just as new as I am and doesn't know what to do or what permission to enable and for obvious reasons, they don't want to enable all permissions for me.
Any suggestions would be greatly appreciated. Thanks in advance.
Can you open a program editor in Enterprise Guide (File - new - program) and manually submit a LIBNAME statement to the same location you created in SMC (instead of clicking on the library)?
After submitting the LIBNAME statement to the same location on the SAS server, are you able to expand the library and open tables? If you encounter the same authorization error, it indicates that the userid being used in Enterprise Guide doesn't have permission to access the underlying folder in referenced in the LIBNAME statement. Can you verify with the systems administrator that this userid has full read/write access to the folder on the operating system level?
If you use IWA (Integrated Windows Authorization) to log into Enterprise Guide, then this SAS note may help: http://support.sas.com/kb/41/477.html
Even though this document references SAS 9.2, this should still apply for a SAS 9.4 environment.
If you need more assistance, then please consider sending email stating the issue to support@sas.com, which will open a ticket with SAS Technical Support. A consultant will be glad to assist you.
Can you open a program editor in Enterprise Guide (File - new - program) and manually submit a LIBNAME statement to the same location you created in SMC (instead of clicking on the library)?
After submitting the LIBNAME statement to the same location on the SAS server, are you able to expand the library and open tables? If you encounter the same authorization error, it indicates that the userid being used in Enterprise Guide doesn't have permission to access the underlying folder in referenced in the LIBNAME statement. Can you verify with the systems administrator that this userid has full read/write access to the folder on the operating system level?
If you use IWA (Integrated Windows Authorization) to log into Enterprise Guide, then this SAS note may help: http://support.sas.com/kb/41/477.html
Even though this document references SAS 9.2, this should still apply for a SAS 9.4 environment.
If you need more assistance, then please consider sending email stating the issue to support@sas.com, which will open a ticket with SAS Technical Support. A consultant will be glad to assist you.
Thank you for the quick reply and your help. I think the issue was the user ID in EG. I found a video that helped me change the credentials I was using and I can now see the libraries in EG.
In case anyone needs it, the video I used is titled 'Work with a Connection Profile" and is linked here.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.