The INFOMAPS Procedure |
Required Arguments |
specifies the columns to be joined to create a single relationship between two tables.
Requirement: | The columns referenced in the conditional expression must be qualified with the associated data source ID and must be enclosed in double angle brackets (<< >>). |
specifies the data source ID of the first table in the relationship.
specifies the data source ID of the second table in the relationship.
Options |
describes the relationship between rows in the first data source and rows in the second data source.
Default: | If the CARDINALITY= option is not specified, then the cardinality defaults to UNKNOWN. |
specifies additional properties for the relationship. Custom properties are supported by specific SAS applications such as SAS Marketing Automation. 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
specifies the name of the property.
Requirement: | Property names must be unique. If a property name already exists in the relationship, then the INSERT RELATIONSHIP 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. |
specifies the value of the property.
specifies the description of the property. The description is optional.
specifies the description of the relationship, which can be viewed by the information map consumer.
Alias: | DESC |
specifies the ID of the relationship to be inserted. If you do not specify an ID, the INFOMAPS procedure generates a unique ID.
specifies the type of join.
returns all the rows in one table that have one or more matching rows in the other table
returns all the rows in the specified left table, plus the rows in the specified right table that match rows in the left table
returns all the rows in the specified right table, plus the rows in the specified left table that match rows in the right table
returns all the rows in both tables
Default: | INNER |
Details |
The INSERT RELATIONSHIP statement applies only to relational tables. If a join already exists between the specified tables, then the new join replaces the old one, unless a new and unique ID is specified.
When specifying a table, you must specify the data source ID associated with the table in an information map. IDs are case sensitive. You can define data source ID values when you insert or update the data sources. You can use the LIST DATASOURCES statement to see the IDs of data sources in your information map.
Example |
insert relationship left_table="CUSTOMER" right_table="TRANSACTION" condition="(<<CUSTOMER.Cust_ID>>=<<TRANSACTION.Cust_ID>>)" join=inner id="join_customer_to_transaction";
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.