INFOMAPS Procedure

UPDATE INFOMAP Statement

Updates an existing information map.

Syntax

UPDATE INFOMAP "information-map-name" <options>;

Summary of Optional Arguments

CREATE_TARGET_FOLDER=YES | NO

specifies whether to automatically create a folder when inserting all items from a data source.

CUSTOM_PROPERTIES=NONE | ADD (custom-properties-list) | REMOVE (property-names-list) | <REPLACE> (custom-properties-list)

specifies how custom properties for an information map are updated.

DESCRIPTION="descriptive-text"

specifies the description of an information map.

INIT_CAP=YES | NO

specifies whether to capitalize the first letter of each word in the data item name.

JOIN_MODEL=BASIC | ADVANCED

specifies the join strategy that is used during query generation.

MAPPATH="location"

specifies the location within the SAS folders tree for the information map to open or update.

REPLACE_UNDERSCORES=YES | NO

specifies whether to replace each underscore (_) character in the data item name with a blank space.

REQUIRED_DATASOURCES=_ALL_ | NONE | ADD (data-source-list) | <REPLACE> (data-source-list) | REMOVE (data-source-list)

specifies how the list of required data sources for the information map is updated.

USE_LABELS=YES | NO

specifies whether to create the data item name using the column label (if available) instead of the column name.

VERIFY=YES | NO

specifies whether the INFOMAPS procedure verifies the validity of data items, filters, and relationships during the Update operation.

Required Argument

"information-map-name": specifies the name of the information map to update.

Restriction:If the specified information map does not exist, an error will occur.

Optional Arguments

CREATE_TARGET_FOLDER=YES | NO: specifies whether to automatically create a folder when inserting all items from a data source. Specifying YES automatically creates a folder when you subsequently insert all data items using an INSERT DATASOURCE statement that specifies the _ALL_ option. The name of the folder is the name of the table specified in the INSERT DATASOURCE statement. The data items that are inserted as a result of the INSERT DATASOURCE statement are inserted into the folder that is created automatically.

Default:YES

CUSTOM_PROPERTIES=NONE | ADD (custom-properties-list) | REMOVE (property-names-list) | <REPLACE> (custom-properties-list)

specifies how custom properties for an information map are updated. Custom properties are supported by specific SAS applications such as SAS Marketing Automation. Valid operations are the following:

NONE: removes all custom properties from an information map, if there are any.

ADD (custom-properties-list)

adds the specified custom properties to an information map.

The form of the custom-properties-list value is

("property-name-1" "property-value-1" <"description-1">)

...

("property-name-n" "property-value-n" <"description-n">)

where

property-name: specifies the name of the property.

Restriction:Property names cannot begin with an underscore (_) character.

Requirement:Property names must be unique. If a specified property name already exists in an information map, then the UPDATE INFOMAP statement will fail. Therefore, it is recommended that you add a prefix or suffix to the property name to ensure uniqueness.

property-value: specifies the value of the property.

description: specifies the description of the property. The description is optional.

REMOVE (property-names-list): removes the specified custom properties from an information map.

The form of the property-names-list value is

"property-name-1" <... "property-name-n">

Interaction:If you specify both the ADD and REMOVE operations, then the REMOVE operation occurs first.

<REPLACE> (custom-properties-list): replaces the current custom properties for an information map with the specified properties.

See the ADD operation for a description of the form of the custom-properties-list value.

Default:REPLACE (if a custom properties list is specified with no operation keyword)

DESCRIPTION="descriptive-text": specifies the description of an information map.

Alias:DESC=

INIT_CAP=YES | NO: specifies whether to capitalize the first letter of each word in the data item name. Specifying YES capitalizes the first letter of each word in the names of data items that you insert subsequently using INSERT DATASOURCE statements with either the _ALL_ or the COLUMNS= option specified or INSERT DATAITEM statements with the COLUMN= option specified.

Default:YES

