The INFOMAPS Procedure

UPDATE INFOMAP Statement

Updates an existing information map.

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.

Options

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) | REPLACE (custom-properties-list) | REMOVE (property-names-list)

specifies how custom properties for the information map are updated. Valid operations are the following:

NONE

removes all the existing custom properties from the information map, if there are any.

ADD (custom-properties-list)

adds the specified custom properties to the information map.

The form of the custom-properties-list 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.

Requirement:	Property names must be unique. If a property name already exists in the 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.
Restriction:	Property names cannot begin with an underscore (_) character.

property-value

specifies the value of the property.

description

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

REPLACE (custom-properties-list)

replaces the custom properties for the information map with the specified custom properties.

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

REMOVE (properties-names-list)

removes the specified custom properties from the information map.

The form of the properties-names-list is

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

Interaction:

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

DESCRIPTION="descriptive-text"

specifies the description of the information map, which can be viewed by the information map consumer.

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 one or more of the following statements:

INSERT DATASOURCE with either the _ALL_ or the COLUMNS= option specified
INSERT DATAITEM 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.

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 one or more of the following statements:

INSERT DATASOURCE with either the _ALL_ or the COLUMNS= option specified
INSERT DATAITEM with the COLUMN= option specified

Default:

YES

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 using one or more of the following statements:

INSERT DATASOURCE with either the _ALL_ or the COLUMNS= option specified
INSERT DATAITEM 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";

Top of Page