Desktop productivity for business analysts and programmers

EG 4.2 doesn't see my local user-created libraries when connecting to local

Reply
Contributor
Posts: 65

EG 4.2 doesn't see my local user-created libraries when connecting to local

Heya all,

Sorry for probably redundant question, but it's been driving me crazy ( along with other SAS things such as JRE and ODS), anyway, when i start EG 4.2 it only lists the 4 common libraries MAPS and etc. but it doesn't list my own libraries. I've been thinking because it runs its own SAS and needs to connect to SAS object spawner which I haven't gotten to work reliably either on win 7 64 bits machine.

So my question is: how to make EG 4.2 see my libraries and fully integrate SAS 9.2 into EG?

Thanks,

Arsenio

ps. again sorry if this is common knowledge but i have been browsing through ts and faqs and found nothing, and just now stumbled over this forum
Community Manager
Posts: 2,697

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Where are your libraries defined? In an autoexec? You need to make sure that the SAS command that is used to start your session includes this. This blog post contains a link to a tool that you can use to view/edit the SAS command:

http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Ente...

Or, define your libraries in another "autoexec-like" location:

http://blogs.sas.com/sasdummy/index.php?/archives/237-You-asked-for-it-the-Autoexec-process-flow.htm...

Chris
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Hi Chris,


Thanks for the answer! Tried the registry tweak (in the zip file)in http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Ente... . Removed the -noxcmd option for 32 bits, removing for 64 bits doesnt work, the program still shows it.

This didn't work. Got no idea how to do the autoexec in your second link or where the list of my libraries is located. The university IT dept is useless, I'm the first one who tried to use EG. Any tip/advice?

Thanks!

Arsenio
Community Manager
Posts: 2,697

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Arsenio,

Startup libraries can be defined in a few places with traditional SAS: in an autoexec file with LIBNAME statements, in a config (sasv9.cfg) file with -SET options. They could also be libraries that you defined in SAS Display Manager and then "saved" for startup in a user profile -- that isn't used for EG sessions.

If there is a metadata server, then that adds more places for potential libraries to be initialized.

If you know the libname definitions (libname statements) required for your libraries, you can add them to this option in EG: Tools->Options->SAS Programs: "Submit SAS code upon connection to server".

If you don't know your libname definitions...well, you'll have to consult with someone on your IT staff who does know them. You could also try SAS Technical Support to help.

Chris
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Hi Chris,

The only autoexec.sas file in C has these lines:
%let InputPath=C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)\sastest\ftt_20101229.000;
%let OutputPath=C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)\sastest\ftt_20101229.000;

no idea what to do with them

The sasv9.cfg has the following options which do not look logical at all:

/* set the default fileref for the PARMCARDS= option */
-SET FT15F001 'FT15F001.DAT'

-SET sasext0 "C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)"

-SET sasroot "C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)"

-SET sasext1 "C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)\nls"

/* Setup the MYSASFILES system variable */
-SET MYSASFILES "?CSIDL_PERSONAL\My SAS Files(32)\9.2"

/* Setup the SAS System configuration folder */
-SET SASCFG "C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)\nls\en"

/* environment variable required for Enterprise Miner to operate when it creates Java scoring code */
-SET DTJ_CLASSPATH "C:\Utils - Finance\SAS\SASFoundation\9.2(32-bit)\dmine\sasmisc\dtj.jar;C:\PROGRA~2\Java\JRE6\lib\rt.jar"

/* SAS/EIS Software image files */
-SET EISIMAGE !sasext0\eis\sample

/* SAS/SHARE APPLSYS macro library pathname */
-SET SASSAML !sasext0\share\sasmacro\

/* Setup the SAS System autocall library definition */
-SET SASAUTOS (
"!sasext0\core\sasmacro"
"!sasext0\accelmva\sasmacro"
"!sasext0\dmine\sasmacro"
"!sasext0\inttech\sasmacro"
"!sasext0\tmine\sasmacro"
"!sasext0\assist\sasmacro"
"!sasext0\eis\sasmacro"
"!sasext0\ets\sasmacro"
"!sasext0\genetics\sasmacro"
"!sasext0\gis\sasmacro"
"!sasext0\graph\sasmacro"
"!sasext0\iml\sasmacro"
"!sasext0\or\sasmacro"
"!sasext0\qc\sasmacro"
"!sasext0\share\sasmacro"
"!sasext0\stat\sasmacro"
)

/* Setup the SAS System help directory definition */
-SASHELP (
"!SASCFG\SASCFG"
"!sasext0\core\sashelp"
"!sasext0\dmine\sashelp"
"!sasext0\inttech\sashelp"
"!sasext0\mddbserv\sashelp"
"!sasext0\tmine\sashelp"
"!sasext0\af\sashelp"
"!sasext0\assist\sashelp"
"!sasext0\connect\sashelp"
"!sasext0\eis\sashelp"
"!sasext0\ets\sashelp"
"!sasext0\genetics\sashelp"
"!sasext0\gis\sashelp"
"!sasext0\graph\sashelp"
"!sasext0\iml\sashelp"
"!sasext0\insight\sashelp"
"!sasext0\intrnet\sashelp"
"!sasext0\lab\sashelp"
"!sasext0\or\sashelp"
"!sasext0\qc\sashelp"
"!sasext0\stat\sashelp"
"!sasext0\whouse\sashelp"
)

