SAS(R) 9.2 Table Server: TSSQL Language Reference
Introduction- TSSQL Language Reference
- TSSQL Language Concepts
- Introduction to the TSSQL Language
- Data Types
- Identifiers
- How TSSQL Processes Nulls and SAS Missing Values
- Type Conversions
- TSSQL Expressions
- Dates and Times in TSSQL
- DICTIONARY Tables
- TSSQL Pass-Through Facility
- TSSQL Reserved Words
- TSSQL Formats
- Overview of Formats
- General Format Syntax
- Validation of TSSQL Formats
- Format Categories
- TSSQL Format Examples
- Formats Documented in Other SAS Publications
- $BASE64Xw. Format
- $BINARYw. Format
- $CHARw. Format
- $HEXw. Format
- $OCTALw. Format
- $QUOTEw. Format
- $REVERJw. Format
- $REVERSw. Format
- $UPCASEw. Format
- $w. Format
- BESTw. Format
- BESTDw.p Format
- BINARYw. Format
- COMMAw.d Format
- COMMAXw.d Format
- Dw.p Format
- DATEw. Format
- DATEAMPMw.d Format
- DATETIMEw.d Format
- DAYw. Format
- DDMMYYw. Format
- DDMMYYxw. Format
- DOLLARw.d Format
- DOLLARXw.d Format
- DOWNAMEw. Format
- DTDATEw. Format
- DTMONYYw. Format
- DTWKDATXw. Format
- DTYEARw. Format
- DTYYQCw. Format
- Ew. Format
- EUROw.d Format
- EUROXw.d Format
- FLOATw.d Format
- FRACTw. Format
- HEXw. Format
- HHMMw.d Format
- HOURw.d Format
- IEEEw.d Format
- JULIANw. Format
- MMDDYYw. Format
- MMDDYYxw. Format
- MMSSw.d Format
- MMYYw. Format
- MMYYxw. Format
- MONNAMEw. Format
- MONTHw. Format
- MONYYw. Format
- NEGPARENw.d Format
- NENGOw. Format
- OCTALw. Format
- PERCENTw.d Format
- PERCENTNw.d Format
- QTRw. Format
- QTRRw. Format
- ROMANw. Format
- SIZEKw.d Format
- SIZEKMGw.d Format
- TIMEw.d Format
- TIMEAMPMw.d Format
- TODw.d Format
- VAXRBw.d Format
- w.d Format
- WEEKDATEw. Format
- WEEKDATXw. Format
- WEEKDAYw. Format
- YEARw. Format
- YENw.d Format
- YYMMw. Format
- YYMMxw. Format
- YYMMDDw. Format
- YYMMDDxw. Format
- YYMONw. Format
- YYQw. Format
- YYQxw. Format
- YYQRw. Format
- YYQRxw. Format
- YYQZw. Format
- Zw.d Format
- TSSQL Functions
- Overview of TSSQL Functions
- Aggregate Functions
- Function Categories
- ABS Function
- ACOS Function
- ASIN Function
- ATAN Function
- ATAN2 Function
- AVG Function
- CEILING Function
- COS Function
- COSH Function
- COT Function
- COUNT Function
- CSS Function
- CURRENT_DATE Function
- CURRENT_TIME Function
- CURRENT_TIME_GMT Function
- CURRENT_TIMESTAMP Function
- CURRENT_TIMESTAMP_GMT Function
- DAY Function
- DEGREES Function
- E Function
- EXP Function
- FLOOR Function
- HOUR Function
- IFNULL Function
- KURTOSIS Function
- LOCALTIME Function
- LOCALTIMESTAMP Function
- LOG Function
- LOG10 Function
- LOG2 Function
- LOWER Function
- MAX Function
- MIN Function
- MINUTE Function
- MOD Function
- MONTH Function
- NMISS Function
- OCTET_LENGTH Function
- PI Function
- POWER Function
- PROBT Function
- PUT Function
- RADIANS Function
- RANGE Function
- SECOND Function
- SIGN Function
- SIN Function
- SINH Function
- SKEWNESS Function
- SQRT Function
- STDDEV Function
- STDERR Function
- STUDENTS_T Function
- SUBSTRING Function
- SUM Function
- TAN Function
- TANH Function
- TRIM Function
- UPPER Function
- USS Function
- VARIANCE Function
- YEAR Function
- TSSQL Expressions and Predicates
- Overview of Expressions and Predicates
- BETWEEN Predicate
- CASE Expression
- COALESCE Expression
- DISTINCT Predicate
- EXISTS Predicate
- IN Predicate
- IS FALSE Predicate
- IS MISSING Predicate
- IS NULL Predicate
- IS TRUE Predicate
- IS UNKNOWN Predicate
- LIKE Predicate
- NULLIF Expression
- <sql-expression>
- TSSQL Informats
- Definition of an Informat
- General Informat Syntax
- How Informats Are Used in TSSQL
- How to Specify Informats in TSSQL
- Validation of TSSQL Informats
- TSSQL Informat Examples
- TSSQL Statements
- Overview of Statements
- ALTER TABLE Statement
- ALTER VIEW Statement
- ANALYZE Statement
- BEGIN Statement
- COMMIT Statement
- CREATE INDEX Statement
- CREATE TABLE Statement
- CREATE VIEW Statement
- DELETE Statement
- DROP INDEX Statement
- DROP TABLE Statement
- DROP VIEW Statement
- INSERT Statement
- ROLLBACK Statement
- SELECT Statement
- UPDATE Statement
- TSSQL Statement Table Options
- Overview of Statement Table Options
- Syntax
- Using TSSQL Statement Table Options
- ALTER= Table Option
- BL_LOAD_REPLACE= Table Option
- BL_LOG= Table Option
- BL_OPTIONS= Table Option
- BUFNO= Table Option
- BUFSIZE= Table Option
- BULKLOAD= Table Option
- BULKOPTS= Table Option
- COMPRESS= Table Option
- DBCREATE_TABLE_OPTS= Table Option
- ENCRYPT= Table Option
- IDXNAME= Table Option
- IDXWHERE= Table Option
- LABEL= Table Option
- LOCKTABLE= Table Option
- PW= Table Option
- READ= Table Option
- REUSE= Table Option
- TYPE= Table Option
- WRITE= Table Option
- Appendixes
Index here
| Product | Release |
|---|---|
| Base SAS | 9.2 |
| SAS Table Server | 9.2 |
- Type
- Usage and Reference
- Copyright Date
- February 2009
- Last Updated
- 26Feb2009
