Reading Free-Format Data with Non-Blank Delimiters and Missing Values
Working with Delimiters
Most free-format data fields are clearly
separated by blanks and are easy to imagine as variables and observations.
But fields can also be separated by other delimiters, such as commas,
as shown below.
Figure 18.10 Raw Data File with Comma Delimiters
When characters other than blanks are used to separate
the data values, you can tell SAS which field delimiter to use. Use
the DLM= option in the INFILE statement to specify a delimiter other
than a blank (the default).
|
Syntax, DLM= option:
DLM=delimiter(s)
|
Get SAS Certification Prep Guide, 4th Edition 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.
