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.

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 RELATIONSHIPleft-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.

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.