SAS(R) 9.2 Table Server: TSPL Language Reference
Introduction- TSPL Language Reference
- TSPL Language Concepts
- Introduction to the TSPL Language
- Programming Semantics
- Variables
- Constants
- Data Types
- Identifiers
- How TSPL Processes Nulls and SAS Missing Values
- Type Conversions
- TSPL Expressions
- Dates and Times in TSPL
- TSPL Arrays
- Packages
- Threaded Processing
- TSPL Reserved Words
- TSPL Formats
- Overview of Formats
- General Format Syntax
- Using Formats in TSPL
- Validation of TSPL Formats
- Format Categories
- TSPL 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
- TSPL Functions
- Overview of TSPL Functions
- General Function Syntax
- Using Functions
- Function Categories
- TSPL Function Examples
- ABS Function
- ARCOS Function
- ARSIN Function
- ATAN Function
- ATAN2 Function
- BAND Function
- BLSHIFT Function
- BNOT Function
- BOR Function
- BRSHIFT Function
- BXOR Function
- BYTE Function
- CEIL Function
- CEILZ Function
- COALESCE Function
- COALESCEC Function
- COLLATE Function
- COMPBL Function
- COMPRESS Function
- COS Function
- COSH Function
- CSS Function
- CV Function
- DATE Function
- DATEJUL Function
- DATEPART Function
- DATETIME Function
- DAY Function
- DEQUOTE Function
- DHMS Function
- DIGAMMA Function
- EXP Function
- FLOOR Function
- FLOORZ Function
- FUZZ Function
- GAMMA Function
- GCD Function
- GEOMEAN Function
- GEOMEANZ Function
- HARMEAN Function
- HARMEANZ Function
- HMS Function
- HOUR Function
- INDEX Function
- INDEXC Function
- INDEXW Function
- INT Function
- INTZ Function
- IQR Function
- JULDATE Function
- JULDATE7 Function
- KURTOSIS Function
- LARGEST Function
- LCM Function
- LEFT Function
- LENGTH Function
- LENGTHC Function
- LENGTHM Function
- LGAMMA Function
- LOG Function
- LOG10 Function
- LOG2 Function
- LOWCASE Function
- MAX Function
- MDY Function
- MEAN Function
- MIN Function
- MINUTE Function
- MISSING Function
- MOD Function
- MODZ Function
- MONTH Function
- N Function
- NMISS Function
- NULL Function
- ORDINAL Function
- PCTL Function
- POWER Function
- PUT Function
- QTR Function
- QUOTE Function
- RANGE Function
- RANK Function
- REPEAT Function
- REVERSE Function
- RIGHT Function
- RMS Function
- ROUND Function
- ROUNDE Function
- ROUNDZ Function
- SCAN Function
- SECOND Function
- SIGN Function
- SIN Function
- SINH Function
- SKEWNESS Function
- SLEEP Function
- SMALLEST Function
- SQRT Function
- STD Function
- STDERR Function
- STRIP Function
- SUBSTR Function
- SUM Function
- TAN Function
- TANH Function
- TIME Function
- TIMEPART Function
- TODAY Function
- TRANSLATE Function
- TRANWRD Function
- TRIGAMMA Function
- TRIM Function
- TRUNC Function
- UPCASE Function
- USS Function
- VAR Function
- VERIFY Function
- WEEKDAY Function
- WHICHC Function
- WHICHN Function
- YEAR Function
- YYQ Function
- TSPL Informats
- Overview of Informats
- General Informat Syntax
- How Informats Are Used in TSPL
- How to Specify Informats in TSPL
- Validation of TSPL Informats
- TSPL Informat Examples
- TSPL Hash and Hash Iterator Package Attributes, Methods, and Operators
- ADD Method
- CHECK Method
- CLEAR Method
- DEFINEDATA Method
- DEFINEDONE Method
- DEFINEKEY Method
- DELETE Method
- FIND Method
- FIRST Method
- ITEM_SIZE Attribute
- LAST Method
- NEXT Method
- _NEW_ Operator
- NUM_ITEMS Attribute
- OUTPUT Method
- PREV Method
- REF Method
- REMOVE Method
- REPLACE Method
- SETCUR Method
- TSPL System Methods
- TSPL Statements
- Overview of Statements
- Global Statements
- Method Statements
- TABLE, THREAD, and PACKAGE Statements
- BY Statement
- CONTINUE Statement
- DECLARE Statement
- DECLARE PACKAGE Statement
- DECLARE THREAD Statement
- DO Statement
- DROP Statement
- DROP PACKAGE Statement
- DROP THREAD Statement
- ENDPACKAGE Statement
- ENDTABLE Statement
- ENDTHREAD Statement
- FORWARD Statement
- GLOBAL Statement
- GOTO Statement
- IF Statement, Subsetting
- IF-THEN/ELSE Statement
- KEEP Statement
- Labels Statement
- LEAVE Statement
- METHOD Statement
- Null Statement
- OUTPUT Statement
- PACKAGE Statement
- PUT Statement
- RENAME Statement
- RETAIN Statement
- RETURN Statement
- SELECT Statement
- SET Statement
- SET FROM Statement
- STOP Statement
- TABLE Statement
- THREAD Statement
- TSPL Table Options
- Overview of Table Options
- Using Table Options in TSPL
- How to Specify Table Options in TSPL
- TSPL Table Option Examples
- ALTER= Table Option
- BUFNO= Table Option
- BUFSIZE= Table Option
- BULKLOAD= Table Option
- COMPRESS= Table Option
- DBKEY= Table Option
- DBNULL= Table Option
- DROP= Table Option
- ENCRYPT= Table Option
- KEEP= Table Option
- LABEL= Table Option
- LOCKTABLE= Table Option
- OVERWRITE= Table Option
- PW= Table Option
- READ= Table Option
- RENAME= Table Option
- TYPE= Table Option
- WRITE= Table Option
- TSPL Example Programs
- Example: Find Minimums
- Example: SQL in a TSPL Program
- Example: Make two new tables based on a condition
- Example: Change Case of Text Output
- Example: Scope
- Example: Functions
- Example: Arrays
- Example: SELECT Statement
- Example: GOTO and LEAVE Statements with Labels
- Example: Overloaded Methods
- Example: Analyze a Table Using Multiple Threads
- Example: Data Cleaning
- Example: SUBSTR Function
- Example: PUT with SAS Formats
- Example: Generate Statistics from Table Data
- 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
