2.13. Reading Delimited Raw Data

Delimited raw data files have a special character separating the data values. That character is often a comma (as in CSV or comma-separated values files), but it can also be a tab, semicolon, space, or some other character.

Input Data

This example uses data from a file named Eruptions.csv. There are four variables: the name of each volcano, followed by the date an eruption started, the date that eruption ended, and the Volcanic Explosivity Index (VEI). Notice that this file has commas between the data values, and the first line contains the column names.

Volcano, StartDate, EndDate, VEI Barren Island, 12/20/1795, 12/21/1795, 2 Barren Island, 12/20/1994, 06/05/1995, 2 Erebus, 12/12/1912, . , 2 Erebus, 01/03/1972, ...

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.