SAS Namespace Types

Join

Overview

A Join object may have one JoinTable object as an output. A Join object may have at most two inputs. A Join object may not exist without an associated Select object.

For nested joins, a Join object should be documented for each pair of joined tables. For example: Table1 is joined to Table2, which results in JoinTable1. JoinTable1 is then joined with Table3 to create JoinTable2. JoinTable2 now acts as an input into a Select, which documents the rows and columns that are to be included in the final output table.

Security Inheritance and Enforcement Rules

The following is a list of associations that are used to determine if this object should inherit access controls from another object (inheritance) or if the association is allowed for the object (enforcement). For more information about inheritance and enforcement rules, see the SAS 9.2 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 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 , 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 16
The 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:
OnClause

OwningJoinTable
     Cardinality: 1 to 1
     Partner: TableJoin

The result of this join statement.

Associated Types:
JoinTable

Top of Page