SAS Certification Prep Guide, 4th Edition

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 ...