search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
Advanced Search
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS(R) 9.2 Table Server: TSSQL Language Reference
PDF
Contents
About
Introduction
Using This Language Reference
Purpose
Intended Audience
Conventions
Typographical Conventions
Syntax Conventions
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
TSSQL and the ANSI Standard
Compliance
TSSQL Enhancements
TSSQL Limitations
Tables Used in Examples
DENSITIES
WORLDTEMPS
WORLDCITYCOORDS
AFEWWORDS
CUSTONLINE
DICTIONARY Table Descriptions
DICTIONARY.CATALOGS
DICTIONARY.COLUMNS
DICTIONARY.COLUMN_STATISTICS
DICTIONARY.STATISTICS
DICTIONARY.TABLES
ICU License
ICU License - ICU 1.8.1 and later
Recommended Reading
Index here
Product
Release
Base SAS
9.2
SAS Table Server
9.2
Type
Usage and Reference
Copyright Date
February 2009
Last Updated
26Feb2009
SAS 9.2 Table Server TSSQL Language Reference