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

Merging the Transposed Data Set

Structuring the Data for a Merge

Remember that the transposed data set, Work.Ctarget2, needs to be merged with Sasuser.Monthsum by the values of Year and Month. Neither data set is currently structured correctly for the merge.
Table 16.17 SAS Data Set: Work.Ctarget2 (first five observations)
Obs
Month
Ctarget1
Ctarget2
Ctarget3
1
Year
1997
1998
1999
2
Jan
192284420
108645734
85730444
3
Feb
86376721
147656369
74168740
4
Mar
28526103
202158055
39955768
5
Apr
260386468
41160707
31265481
Table 16.18 SAS Data Set Sasuer.Monthsum (first five observations of selected variables)
Obs
SaleMon
RevCargo
MonthNo
1
JAN1997
$171,520,869.10 ...

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