Reading Raw Data |
Writing the DATA Step Program |
Column Input
In this lesson, you'll be working with column input, the most common input style. Column input specifies actual column locations for values. However, column input is appropriate only in certain situations. When you use column input, your data must be
|
Standard and Nonstandard Numeric Data
Standard numeric data values can only contain
Nonstandard numeric data include
The external file referenced by the fileref Staff contains the personnel information for a technical writing department of a small computer manufacturer. The fields contain values for each employee's last name, first name, job title, and annual salary. |
Raw Data File Staff
1---+----10---+----20---+--- |
EVANS DONNY 112 29,996.63 |
HELMS LISA 105 18,567.23 |
HIGGINS JOHN 111 25,309.00 |
LARSON AMY 113 32,696.78 |
MOORE MARY 112 28,945.89 |
Notice that the values for Salary contain
commas. So, the values for Salary are considered to be
nonstandard numeric values. |
Fixed Field Data
Raw data can be organized in several different ways. |
This external file contains data that is free-format, meaning data that is not arranged in columns. Notice that the values for a particular field do not begin and end in the same columns. Column input can not be used to read data organized in this way. |
|
This external file contains data that is arranged in columns or fixed fields. You can specify a beginning and ending column for each field. Let's look at how column input can be used to read this data. |
|