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.