Execution Phase (3)

Understanding DATA Step Processing

Execution Phase

Next, the INFILE statement identifies the location of the raw data.

     data perm.update;
        infile invent;
        input Item $ 1-13 IDnum $ 15-19
              Instock 21-22 BackOrd 24-25;
        Total=instock+backord;
     run;

Raw Data File Invent

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

Bird Feeder   LG088  3 20

6 Glass Mugs  SB082  6 12

Glass Tray    BQ049 12  6

Padded Hangrs MN256 15 20

Jewelry Box   AJ498 23  0

Red Apron     AQ072  9 12

Crystal Vase  AQ672 27  0

Picnic Basket LS930 21  0

Brass Clock   AN910  2 10

1---+----10---+----20---+-
Bird Feeder LG088 3 20
6 Glass Mugs SB082 6 12
Glass Tray BQ049 12 6
Padded Hangrs MN256 15 20
Jewelry Box AJ498 23 0
Red Apron AQ072 9 12
Crystal Vase AQ672 27 0
Picnic Basket LS930 21 0
Brass Clock AN910 2 10

INFILE Statement Executes