Informats

$ — Reads standard character data
$BINARY — Converts binary values to character values
$CB — Reads standard character data from column-binary files
$CHAR — Reads character data with blanks
$HEX — Converts hexadecimal data to character data
$OCTAL — Converts octal data to character data
$PHEX — Converts packed hexadecimal data to character data
$QUOTE — Converts quoted strings to character data
$SASNAME —
$VARYING — Reads varying length values
BEST — SPD Server system chooses best notation
BINARY — Converts positive binary values to integers
BITS — Extract bits
COMMA — Removes embedded characters (for example $,.)
COMMAX — Removes embedded characters (for example $,.) European style
D — Reads scientific notation
DATE — Reads date values (ddmmmyy)
DATETIME — Reads datetime values (ddmmmyy hh:mm:ss.ss)
DDMMYY — Reads date values (ddmmyy)
DOLLAR — Reads numeric values with dollar signs, commas, and decimal points
DOLLARX — Reads numeric values with dollar signs, commas, and decimal points (European style)
E — Reads scientific notation
F — Reads scientific notation
HEX — Converts hexadecimal positive binary values to fixed- or floating-point values
IB — Reads integer binary (fixed-point) values
JULIAN — Reads Julian dates (yyddd or yyyyddd)
MMDDYY — Reads date values (mmddyy)
MONYY — Reads month and year date values (mmmyy)
MSEC — Reads TIME MIC values
OCTAL — Converts octal values to integers
PD — Reads packed decimal data
PDTIME — Reads packed decimal time of SMF and RMF records
PERCENT — Converts percentages into numeric values
PIB — Reads positive integer binary (fixed-point) values
PK — Reads unsigned packed decimal data
PUNCH — Reads whether a row of column-binary data is punched
RMFSTAMP — Reads time and date fields of RMF records
ROW — Reads a column-binary field down a card column
SMFSTAMP — Reads time-date values of SMF records
TIME — Reads hours, minutes, and seconds (hh:mm:ss.ss)
TODSTAMP — Reads 8-byte time-of-day stamp
TU — Reads timer units
YYMMDD — Reads date values (yymmdd)
YYQ — Reads quarters of the year

Note: Informats that begin with a $ sign are character informats. Otherwise, the informat accepts numeric values.

The SQL procedure itself does not use the INFORMAT= modifier: it stores informats in its table definitions so that other procedures and the DATA step can use the information. SPD Server informats are provided now to allow for forward compatibility with future development.