Informats

Informat
Description
$
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.
$SASNAME
BEST
SPD Server 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-point 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 record 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 day 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.
Last updated: February 8, 2017