Previous Page | Next Page

SAS Namespace Types


Subclass of ClassifierMap


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.


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


= 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

Partner: OwningJoin

0 to 1 The on statement of this join object.  OnClause

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

     Type:  String 16  

The type of the join (inner, full outer, left outer, right outer).

Association Details

     Cardinality:   0 to 1
     Partner:   OwningJoin

The on statement of this join object. 

Associated Types:

     Cardinality:   1 to 1
     Partner:   TableJoin

The result of this join statement.  

Associated Types:

Previous Page | Next Page | Top of Page