What's New

What's New in the INFOMAPS Procedure and Information Maps LIBNAME Engine

The INFOMAPS procedure in Base SAS software has been enhanced for this release. You can change the definitions of any existing data item, filter, data source, folder, or relationship within an information map. You can move items between folders and associate stored processes with information maps.

The Information Maps LIBNAME engine has also been enhanced for this release. The engine supports complex filter clauses and can read aggregated data as well as detailed data. You can specify an authentication domain for user logons.

INFOMAPS Procedure

The INFOMAPS procedure is now available on all operating systems for the SAS 9.2 release except OpenVMS on HP Integrity. Previously, the procedure was available only on Windows (32-bit), Solaris (64-bit), HP-UX, HP-UX on Itanium, AIX (64-bit), and z/OS.

The following statements in the INFOMAPS procedure have changes and enhancements:

The PROC INFOMAPS statement has changed. The METAPASS and METAUSER= arguments are optional if the current metadata server supports single sign-on. The new DOMAIN= option enables you to specify an authentication domain on the current server for user logons.
The EXPORT statement has changed. The FILE= argument is now required rather than optional.
The INSERT DATAITEM statement has been enhanced. The new HIERARCHY= and MEASURE= options provide simpler alternatives to the EXPRESSION= option for creating data items for OLAP data sources. You can use the HIERARCHY= option to specify a physical hierarchy in an OLAP data source. You can use the MEASURE= option to specify a physical measure in an OLAP data source

You can use the new LOCATION= option to specify a folder within an information map where a data item should be inserted. You can use the new CREATE option to create the location for the data item if it does not already exist.
The INSERT FILTER statement has changed. You now specify the filter name using the NAME= argument rather than as an explicit argument in the INSERT FILTER statement.
The INSERT RELATIONSHIP statement has been enhanced. The following syntax is now obsolete:

INSERT RELATIONSHIP left-table INNER | LEFT | RIGHT | FULL
JOIN right-table ON "conditional-expression";
You now use the LEFT_TABLE=, RIGHT_TABLE=, JOIN=, and CONDITION= arguments to specify the relationship.
The new DESCRIPTION= option enables you to specify a description for a relationship.
The LIST statement has been enhanced. The new RELATIONSHIPS option lists the identifier, left and right tables, cardinality, type of join, and join expression for each relationship defined in an information map.

The output for the LIST statement now indicates when the information map does not contain the type of business data that has been requested.
The MOVE DATAITEM statement is new for this release. This statement enables you to move data items to a new location.
The MOVE FILTER statement is new for this release. This statement enables you to move filters to a new location.
The MOVE FOLDER statement is new for this release. This statement enables you to move folders to a new location.
The OPEN INFOMAP statement has been replaced with the NEW INFOMAP statement to create a new information map and the UPDATE INFOMAP statement to update an existing information map.
The SAVE statement has been updated. You can use the new LOCATION= option to specify where an information map should be stored. You can use he new CREATE option to create the location for the information map if it does not already exist.
The SET STORED_PROCESS statement is new for this release. This statement associates a stored process with an information map.
The UPDATE DATAITEM statement is new for this release. This statement updates the properties of a specified data item in an information map.
The UPDATE DATASOURCE statement is new for this release. This statement updates the properties of a data source in an information map.
The UPDATE FILTER statement is new for this release. This statement updates the properties of a specified filter in an information map.
The UPDATE FOLDER statement is new for this release. This statement updates the properties of a specified folder in an information map.
The UPDATE RELATIONSHIP statement is new for this release. This statement updates the properties of a join relationship in an information map.

Information Maps LIBNAME Engine

The Information Maps LIBNAME engine in Base SAS software has the following changes and enhancements:

The Information Maps LIBNAME engine is now available on all operating systems for the SAS 9.2 release except OpenVMS on HP Integrity. Previously, the engine was available only on Windows (32-bit), Solaris (64-bit), HP-UX, HP-UX on Itanium, AIX (64-bit), and z/OS.
The AGGREGATE= LIBNAME statement option and AGGREGATE= data set option are new for this release. These options specify whether the engine uses detailed data or aggregated data.
The DOMAIN= LIBNAME statement option is new for this release. This option specifies an authentication domain on the current server for user logons.
The PRESERVE_MAP_NAMES= LIBNAME statement option has replaced the PRESERVE_TAB_NAMES LIBNAME= statement option. (PRESERVE_TAB_NAMES is still supported as an alias for PRESERVE_MAP_NAMES.)
The FILTER= data set option has been enhanced for this release. The OR and NOT Boolean operators are now supported. You can also use parentheses to signify precedence or any needed grouping within the clause.

When you use the CONTENTS procedure in Base SAS software to show the contents of an information map referenced by the Information Maps LIBNAME engine, the Label column in the procedure output now shows only the data item description.