1.9. Selected Informats
SAS informats (also called input formats or read-in formats) tell SAS Enterprise Guide how to interpret input data. You can specify informats in the column Properties window of a Data Grid, or in the Column Options page when reading data. Here are a few of the many informats available in SAS Enterprise Guide.
| Informat | Definition | Width range | Default width |
|---|---|---|---|
| Character | |||
| $w. | Reads character data—trims leading blanks | 1–32,767 | none |
| $UPCASEw. | Converts character data to uppercase | 1–32,767 | 8 |
| Date, Time, and Datetime[1] | |||
| ANYDTDTEw. | Reads dates in any form—when dates are ambiguous, uses the DATESTYLE system option to determine | 5–32 | 9 |
| DATEw. | Reads dates in the form: ddmonyy or ddmonyyyy | 7–32 | 7 |
| DATETIMEw. | Reads datetime values in the form: ddmonyy hh:mm:ss.ss ... | ||
Get The Little SAS® Book for Enterprise Guide® 4.1 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