/* Setup the SAS System sample cat directory definition */
-SET SAMPSIO (
"!sasext0\core\sample"
"!sasext0\dmine\sample"
"!sasext0\inttech\sample"
"!sasext0\tmine\sample"
"!sasext0\access\sample"
"!sasext0\connect\sample"
"!sasext0\eis\sample"
"!sasext0\ets\sample"
"!sasext0\genetics\sample"
"!sasext0\gis\sample"
"!sasext0\graph\sample"
"!sasext0\iml\sample"
"!sasext0\insight\sample"
"!sasext0\intrnet\sample"
"!sasext0\or\sample"
"!sasext0\qc\sample"
"!sasext0\share\sample"
"!sasext0\stat\sample"
)

/* Setup the SAS System sample src directory definition */
-SET SAMPSRC (
"!sasext0\core\sample"
"!sasext0\dmine\sample"
"!sasext0\inttech\sample"
"!sasext0\tmine\sample"
"!sasext0\access\sample"
"!sasext0\connect\sample"
"!sasext0\eis\sample"
"!sasext0\ets\sample"
"!sasext0\genetics\sample"
"!sasext0\gis\sample"
"!sasext0\graph\sample"
"!sasext0\iml\sample"
"!sasext0\insight\sample"
"!sasext0\intrnet\sample"
"!sasext0\or\sample"
"!sasext0\qc\sample"
"!sasext0\share\sample"
"!sasext0\stat\sample"
)

/* Setup the SAS System teststream directory definition */
-SET INSTALL (
)

so which one of them points to my libraries? They have names like ETF, ETF1, ETF2, MF and etc...

No metadata server everything is local. It would be great just to have anything i change in base sas, because it's all everybody around here knows how to use, as clunky and unwieldy it may be, to be reflected in EG when i slowly start migrating my projects to EG process flow.

Any help would be greatly appreciated!

Thanks Arsenio
Community Manager
Posts: 2,697

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

If you start base SAS (Display Manager), you should see some information in the log window about any autoexec files that are processed. That might give you some hints about where the library definitions are coming from.

Also, you can find details of those library definitions by running this from base SAS:

libname _all_ list;

That will produce a bunch of output into the log with the libname details.

Chris
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Hi Chris,

When SAS is initialized this is all it says in the LOG window (thats the SAS Display Manager?)

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to**************************, Site *************
NOTE: This session is executing on the W32_VSPRO platform.



NOTE: SAS initialization used:
real time 2.17 seconds
cpu time 0.95 seconds

No mention of any autoexec or anything haven't seen it in a year i've been coding in sas.

libname _all_ list;
produced the list of all the libraries...now i just copy paste it somewhere?

I would expect this process to be much more transparent though. It's a local machine, I'm sure EG can give the options to access all of the libs or manage permissions if there are any. I just can't find those options in EG. Are you sure i'm not missing smth important here? i mean it shouldn't be that convoluted.

what about all the My Sas Files in the User folder hierarchy?


Thanks and sorry for all the trouble,

Arsenio
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Hi Chris,

If i open a 2nd copy of SAS it shows the following in the log window

NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.
WARNING: Unable to copy SASUSER registry to WORK registry. Because of this,
WARNING: you will not see registry customizations during this session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
NOTE: This SAS session is using a registry in WORK. All changes will be lost at the end of this
NOTE: session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.


with only 4 libs showing up, maybe thats what happens??

Arsenio
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

bumping the topic
Community Manager
Posts: 2,697

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Arsenio,

It looks like these libraries are stored in your SASUSER profile. To see the definitions:

1. Open SAS (display manager)
2. Click on Solutions -> Accessories -> Registry Editor.
3. Click on CORE, then OPTIONS, then LIBNAMES

I attached a picture (libs.png) of what that might look like.

Chris
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

Chris,

Found them actually last night! Thanks for the info, so now i export them into EG or into WORK.PROFILE or into some other kind of profile that EG uses? Been analyzing the options and changing settings like SAS command EG uses to invoke SAS. I managed to unlock profiles by using a -rsasuser option, so now i can at least run several SAS sessions accessing my libs. Still Stat Studio and EG don't see the my libnames.

I already spent 1 hr today on webex with sas tech support regarding other problem, still unsolved. This now is just killing me, i've never had problems that persistent related to software Smiley Happy

Thanks for your help! I feel the solution might be near

Arsenio
Contributor
Posts: 65

Re: EG 4.2 doesn't see my local user-created libraries when connecting to local

I solved this!!!

http://support.sas.com/kb/32/657.html

basically changing my sasv9.cfg did the trick!

Thanks everybody!
Ask a Question
Discussion stats
  • 11 replies
  • 353 views
  • 0 likes
  • 2 in conversation