topic Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide in SAS Enterprise Guide

If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

FabioP — Fri, 14 Dec 2012 08:50:42 GMT

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!

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

Linlin — Fri, 14 Dec 2012 11:39:56 GMT

Hi,

try :

click tools ---> options ---> SAS Program ---> Submit code when server is connected ---> edit

then copy you libname code there

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

FabioP — Fri, 14 Dec 2012 13:12:22 GMT

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)

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

sas_9 — Fri, 14 Dec 2012 17:13:17 GMT

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

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

twocanbazza — Sun, 16 Dec 2012 19:09:45 GMT

what version of EG and SAS etc are you using?

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

FabioP — Tue, 18 Dec 2012 08:26:37 GMT

sas 9.2 with guide 4.3

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

FabioP — Tue, 18 Dec 2012 08:42:57 GMT

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!

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

sas_9 — Tue, 18 Dec 2012 22:08:31 GMT

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

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

FabioP — Wed, 19 Dec 2012 08:23:40 GMT

Hi Sandy, thanks for your great help!

Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

seven_snow — Fri, 01 Mar 2013 16:59:07 GMT

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.