Information Map Engine and no datasets

[PhilipH]

Dear SAS Experts,

I got my Information Map up and running and want to use it in my SAS Base programs too but

somehow no datasets are retrieved when I try the following:

libname InfoMLi infomaps metauser=Malxxxx
metapass=xxxx
metaserver=sub029
metaport=8561
mappath="/Depart_1/Unit 122/Information Maps/source_result"
metarepository=Foundation;

The log output just shows that the libref as been assigned. I can see that. but

proc datasets lib=InfoMLi;
run;

throws the error: ERROR: Unable to initialize list of information maps.

Any idea what I do wrong?

I use EG 7.1 and no OLAP data, just sasbase data sets in my information map.

Thanks!

[ChrisHemedinger]

Some questions:

 - does the metauser account have read/readmetadata access to that information map?

 - Have you tried some of the SAS samples (perhaps you're already working with these) -- like this one for reporting, and this one with PROC INFOMAPS?

When using EG, can you use File->Open Information Map?  If so, that will generate the code that you can use for reporting in other environments.

[PhilipH]

Hi,

Thanks for you reply. The code generated in the log worked fine.

GOPTIONS ACCESSIBLE;
/* assign the library using the INFOMAPS library engine */
sysecho "Assigning library to access information map";
%macro SetDisplayOrder;
%if %sysevalf(&sysver>=9.4) %then displayorder=folder;
%mend SetDisplayOrder;
libname xxtest sasioime
mappath="/xxx/xx/xxx"
aggregate=yes
metacredentials=no
PRESERVE_MAP_NAMES=YES
%SetDisplayOrder;

I noticed that the library was created. I noticed that the library was gone after I restarted EG. does that mean it is a non-permanent library assignment?

[ChrisHemedinger · Accepted solution]

Correct, it is not a permanent library.  The Information Map "task" has one job: import the selected data from your map into a SAS data set, where you can report on it.  After the data is imported, the library is unassigned.  I recommend that approach because repeated calls back into the source information map can be inefficient.  If your map points to just Base SAS data sets, it might be okay.  But sometimes the data are located on remote systems so network latency is a consideration.

You can adapt the code that the task generates and use it in other programs.