• Contents
  • About
  • What’s New in SAS 9.4 FedSQL Language Reference
  • Introduction
    • Using This Language Reference
      • Purpose
      • Intended Audience
    • Conventions
      • Typographical Conventions
      • Syntax Conventions
  • FedSQL Language Reference
    • FedSQL Language Concepts
      • Introduction to the FedSQL Language
      • Running FedSQL Programs
      • Data Source Support
      • Benefits of FedSQL
      • Federated Queries
      • Data Source Connection
      • Data Types
      • Identifiers
      • How FedSQL Processes Nulls and SAS Missing Values
      • Type Conversions
      • NLS Transcoding Failures
      • Join Operations
      • FedSQL Expressions
      • Dates and Times in FedSQL
      • DICTIONARY Tables
      • FedSQL Pass-Through Facility
      • FedSQL Implicit Pass-Through Facility
      • Transactions in FedSQL
      • FedSQL Reserved Words
    • FedSQL Formats
      • Overview of Formats
      • General Format Syntax
      • Using Formats in FedSQL
      • Validation of FedSQL Formats
      • FedSQL Format Examples
      • Using a User-Defined Format
      • SAS Output Delivery System and FedSQL
      • Format Categories
      • NLS Formats Supported by FedSQL
      • Formats Supported with the PUT Function, by Category
      • $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
    • FedSQL Functions
      • Overview of FedSQL Functions
      • General Function Syntax
      • Using FedSQL Functions
      • Aggregate Functions
      • Function Categories
      • FEDSQL Functions by Category
      • ABS Function
      • ACOS Function
      • ASIN Function
      • ATAN Function
      • ATAN2 Function
      • AVG Function
      • BAND Function
      • BETA Function
      • BLACKCLPRC Function
      • BLACKPTPRC Function
      • BLKSHCLPRC Function
      • BLKSHPTPRC Function
      • BLSHIFT Function
      • BOR Function
      • BRSHIFT Function
      • BXOR Function
      • CAST Function
      • CEIL Function
      • CEILZ Function
      • CHARACTER_LENGTH Function
      • COALESCE Function
      • COALESCEC Function
      • COS Function
      • COSH Function
      • COT Function
      • COUNT Function
      • CSS Function
      • CURRENT_DATE Function
      • CURRENT_LOCALE Function
      • CURRENT_TIME Function
      • CURRENT_TIME_GMT Function
      • CURRENT_TIMESTAMP Function
      • CURRENT_TIMESTAMP_GMT Function
      • CV Function
      • DATE Function
      • DATEJUL Function
      • DATEPART Function
      • DAY Function
      • DEGREES Function
      • E Function
      • EXP Function
      • FLOOR Function
      • FLOORZ Function
      • GAMMA Function
      • GCD Function
      • GEOMEAN Function
      • GEOMEANZ Function
      • HARMEAN Function
      • HARMEANZ Function
      • HOUR Function
      • IFNULL Function
      • IQR Function
      • JULDATE Function
      • JULDATE7 Function
      • LARGEST Function
      • KURTOSIS Function
      • LCM Function
      • LOG Function
      • LOG2 Function
      • LOG10 Function
      • LOGBETA Function
      • LOWCASE Function
      • MAD Function
      • MAKEDATE Function
      • MAKETIME Function
      • MAKETIMESTAMP Function
      • MARGRCLPRC Function
      • MARGRPTPRC Function
      • MAX Function
      • MEAN Function
      • MEDIAN Function
      • MIN Function
      • MINUTE Function
      • MOD Function
      • MONTH Function
      • NMISS Function
      • OCTET_LENGTH Function
      • ORDINAL Function
      • PCTL Function
      • PI Function
      • POWER Function
      • PROBBNML Function
      • PROBBNRM Function
      • PROBCHI Function
      • PROBT Function
      • PUT Function
      • QTR Function
      • QUOTE Function
      • RADIANS Function
      • RANGE Function
      • REPEAT Function
      • REVERSE Function
      • RMS Function
      • SECOND Function
      • SIGN Function
      • SIN Function
      • SINH Function
      • SKEWNESS Function
      • SMALLEST Function
      • SQRT Function
      • STD Function
      • STDDEV Function
      • STDERR Function
      • STUDENTS_T Function
      • SUBSTRING Function
      • SUM Function
      • TAN Function
      • TANH Function
      • TIMEPART Function
      • TODAY Function
      • TRIM Function
      • UPCASE Function
      • USS Function
      • VARIANCE Function
      • WEEKDAY Function
      • YEAR Function
      • YYQ Function
    • FedSQL 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>
    • FedSQL Informats
      • Definition of an Informat
      • General Informat Syntax
      • How Informats Are Used in FedSQL
      • How to Specify Informats in FedSQL
      • Validation of FedSQL Informats
      • FedSQL Informat Example
    • FedSQL Statements
      • Overview of Statements
      • FedSQL Statements by Category
      • ALTER TABLE Statement
      • BEGIN Statement
      • COMMIT Statement
      • CREATE INDEX Statement
      • CREATE TABLE Statement
      • CREATE VIEW Statement
      • DESCRIBE VIEW Statement
      • DELETE Statement
      • DROP INDEX Statement
      • DROP TABLE Statement
      • DROP VIEW Statement
      • EXECUTE Statement
      • INSERT Statement
      • ROLLBACK Statement
      • SELECT Statement
      • UPDATE Statement
    • FedSQL Statement Table Options
      • Overview of Statement Table Options
      • How Table Options Interact with Other Types of Options
      • FedSQL Statement Table Option Syntax
      • Understanding BULKLOAD Table Options
      • FedSQL Statement Table Options by Data Source
      • ALTER= Table Option
      • ASYNCINDEX= Table Option
      • BL_ALLOW_READ_ACCESS= Table Option
      • BL_COPY_LOCATION= Table Option
      • BL_CPU_PARALLELISM= Table Option
      • BL_DATA_BUFFER_SIZE= Table Option
      • BL_DEFAULT_DIR= Table Option
      • BL_DISK_PARALLELISM= Table Option
      • BL_ERRORS= Table Option
      • BL_EXCEPTION= Table Option
      • BL_INDEXING_MODE= Table Option
      • BL_LOAD= Table Option
      • BL_LOAD_REPLACE= Table Option
      • BL_LOG= Table Option
      • BL_LOGFILE= Table Option
      • BL_OPTIONS= Table Option
      • BL_PARALLEL Table Option
      • BL_PORT_MAX= Table Option
      • BL_PORT_MIN= Table Option
      • BL_RECOVERABLE= Table Option
      • BL_REMOTE_FILE= Table Option
      • BL_SKIP= Table Option
      • BL_SKIP_INDEX_MAINTENANCE= Table Option
      • BL_SKIP_UNUSABLE_INDEXES= Table Option
      • BL_WARNING_COUNT= Table Option
      • BLOCKSIZE= Table Option
      • BUFNO= Table Option
      • BUFSIZE= Table Option
      • BULKLOAD= Table Option
      • BULKOPTS= Table Option
      • COMPRESS= Table Option
      • COPIES= Table Option
      • DBCREATE_INDEX_OPTS=
      • DBCREATE_TABLE_OPTS= Table Option
      • ENCRYPT= Table Option
      • ENCRYPTKEY= Table Option
      • ENDOBS= Table Option
      • EXTENDOBSCOUNTER= Table Option
      • GP_DISTRIBUTED_BY= Table Option
      • HASH= Table Option
      • IDXNAME= Table Option
      • IDXWHERE= Table Option
      • IOBLOCKSIZE= Table Option
      • LABEL= Table Option
      • LOCKTABLE= Table Option
      • ORDERBY= Table Option
      • ORHINTS= Table Option
      • ORNUMERIC= Table Option
      • PADCOMPRESS= Table Option
      • PARTSIZE= Table Option
      • PARTITION= Table Option
      • PARTITION_KEY= Table Option
      • PERM= Table Option
      • POINTOBS= Table Option
      • PW= Table Option
      • READ= Table Option
      • REUSE= Table Option
      • SQUEEZE= Table Option
      • STARTOBS= Table Option
      • TABLE_TYPE=
      • TD_BUFFER_MODE= Table Option
      • TD_CHECKPOINT= Table Option
      • TD_DATA_ENCRYPTION= Table Option
      • TD_DROP_ERROR_TABLE= Table Option
      • TD_DROP_LOG_TABLE= Table Option
      • TD_DROP_WORK_TABLE= Table Option
      • TD_ERROR_LIMIT= Table Option
      • TD_ERROR_TABLE_1= Table Option
      • TD_ERROR_TABLE_2= Table Option
      • TD_LOG_MECH_TYPE= Table Option
      • TD_LOG_MECH_DATA= Table Option
      • TD_LOG_TABLE= Table Option
      • TD_LOGDB= Table Option
      • TD_MAX_SESSIONS= Table Option
      • TD_MIN_SESSIONS= Table Option
      • TD_NOTIFY_LEVEL= Table Option
      • TD_NOTIFY_METHOD= Table Option
      • TD_NOTIFY_STRING= Table Option
      • TD_PACK= Table Option
      • TD_PACK_MAXIMUM= Table Option
      • TD_PAUSE_ACQ= Table Option
      • TD_SESSION_QUERY_BAND= Table Option
      • TD_TENACITY_HOURS= Table Option
      • TD_TENACITY_SLEEP= Table Option
      • TD_TPT_OPER= Table Option
      • TD_TRACE_LEVEL= and TD_TRACE_LEVEL_INF= Table Options
      • TD_TRACE_OUTPUT= Table Option
      • TD_WORK_TABLE= Table Option
      • TD_WORKING_DB= Table Option
      • THREADNUM= Table Option
      • TYPE= Table Option
      • UCA= Table Option
      • UNIQUESAVE= Table Option
      • WHERENOINDEX= Table Option
      • WRITE= Table Option
  • Appendixes
    • FedSQL and the ANSI Standard
      • Compliance
      • FedSQL Enhancements
      • FedSQL Limitations
    • Data Type Reference
      • Data Types for SAS Data Sets
      • Data Types for SPD Engine Data Sets
      • Data Types for Aster
      • Data Types for DB2 under UNIX and PC Hosts
      • Data Types for Greenplum
      • Data Types for HDMD
      • Data Types for Hive
      • Data Types for MDS
      • Data Types for MySQL
      • Data Types for Netezza
      • Data Types for ODBC
      • Data Types for Oracle
      • Data Types for PostgreSQL
      • Data Types for SAP
      • Data Types for SAP HANA
      • Data Types for SASHDAT
      • Data Types for Sybase IQ
      • Data Types for Teradata
    • Dynamically Executing FedSQL Statements from DS2
    • Tables Used in Examples
      • AfewWords
      • Customers
      • CustonLine
      • Densities
      • Depts
      • Employees
      • GrainProducts
      • Integers
      • Products
      • Sales
      • WorldCityCoords
      • WorldTemps
    • DICTIONARY Table Descriptions
      • DICTIONARY.CATALOGS
      • DICTIONARY.COLUMNS
      • DICTIONARY.COLUMN STATISTICS
      • DICTIONARY.STATISTICS
      • DICTIONARY.TABLES
    • Usage Notes
    • ICU License
  • Recommended Reading


ProductRelease
Base SAS9.4_M2
Type
Usage and Reference
Copyright Date
July 2014
Last Updated
05Aug2014