topic Re: PROC INFOMAPS not working in SAS Enterprise Guide

PROC INFOMAPS not working

Ramjir — Mon, 30 Oct 2006 06:43:49 GMT

We ran the PROC infomap to add tables to a infomap. While doing so, we got the following error.

481 proc infomaps metauser="sasdemo"
482 metapass=XXXXXXXXXXXX
483 metaserver="TPCIDL06048"
484 metaport=8561
485 metarepository="Foundation";
486 delete infomap "testmap" mappath="/BIP Tree/ReportStudio/Maps";
NOTE: Information map "testmap" was successfully deleted from "/BIP Tree/ReportStudio/Maps".
487 open infomap "testmap"
488 mappath="/BIP Tree/ReportStudio/Maps";
489 insert datasource server="SASMain"
490 table=ProcLib.City _ALL_ ;
com.sas.iquery.metadata.MetadataException: The schema named PROCLIB was not found on server SASMain.
at com.sas.iquery.metadata.business.impl.InformationMapImpl.newDataSourceTable(Unknown Source)
at com.sas.iquery.baseinteg.ProcInfoMaps.addDataSourceTable(Unknown Source)
ERROR: Failed to insert data source "PROCLIB"."CITY".
491 save;
NOTE: Information map "testmap" has been saved in folder "/BIP Tree/ReportStudio/Maps".
WARNING: Information map "testmap" contains no business items.
492 run;

NOTE: PROCEDURE INFOMAPS used (Total process time):
real time 0.79 seconds
cpu time 0.03 seconds

Please let us know if the above syntax is right. If so, let us know how to rectify this error.

Re: PROC INFOMAPS not working

RW — Tue, 27 Nov 2007 19:02:18 GMT

did you ever get a response for this? I am getting the same error

Re: PROC INFOMAPS not working

Cynthia_sas — Tue, 27 Nov 2007 19:51:55 GMT

Hi:
In the documentation
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/base_infomap_9951.pdf
on page 26/27, they show this example:

[pre]
proc infomaps metauser="myUserID"
metapass="myPassword"
metaserver="myip.us.mycompany.com"
metaport=8561
metarepository="Foundation";
/* Delete the information map to avoid duplicate data items. */
delete infomap "xmp_simple" mappath="/BIP Tree/ReportStudio/Maps";

/* Open a new information map. The path specified is where, by */
/* default, it will be saved when a SAVE statement is issued. */
/* The information map exists only in memory and not in the */
/* metadata repository until the SAVE statement is issued. */
open infomap "xmp_simple"
mappath="/BIP Tree/ReportStudio/Maps";

/* Note that an OPEN INFOMAP statement must precede the */
/* INSERT DATASOURCE statement. */
/* Make the specified table on the specified server accessible. */
insert datasource sasserver="SASMain"
table="Sample Data".CLASS _all_ ;

/* If no name is specified on the SAVE statement, then the information */
/* map that is currently open is saved with the name with which it was */
/* opened. If no path is specified, then it is saved in the path */
/* specified in the OPEN statement or, secondarily, it is saved in */
/* the path that is specified in the PROC INFOMAPS statement. */
save;
run;
[/pre]

The reference they use on their TABLE= option is the Descriptive name of the LIBRARY..so for example, I might have a
LIBRARY named "Orion Star" in the Metadata
whose
LIBREF was "orstar" in my SAS program.

But the usage in the example, implies to me that the correct coding would be:
TABLE="Orion Star".customer (the descriptive LIBRARY name)
NOT
TABLE=orstar.customer (the LIBREF used in the SAS program)

You might also consider contacting Tech Support for help using PROC INFOMAP. To contact Tech Support, go to http://support.sas.com and on the left hand navigation pane, look for the link entitled "Submit a Problem".

cynthia