-
$ —
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
-
-
$VARYING — Reads varying length values
-
BEST —
SPD Server system chooses best notation
-
BINARY — Converts positive binary values to integers
-
-
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
-
-
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.