Column Input Review (2)

Reading Raw Data in Fixed Fields

Column Input Review

Column Input Features

Column input has several features that make it useful for reading raw data.

Values for character variables values can be up to 32K and can contain embedded blanks.

     input Name $ 1-25;

1---+----10---+----20---+-

JOSEPH PAUL THACKERY JR.

No placeholder is required for missing data. A blank field is read as missing and does not cause other fields to be read incorrectly.

     input Item $ 1-13 IDnum $ 15-19
             InStock 21-22 BackOrd 24-25;

1---+----10---+----20---+-

BIRD FEEDER   LG088  3 20

6 GLASS MUGS  SB082    12

GLASS TRAY    BQ049 12  6

     input Item $ 1-13 IDnum $ 15-19 Supplier $ 15-16 
           InStock 21-22 BackOrd 24-25;

1---+----10---+----20---+--

PADDED HANGRS MNQ256 15 20

JEWELRY BOX   AJQ498 23  0

RED APRON     AQ072  9 12

     input Item $ 1-13 IDnum $ 14-18 InStock 19-20 
           BackOrd 21-22;

1---+----10---+----20---+--

PADDED HANGRSMNQ2561520

JEWELRY BOX   AJQ49823  0

RED APRON     AQ072  912