INFOMAPS Procedure
UPDATE DATASOURCE Statement
Updates the properties of a data source in the current
information map.
Syntax
UPDATE DATASOURCE "data-source-ID" <options>;
Summary of Optional Arguments
specifies the description of the data source.
specifies the ID of the data source to update.
specifies a new name for the data source.
specifies whether the data source is added to the
list of required data sources for the information map.
Required Argument
- "data-source-ID"
- specifies the ID of
the data source to update.
Optional Arguments
- DESCRIPTION="descriptive-text"
- specifies the description
of the data source.
- ID="data-source-ID"
- specifies the ID of
the data source to update.
- NAME="data-source-name"
- specifies a new name for the data source. When you change the
name, you create a logical representation of the physical data source.
You are not duplicating any physical data.
- REQUIRED_DATASOURCE=YES | NO
- specifies whether the data source is added to the
list of required data sources for the information map. By default, 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. Specify YES if you want the data source and any associated
assigned filters to be used in every query that is generated from
the information map.
Default:NO
Note:After the data source is updated, you can use the REQUIRED_DATASOURCES=
option in the UPDATE CURRENT_MAP or UPDATE INFOMAP statements to control
whether it is required.
Example
update datasource "Customer"
name="Customer_US"
description="Customers from the US"
required_datasource=no;
Copyright © SAS Institute Inc. All rights reserved.