O'Reilly logo

SAS Certification Prep Guide, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using PROC TRANSPOSE

Overview

In the previous section, we compared actual revenue values to target revenue values using an array as a lookup table. Remember the following:
  • Sasuser.Monthsum has an observation for each month and year.
    Table 16.12 SAS Data Set Sasuser.Monthsum (first five observations of selected variables)
    SaleMon
    RevCargo
    MonthNo
    JAN1997
    $171,520,869.10
    1
    JAN1998
    $238,786,807.60
    1
    JAN1999
    $280,350,393.00
    1
    FEB1997
    $177,671,530.40
    2
    FEB1998
    $215,959,695.50
    2
  • Sasuser.Ctargets has one variable for each month and one observation for each year.
    Table 16.13 SAS Data Set Sasuser.Ctargets (selected variables)
    Year
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    1997
    192284420 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required