space
Previous Page | Next Page

SAS Namespace Types

Column


Subclass of LogicalColumn

Subtypes


Overview

Represents a column in a table, view, etc.

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.

Attributes

Name Description Type Length
BeginPosition The position within a record where the column begins. This is used for external tables and/or record-oriented tables.   int  
EndPosition The position within the record where the column ends. This is used for external tables and/or record-oriented tables.   int  
IsDiscrete Indicates whether the contents of this column are discrete values.   int  
IsNullable This attribute indicates whether this column can contain NULL values or not. It has a 0 or 1 value.   int  
SASAttribute Data type attributes. Used to facilitate applications that wish to process variables based on similar semantics. These attributes are read-only and set by the supervisor based on the data type. String 16  
SASColumnLength This is the length of the column for SAS software. Usually, this will be the same value as the ColumnLength attribute defined in LogicalColumn.   int  
SASColumnName This is the name that SAS software uses to access the column. String 32  
SASColumnType This represents the SAS type (character or numeric) for this column. The value can be either 'C' or 'N'.   String 1  
SASExtendedColumnType The extended column type for SAS software. String 16  
SASExtendedLength This attribute is the length of the data value in the interchange format. In most cases the SASExtendedLength is derived from the precision.   double  
SASPrecision This attribute is the precision of the data type, up to 4G. The exact meaning of precision corresponds to the declared type of the variable. In general, the precision of any data type is the number of atomic elements used to store the representable set of values   double  
SASScale This attribute applies to the decimal (XV_T_DEC) data type only. For decimal, a scale of 0 (zero) indicates that the represented number is an integer. The value of the fixed-point decimal number is defined to be the rational number, I * 10 -S, where S is the scale and I is an integer with a maximum of P digits.   double  
SortOrder This is an indication of the sort order of this column in this table. It can be ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, DSORDER, NONE, PROHIBITED.   String 24  
SummaryRole This is the role of this column in a summarization. It can be CLASS, ID, STATISTIC, _FREQ_, or _TYPE_.   String 12  

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, ColumnLength, ColumnName, ColumnType, IsHidden, LockedBy, PublicType, SASFormat, SASInformat, 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
AnalyticColumns

Partner: OwningColumn

0 to * The analytic column attributes associated with this column.  AnalyticColumn
DisplayForKeys

Partner: DisplayColumns

0 to * The key that uses this column for display purposes. Key
ForeignKey
UniqueKey
ForeignKeyAssociations

Partner: ForeignKeyColumn

0 to * The list of KeyAssociation objects that link this column, which is part of a foreign key, with the columns that comprise the unique key. KeyAssociation
Indexes

Partner: Columns

0 to * The list of indexes for this column.  Index
Keys

Partner: KeyedColumns

0 to * This is the list of keys that this column is associated with. The column may be part of a unique or primary key, or part of a foreign key. Key
ForeignKey
UniqueKey
QueryClauses

Partner: Columns

0 to * The query clauses associated with this column. QueryClause
GroupByClause
HavingClause
OnClause
OrderByClause
RowSelector
WhereClause
Table

Partner: Columns

1 to 1 The table that contains these columns.  DataTable
ExternalTable
JoinTable
PhysicalTable
QueryTable
RelationalTable
TableCollection
WorkTable
UniqueKeyAssociations

Partner: UniqueKeyColumn

0 to * The list of KeyAssociation objects that associate a column in this key to a column in a foreign key.  KeyAssociation
XPaths

Partner: AssociatedMapColumn

0 to * The list of XPath objects that define the path of the column in the XML source.  XPath

Inherited Associations
AccessControls/Objects, Changes/Objects, CustomAssociations/OwningObject, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, FavoritesContainers/Favorites, Groups/Members, Implementors/ImplementedObjects, Keywords/Objects, LocalizedAttributes/AssociatedLocalizedObject, Notes/Objects, PrimaryPropertyGroup/AssociatedObject, Prompts/PromptEnabledObject, Properties/AssociatedObject, PropertySets/OwningObject, ReferencedObjects/AssociatedObjects, ResponsibleParties/Objects, SourceFeatureMaps/FeatureSources, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, TargetFeatureMaps/FeatureTargets, TargetTransformations/TransformationTargets, Timestamps/Objects, Trees/Members, TSObjectNamespace/TSObjects, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject

Attribute Details

BeginPosition
     Type:  int  

The position within a record where the column begins. This is used for external tables and/or record-oriented tables.

EndPosition
     Type:  int  

The position within the record where the column ends. This is used for external tables and/or record-oriented tables.

IsDiscrete
     Type:  int  

Indicates whether the contents of this column are discrete values.

IsNullable
     Type:  int  

This attribute indicates whether this column can contain NULL values or not. It has a 0 or 1 value.

SASAttribute
     Type:  String 16  

Data type attributes. Used to facilitate applications that wish to process variables based on similar semantics. These attributes are read-only and set by the supervisor based on the data type: XV_A_NUMERIC - Values are numeric; XV_A_STRING - Values are strings; XV_A_VARYING - Values are variable-length; XV_A_BINARY - Values contain binary data; XV_A_UNICODE - Values contain Unicode data; XV_A_LOB - Values are large objects; XV_A_DATETIME - Values are dates, times or date-times.

