BASE SAS – Reading raw data arranged in columns

Some of the values on raw data file doesn’t have spaces or any other delimiter between all the values or period for missing data but value is found in same place or position in a data file. In this situation we can not use list input.

In order to read this type of data files we uses column input. In column INPUT we specify the position or range of the column data is available.

INPUT Name $ 1-10 Age 11-13;

Name variable from input file will be read from position 1 to position 10 and this is a character variable, you can see a $ symbol placed. Age will be read from position 11-13 and a numeric variable.

Example Input file :

Program to read the above file:

Output :