 |
|
| SAS Namespace Types |
Join
Subclass of ClassifierMap
Overview
The output of a Join is limited to one JoinTable. A Join may have at most two inputs. A Join may not exist without a Select.
For nested joins a Join should be documented for each pair of joined tables. For example: Table1 is joined to Table2 that results in JoinTable1. JoinTable1 is then joined with Table3 to create JoinTable2. JoinTable2 now acts as in input into a Select that documents the rows and columns that are to be included in the final output table.Security Inheritance and Enforcement Rules
The following list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.
- Steps
Attributes
| Name | Description | Type | Length |
| JoinType | The type of the join (inner, full outer, left outer, right outer). | String | 16 |
Inherited Attributes
Name,
Id,
Desc,
MetadataCreated,
MetadataUpdated,
ChangeState,
IsActive,
IsHidden,
IsUserDefined,
LockedBy,
PublicType,
TransformRole,
UsageVersion
Associations
= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.
| Name | Cardinality | Description | Associated Types |
| OnForJoin Partner: OwningJoin | 0 to 1 | The on statement of this join object. | OnClause |
| OwningJoinTable Partner: TableJoin | 1 to 1 | The result of this join statement. | JoinTable |
Inherited Associations
AccessControls/Objects,
AssociatedPrompt/ValueSource,
AssociatedRowSelector/OwningClassifierMap,
Changes/Objects,
ClassifierSources/SourceClassifierMaps,
ClassifierTargets/TargetClassifierMaps,
ComputeLocations/ComputeTasks,
ConditionActionSets/AssociatedTransformation,
CustomAssociations/OwningObject,
Customizers/CustomizedTransformations,
DeployedComponents/InitProcesses,
Documents/Objects,
Extensions/OwningObject,
ExternalIdentities/OwningObject,
FavoritesContainers/Favorites,
FeatureMaps/AssociatedClassifierMap,
Groups/Members,
Implementors/ImplementedObjects,
Keywords/Objects,
LocalizedAttributes/AssociatedLocalizedObject,
Notes/Objects,
PrimaryPropertyGroup/AssociatedObject,
Prompts/PromptEnabledObject,
Properties/AssociatedObject,
PropertySets/OwningObject,
ReferencedObjects/AssociatedObjects,
ResponsibleParties/Objects,
SourceCode/AssociatedTransformation,
SourceSpecifications/SpecSourceTransformations,
SourceTransformations/TransformationSources,
SpecSourceTransformations/SourceSpecifications,
SpecTargetTransformations/TargetSpecifications,
Steps/Transformations,
SubstitutionVariables/OwningTransformation,
TargetSpecifications/SpecTargetTransformations,
TargetTransformations/TransformationTargets,
Timestamps/Objects,
TransformationSources/SourceTransformations,
TransformationTargets/TargetTransformations,
Trees/Members,
TriggeredEvents/TriggeringTransforms,
TriggeringEvents/TriggeredTransforms,
TSObjectNamespace/TSObjects,
UsedByPrototypes/UsingPrototype,
UsingPrototype/UsedByPrototypes,
Variables/AssociatedObject
Attribute Details
JoinType
Type: String 16The type of the join (inner, full outer, left outer, right outer).
Association Details
OnForJoin
Cardinality: 0 to 1
Partner: OwningJoin
The on statement of this join object.
Associated Types:
OnClauseOwningJoinTable
Cardinality: 1 to 1
Partner: TableJoin
The result of this join statement.
Associated Types:
JoinTable
|
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.