SASColumnLength
     Type:  int  

This is the length of the column for SAS software. Usually, this will be the same value as the ColumnLength attribute defined in LogicalColumn.

SASColumnName
     Type:  String 32  

This is the name that SAS software uses to access the column. Typically, the SAS name is 32 characters in length and conforms to the SAS naming restrictions; for example, no space or special characters. It is the Name field in the NAMESTR.

This attribute can support mixed-case names, and special characters and spaces in the text if there is a PropertySet object and one or two Property objects configured on the table to indicate that this table requires special handling for its names.

For example, you would define and associate a PropertySet object named DBMSNames with a SetRole="DBMSNames" with the Column object. The PropertySet object can have two Property objects associated with it: Case and SpecChar. The Property named Case can specify whether the values in the SASTableName/SASColumnName attribute are case-sensitive or not. The Property named SpecChar can specify whether the values in the SASTableName/SASColumnName can contain special characters, including spaces.

SASColumnType
     Type:  String 1  

This represents the SAS type (character or numeric) for this column. The value can be either 'C' or 'N'.

SASExtendedColumnType
     Type:  String 16  

The extended column type for SAS software. Valid values are: XV_T_FLOAT - Floating-point Value (The Pre-V9 Numeric Type); XV_T_DEC - Fixed-point Decimal Value; XV_T_INT - Signed Integer Value; XV_T_CHAR - Fixed-length Character (The Pre-V9 Character Type); XV_T_VARCHAR - Variable-length Character Value; XV_T_CLOB - Character Large Object; XV_T_BCHAR - Fixed-length Binary; XV_T_BVARCHAR - Variable-length Binary Value; XV_T_BLOB - Binary Large Object; XV_T_LOBFILE - BLOB File; XV_T_UCHAR - Fixed-length Unicode CHAR; XV_T_UVARCHAR - Variable-length Unicode CHAR Value; XV_T_UCLOB - Unicode Character Large Object; XV_T_DATE - Date value XV_T_TIME - Local time value; XV_T_TIMEZ - Zoned time value; XV_T_DATETIME - Local datetime value, a timestamp; XV_T_DATETIMEZ - Zoned date time value, a timestamp; XV_T_IDENTITY - Observation identity.

SASExtendedLength
     Type:  double  

This attribute is the length of the data value in the interchange format. In most cases the SASExtendedLength is derived from the precision.

SASPrecision
     Type:  double  

This attribute is the precision of the data type, up to 4G. The exact meaning of precision corresponds to the declared type of the variable. In general, the precision of any data type is the number of atomic elements used to store the representable set of values

SASScale
     Type:  double  

This attribute applies to the decimal (XV_T_DEC) data type only. For decimal, a scale of 0 (zero) indicates that the represented number is an integer. The value of the fixed-point decimal number is defined to be the rational number, I * 10 -S, where S is the scale and I is an integer with a maximum of P digits.

SortOrder
     Type:  String 24  

This is an indication of the sort order of this column in this table. It can be ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, DSORDER, NONE, PROHIBITED.

SummaryRole
     Type:  String 12  

This is the role of this column in a summarization. It can be CLASS, ID, STATISTIC, _FREQ_, or _TYPE_.

Association Details

AnalyticColumns
     Cardinality:   0 to *
     Partner:   OwningColumn

The analytic column attributes associated with this column. 

Associated Types:
AnalyticColumn

DisplayForKeys
     Cardinality:   0 to *
     Partner:   DisplayColumns

The key that uses this column for display purposes. 

Associated Types:
Key, ForeignKey, UniqueKey

ForeignKeyAssociations
     Cardinality:   0 to *
     Partner:   ForeignKeyColumn

The list of KeyAssociation objects that link this column, which is part of a foreign key, with the columns that comprise the unique key. 

Associated Types:
KeyAssociation

Indexes
     Cardinality:   0 to *
     Partner:   Columns

The list of indexes for this column. 

Associated Types:
Index

Keys
     Cardinality:   0 to *
     Partner:  KeyedColumns

This is the list of keys that this column is associated with. The column may be part of a unique or primary key, or part of a foreign key. 

Associated Types:
Key, ForeignKey, UniqueKey

QueryClauses
     Cardinality:   0 to *
     Partner:   Columns

The query clauses associated with this column.

Associated Types:
QueryClause, GroupByClause, HavingClause, OnClause, OrderByClause, RowSelector, WhereClause

Table
     Cardinality:   1 to 1
     Partner:   Columns

The table that contains these columns. 

Associated Types:
DataTable, ExternalTable, JoinTable, PhysicalTable, QueryTable, RelationalTable, TableCollection, WorkTable

UniqueKeyAssociations
     Cardinality:   0 to *
     Partner:   UniqueKeyColumn

The list of KeyAssociation objects that associate a column in this key to a column in a foreign key. 

Associated Types:
KeyAssociation

XPaths
     Cardinality:   0 to *
     Partner:   AssociatedMapColumn

The list of XPath objects that define the path of the column in the XML source. 

Associated Types:
XPath

Previous Page | Next Page | Top of Page