What's New

What's New in the INFOMAPS Procedure and SAS 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 SAS 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 as follows:
- The new DOMAIN= option specifies an authentication domain on the current server for user logons.
- The METAPASS= and METAUSER= arguments are optional if the metadata server supports single sign-on.
- The METAREPOSITORY= argument is now required only in the case where the information maps you want to use reside in a SAS 9.2 metadata repository that was converted from a custom repository in SAS 9.1.3.
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 CREATE option to create the location for the data item if the location specified in the FOLDER= option 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.

You can use the new CREATE option to create the location for the filter if the location specified in the FOLDER= option does not already exist.
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 specifies 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 moves data items to a new location.
The MOVE FILTER statement is new for this release. This statement moves filters to a new location.
The MOVE FOLDER statement is new for this release. This statement moves 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 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 the current 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.

SAS Information Maps LIBNAME Engine

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

The Information Maps 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 METAPASS= and METAUSER= arguments are optional if the metadata server supports single sign-on.
The METAREPOSITORY= argument is now required only in the case where the information maps you want to use reside in a SAS 9.2 metadata repository that was converted from a custom repository in SAS 9.1.3.
The SSPI= option can be used to specify Integrated Windows Authentication.
The AGGREGATE= option for the LIBNAME statement and the AGGREGATE= data set option are new for this release. These options specify whether the engine uses detailed data or aggregated data.
The DOMAIN= option for the LIBNAME statement is new for this release. This option specifies an authentication domain on the current server for user logons.
The PRESERVE_MAP_NAMES= option for the LIBNAME statement has replaced the PRESERVE_TAB_NAMES 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 engine, the Label column in the procedure output now shows only the data item description.
SQL DICTIONARY tables are now available that contain information about the information maps, data items, and filters that can be accessed using the Information Maps engine.

Top of Page

Previous Page
|
Next Page
|
Top of Page