Obs
|
SaleMon
|
RevCargo
|
MonthNo
|
---|---|---|---|
1
|
JAN1997
|
$171,520,869.10
|
1
|
2
|
JAN1998
|
$238,786,807.60
|
1
|
3
|
JAN1999
|
$280,350,393.00
|
1
|
4
|
FEB1997
|
$177,671,530.40
|
2
|
5
|
FEB1998
|
$215,959,695.50
|
2
|
Obs
|
Year
|
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
---|---|---|---|---|---|---|---|
1
|
1997
|
192284420 |
86376721 |
28526103 |
260386468 |
109975326 |
102833104 |
2
|
1998
|
108645734 |
147656369 |
202158055 |
41160707 |
264294440 |
267135485 |
3
|
1999
|
85730444 |
74168740 |
39955768 |
312654811 |
318149340 |
187270927 |
Obs
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|---|
1
|
196728648 |
236996122 |
112413744 |
125401565 |
72551855 |
136042505 |
2
|
208694865 |
83456868 |
286846554 |
275721406 |
230488351 |
24901752 |
3
|
123394421 |
34273985 |
151565752 |
141528519 |
178043261 |
181668256 |
Obs
|
SaleMon
|
RevCargo
|
Ctarget
|
---|---|---|---|
1
|
JAN1997
|
$171,520,869.10
|
$192,284,420.00
|
2
|
JAN1998
|
$238,786,807.60
|
$108,645,734.00
|
3
|
JAN1999
|
$280,350,393.00
|
$85,730,444.00
|
4
|
FEB1997
|
$177,671,530.40
|
$86,376,721.00
|
5
|
FEB1998
|
$215,959,695.50
|
$147,656,369.00
|
data work.lookup1;
array Targets{1997:1999,12} _temporary_;
if _n_=1 then do i= 1 to 3;
set sasuser.ctargets;
array mnth{*} Jan--Dec;
do j=1 to dim(mnth);
targets{year,j}=mnth{j};
end;
end;
set sasuser.monthsum(keep=salemon revcargo monthno);
year=input(substr(salemon,4),4.);
Ctarget=targets{year,monthno};
format ctarget dollar15.2;
run;
array Targets{3,12} _temporary_;
Year
|
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
---|---|---|---|---|---|---|
1997
|
192284420 |
86376721 |
28526103 |
260386468 |
109975326 |
102833104 |
1998
|
108645734 |
147656369 |
202158055 |
41160707 |
264294440 |
267135485 |
1999
|
85730444 |
74168740 |
39955768 |
312654811 |
318149340 |
187270927 |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
---|---|---|---|---|---|---|
196728648 |
236996122 |
112413744 |
125401565 |
72551855 |
136042505 |
|
208694865 |
83456868 |
286846554 |
275721406 |
230488351 |
24901752 |
|
123394421 |
34273985 |
151565752 |
141528519 |
178043261 |
181668256 |
data work.lookup1; array Targets{1997:1999,12} _temporary_; if _n_=1 then do i= 1 to 3; set sasuser.ctargets; array Mnth{*} Jan--Dec; do j=1 to dim(mnth); targets{year,j}=mnth{j}; end; end; set sasuser.monthsum(keep=salemon revcargo monthno); year=input(substr(salemon,4),4.); Ctarget=targets{year,monthno}; format ctarget dollar15.2; run;
Jan
|
Feb
|
Mar...
|
...Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|
192284420 |
86376721 |
260386468 |
125401565 |
72551855 |
136042505 |
data work.lookup1; array Targets{1997:1999,12} _temporary_; if _n_=1 then do i= 1 to 3; set sasuser.ctargets; array Mnth{*} Jan--Dec; do j=1 to dim(mnth); targets{year,j}=mnth{j}; end; end; set sasuser.monthsum(keep=salemon revcargo monthno); year=input(substr(salemon,4),4.); Ctarget=targets{year,monthno}; format ctarget dollar15.2; run;
Jan
|
Feb
|
Mar...
|
...Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|
108645734 |
147656369 |
202158055 |
275721406 |
230488351 |
24901752 |
Jan
|
Feb
|
Mar...
|
...Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|
85730444 |
74168740 |
39955768 |
141528519 |
178043261 |
181668256 |
1
|
2
|
3...
|
...10
|
11
|
12
|
|
---|---|---|---|---|---|---|
1997
|
192284420 |
86376721 |
260386468 |
125401565 |
72551855 |
136042505 |
1998
|
108645734 |
147656369 |
202158055 |
275721406 |
230488351 |
24901752 |
1999
|
85730444 |
74168740 |
39955768 |
141528519 |
178043261 |
181668256 |
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
|
data work.lookup1; array Targets{1997:1999,12} _temporary_; if _n_=1 then do i= 1 to 3; set sasuser.ctargets; array Mnth{*} Jan--Dec; do j=1 to dim(mnth); targets{year,j}=mnth{j}; end; end; set sasuser.monthsum(keep=salemon revcargo monthno); year=input(substr(salemon,4),4.); Ctarget=targets{year,monthno}; format ctarget dollar15.2; run;
1
|
2
|
3...
|
...10
|
11
|
12
|
|
---|---|---|---|---|---|---|
1997
|
192284420 |
86376721 |
260386468 |
125401565 |
72551855 |
136042505 |
1998
|
108645734 |
147656369 |
202158055 |
275721406 |
230488351 |
24901752 |
1999
|
85730444 |
74168740 |
39955768 |
141528519 |
178043261 |
181668256 |