Tip:When you specify INIT_CAP=YES, the option replaces multiple consecutive blank spaces within a data item name with a single blank space, and it removes trailing blank spaces.

JOIN_MODEL=BASIC | ADVANCED: specifies the join strategy that is used during query generation. By default, the INFOMAPS procedure applies a basic join strategy that is appropriate when the information map is based on a simple star schema (a single fact table with multiple dimensions). Specify JOIN_MODEL=ADVANCED if your information map contains more than one measure data item that is derived from more than one data source (multiple fact tables). The advanced join model prevents inflated query results when there is a MANY-to-MANY cardinality between selected measures that exist in two or more tables.

Default:BASIC

MAPPATH="location": specifies the location within the SAS folders tree for the information map to open or update. The location is required unless a location has been specified in the PROC INFOMAPS statement.

Alias:LOCATION=

Interaction:The location from the UPDATE INFOMAP statement overrides the location from the PROC INFOMAPS statement.

REPLACE_UNDERSCORES=YES | NO: specifies whether to replace each underscore (_) character in the data item name with a blank space. Specifying YES replaces underscores in the names of data items that you insert subsequently using INSERT DATASOURCE statements with either the _ALL_ or the COLUMNS= option specified or INSERT DATAITEM statements with the COLUMN= option specified.

Default:YES

REQUIRED_DATASOURCES=_ALL_ | NONE | ADD (data-source-list) | <REPLACE> (data-source-list) | REMOVE (data-source-list)

specifies how the list of required data sources for the information map is updated. If you want a data source and any associated assigned filters to be used in every query that is generated from an information map, then designate the data source as required for the information map. If you do not designate a data source as required, then the data source and its assigned filters are included in a query only when a data item that references the data source is explicitly selected for the query.

Valid operations are the following:

_ALL_: specifies that all data sources in the information map are required data sources.

NONE: removes the entire list of data sources, if any, that were previously assigned to the information map.

ADD (data-source-list): adds one or more data sources to the list of required data sources for the information map. The data-source-list value has the following form:

("data-source-ID-1" <... "data-source-ID-n" >)

REMOVE (data-source-list): removes one or more data sources from the list of required data sources for the information map.

See the ADD operation for a description of the form of the data-source-list value.

<REPLACE> (data-source-list): replaces the existing list of required data sources for the information map, if any, with the specified list of required data sources.

See the ADD operation for a description of the form of the data-source-list value.

Note:Using the REPLACE operation changes the processing order of the required data sources.

Default:REPLACE (if a data sources list is specified with no operation keyword)

Note:You can use the REQUIRED_DATASOURCE=YES option in the INSERT DATASOURCE and UPDATE DATASOURCE statements to designate a data source as required for the information map.

USE_LABELS=YES | NO: specifies whether to create the data item name using the column label (if available) instead of the column name. Specifying YES uses the column label instead of the column name for data items that you insert subsequently usingINSERT DATASOURCE statements with either the _ALL_ or the COLUMNS= option specified or INSERT DATAITEM statements with the COLUMN= option specified.

Default:YES

Restriction:This option applies only to a relational data source.

VERIFY=YES | NO: specifies whether the INFOMAPS procedure verifies the validity of data items, filters, and relationships during the Update operation. Setting the VERIFY option to NO improves performance, but doing so introduces the risk that invalid data items, filters, or relationships could get saved into an information map.

Default:YES

Details

When you use the UPDATE INFOMAP statement to open an existing information map, the INFOMAPS procedure creates a working copy of the information map in memory. You must submit a SAVE statement to save the working copy before you terminate the INFOMAPS procedure or open a different information map by submitting an IMPORT, NEW INFOMAP, or UPDATE INFOMAP statement. If you do not submit a SAVE statement, then any changes that you have made to the working copy of the information map are lost.

Example

update infomap "my testmap"
      mappath="/Users/myUserID/My Folder"
      verify=no
      description="Map for Domestic Customers";