 |
|
| 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.
- Table
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: intThe position within a record where the column begins. This is used for external tables and/or record-oriented tables.
EndPosition
Type: intThe position within the record where the column ends. This is used for external tables and/or record-oriented tables.
IsDiscrete
Type: intIndicates whether the contents of this column are discrete values.
IsNullable
Type: intThis attribute indicates whether this column can contain NULL values or not. It has a 0 or 1 value.
SASAttribute
Type: String 16Data 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: intThis 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 32This 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 1This represents the SAS type (character or numeric) for this column. The value can be either 'C' or 'N'.
SASExtendedColumnType
Type: String 16The 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: doubleThis attribute is the length of the data value in the interchange format. In most cases the SASExtendedLength is derived from the precision.
SASPrecision
Type: doubleThis 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: doubleThis 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 24This 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 12This 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:
AnalyticColumnDisplayForKeys
Cardinality: 0 to *
Partner: DisplayColumns
The key that uses this column for display purposes.
Associated Types:
Key, ForeignKey, UniqueKeyForeignKeyAssociations
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:
KeyAssociationIndexes
Cardinality: 0 to *
Partner: Columns
The list of indexes for this column.
Associated Types:
IndexKeys
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, UniqueKeyQueryClauses
Cardinality: 0 to *
Partner: Columns
The query clauses associated with this column.
Associated Types:
QueryClause, GroupByClause, HavingClause, OnClause, OrderByClause, RowSelector, WhereClauseTable
Cardinality: 1 to 1
Partner: Columns
The table that contains these columns.
Associated Types:
DataTable, ExternalTable, JoinTable, PhysicalTable, QueryTable, RelationalTable, TableCollection, WorkTableUniqueKeyAssociations
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:
KeyAssociationXPaths
Cardinality: 0 to *
Partner: AssociatedMapColumn
The list of XPath objects that define the path of the column in the XML source.
Associated Types:
XPath
|
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.