SAS Namespace Types

Column

Subclass of LogicalColumn

Subtypes

ColumnRange

Overview

Represents a column in a table, view, etc.

Security Inheritance and Enforcement Rules

The following is a list of associations which 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.

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	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 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 clause that is referencing 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 association objects that associates a column in this key to a column in a foreign key.	KeyAssociation
XPaths Partner: AssociatedMapColumn	0 to *	The list of XPath objects which defines the path of the column in the XML source.	XPath

Inherited Associations
AccessControls/Objects , Changes/Objects , CustomAssociations/OwningObject , Documents/Objects , Extensions/OwningObject , ExternalIdentities/OwningObject , 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
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. Valid values are:

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 property set and one or two properties are configured on the table to indicate that this table requires special handling for its names.
In order to support special characters and spaces, as well as the ability to support case-sensitive names in the text of this attribute, a PropertySet object must be attached to the table. The PropertySet is named DBMSNames with a SetRole=DBMSNames. This set can contain two properties: Case and SpecChar. Case indicate whether the values in the SASTableName/SASColumnName attribute are case-sensitive. SpecChar indicates 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 datetime 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 clause that is referencing 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 association objects that associates 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 which defines the path of the column in the XML source.

Associated Types:
XPath

Top of Page