If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide.
I have not set the AssignMode property in the "Extended Attributes" in the Library property.
I have a similar Oracle Library for a different Oracle Schema in the same path, and with that library I have no problem at all.
Can you help me?
Thanks!
Hi Fabio, couple of things to make sure:
- delete it and create again
- make sure you assign library as pre-assigned "bynative library engine"
- make sure when you provide information for
- on "assign" tab
selected server would be "sasapp"
- on data server tab
data server
database schema name
connection
-also keep liname and liref name same
Hi,
try :
click tools ---> options ---> SAS Program ---> Submit code when server is connected ---> edit
then copy you libname code there
Hi Linlin,
thank you!
It's a good workaround, but I can't understand why I can't see the library in EG that is preassigned in the Management Console.
If in MC I clear the preassign option, the library return visible in EG, but then I have to manually assign it in EG (unless I use your workaround)
Hi Fabio, couple of things to make sure:
- delete it and create again
- make sure you assign library as pre-assigned "bynative library engine"
- make sure when you provide information for
- on "assign" tab
selected server would be "sasapp"
- on data server tab
data server
database schema name
connection
-also keep liname and liref name same
Hi Sandy,
thank you very much!
I set the name of the library in the metadata same as the libref and now is working.
Only a clarification, where is it possible to assign library as pre-assigned "bynative library engine"?
Thanks!
when you open SAS MC, Plug-Ins>Data Library Manager> then click on "library"> then double click on library which you wants to assign as pre-assigned to view property of library> go to options>click on advance options
.
Hi Sandy, thanks for your great help!
Hi, Just in case does anyone know how to pre-assign a SAP R3 library in SMC. After following the above steps, SAP R3 library does not have "Advance Options" where we usually pre-assign. Please advise.
what version of EG and SAS etc are you using?
sas 9.2 with guide 4.3
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.