Sample 25297: CALENDAR Procedure, Chapter 7
 |  |  |  |  |
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
/****************************************************************/
/* S A S S A M P L E L I B R A R Y */
/* */
/* NAME: BPG07R01 */
/* TITLE: CALENDAR Procedure, Chapter 7 */
/* PRODUCT: SAS */
/* SYSTEM: ALL */
/* KEYS: EXAMPLES FROM DOCUMENTATION, SCHEDULE */
/* PROCS: CALENDAR FORMAT SORT */
/* DATA: */
/* */
/* SUPPORT: UPDATE: */
/* REF: SAS Procedures Guide, CHAPTER 7 */
/* MISC: */
/* */
/****************************************************************/
/* Summary Calendar */
title 'Meals Served in Community Hospital Cafeteria';
options pagesize=60 linesize=132 nodate;
data act;
input date date7. brkfst lunch dinner;
cards;
01Dec91 123 234 123
02Dec91 123 234 238
03Dec91 188 188 198
04Dec91 123 183 176
05Dec91 200 267 243
06Dec91 176 165 177
07Dec91 156 . 167
08Dec91 198 143 167
09Dec91 178 198 187
10Dec91 165 176 187
11Dec91 187 176 231
12Dec91 176 187 222
13Dec91 187 187 123
14Dec91 164 187 231
15Dec91 187 165 167
16Dec91 187 198 156
17Dec91 198 187 156
18Dec91 187 165 178
19Dec91 187 176 156
20Dec91 156 211 199
21Dec91 176 156 143
22Dec91 165 167 211
23Dec91 187 176 .
24Dec91 185 167 167
25Dec91 187 178 187
26Dec91 167 156 198
27Dec91 167 239 267
28Dec91 267 287 256
29Dec91 276 243 234
30Dec91 267 287 256
31Dec91 243 231 243
;
proc calendar;
start date;
sum brkfst lunch dinner;
mean brkfst lunch dinner;
run;
/* Schedule Calendar */
title 'Summer Planning Calendar: '
'Julia Q. Wydget, President';
title2 'Better Products Inc.';
data act;
input date : date7. happen $ 9-36 who $ 38-48 long;
cards;
01JUL91 Dist. Mtg. All 1
02JUL91 Mgrs. Meeting District 6 2
03JUL91 Interview JW 1
05JUL91 VIP Banquet JW 1
08JUL91 Sales Drive District 6 5
08JUL91 Trade Show Knox 3
11JUL91 Mgrs. Meeting District 7 2
11JUL91 Planning Council Group II 1
12JUL91 Seminar White 1
14JUL91 Co. Picnic All 1
15JUL91 Sales Drive District 7 5
16JUL91 Dentist JW 1
17JUL91 Bank Meeting 1st Natl 1
18JUL91 NewsLetter Deadline All 1
18JUL91 Planning Council Group III 1
19JUL91 Seminar White 1
22JUL91 Inventors Show Melvin 3
24JUL91 Birthday Mary 1
25JUL91 Planning Council Group IV 1
25JUL91 Close Sale WYGIX Co. 2
;
proc calendar data=act;
start date;
dur long;
run;
/* Multiple Calendars */
options pagesize=60 linesize=132 nodate;
title 'Summer Planning Calendar: '
'Julia Q. Wydget, President';
title2 'Better Products Inc.';
title3 'Work and Home Schedule';
data act;
input date:date7. happen $ 10-34 who $ 35-47 _CAL_ $ long;
cards;
01JUL91 Dist. Mtg. All CAL1 1
02JUL91 Mgrs. Meeting District 6 CAL1 2
03JUL91 Interview JW CAL1 1
05JUL91 VIP Banquet JW CAL1 1
06JUL91 Beach trip family CAL2 2
08JUL91 Sales Drive District 6 CAL1 5
08JUL91 Trade Show Knox CAL1 3
09JUL91 Orthodontist Meagan CAL2 1
11JUL91 Mgrs. Meeting District 7 CAL1 2
11JUL91 Planning Council Group II CAL1 1
12JUL91 Seminar White CAL1 1
14JUL91 Co. Picnic All CAL1 1
14JUL91 Business trip Fred CAL2 2
15JUL91 Sales Drive District 7 CAL1 5
16JUL91 Dentist JW CAL1 1
17JUL91 Bank Meeting 1st Natl CAL1 1
17JUL91 Real estate agent Family CAL2 1
18JUL91 NewsLetter Deadline All CAL1 1
18JUL91 Planning Council Group III CAL1 1
19JUL91 Seminar White CAL1 1
22JUL91 Inventors Show Melvin CAL1 3
24JUL91 Birthday Mary CAL1 1
25JUL91 Planning Council Group IV CAL1 1
25JUL91 Close Sale WYGIX Co. CAL1 2
27JUL91 Ballgame Family CAL2 1
;
data vac;
input hdate:date7. holiday $ 11-25 _CAL_ $ ;
cards;
04JUL91 Independence CAL1
29JUL91 vacation CAL2
;
proc calendar data=act holidata=vac;
calid _CAL_ / output=combine;
start date ;
holistart hdate;
holivar holiday;
dur long;
run;
/* Scheduling Activities and Holidays */
data act;
input date:date7. happen $ 9-36 who $ 38-40 _CAL_ $ 50 -53 long;
cards;
03JUL86 project JW CAL1 3
07JUL86 finish JW CAL1 1
;
title 'The SAS System';
proc calendar data=act interval=workday;
sta date;
dur long;
run;
data act;
input date:date7. happen $ 9-36 who $ 38-40 _CAL_ $ long;
cards;
03JUL86 project JW CAL1 3
07JUL86 finish JW CAL1 1
;
data vac;
input date:date7. holiday $ 11-25 _CAL_ $;
cards;
04jul86 Independence CAL1
;
proc calendar data=act holidata=vac interval=workday;
calid _CAL_ / output=mixed;
sta date;
dur long;
holistart date;
holivar holiday;
run;
data act;
input date:date7. happen $ 9-36 who $ 38-40 _CAL_ $ long;
cards;
03JUL86 project JW CAL1 3
07JUL86 finish JW CAL1 1
;
data vac;
input date:date7. holiday $ 11-25 dur _CAL_ $;
cards;
04jul86 Independence 2 CAL1
;
proc calendar data=act holidata=vac interval=workday;
calid _CAL_ / output=mixed;
sta date;
dur long;
holistart date;
holivar holiday;
holidur dur;
run;
/* Example 1: Summary Calendar */
title 'Meals Served in Community Hospital Cafeteria';
data act;
input date date. brkfst lunch dinner;
cards;
01Dec91 123 234 123
02Dec91 123 234 238
03Dec91 188 188 198
04Dec91 123 183 176
05Dec91 200 267 243
06Dec91 176 165 177
07Dec91 156 . 167
08Dec91 198 143 167
09Dec91 178 198 187
10Dec91 165 176 187
11Dec91 187 176 231
12Dec91 176 187 222
13Dec91 187 187 123
14Dec91 164 187 231
15Dec91 187 165 167
16Dec91 187 198 156
17Dec91 198 187 156
18Dec91 187 165 178
19Dec91 187 176 156
20Dec91 156 211 199
21Dec91 176 156 143
22Dec91 165 167 211
23Dec91 187 176 .
24Dec91 185 167 167
25Dec91 187 178 187
26Dec91 167 156 198
27Dec91 167 239 267
28Dec91 267 287 256
29Dec91 276 243 234
30Dec91 267 287 256
31Dec91 243 231 243
;
data hol;
input date: date7. name & $12.;
cards;
25Dec91 Christmas
;
proc format;
picture bfmt other = '999 Brkfst';
picture lfmt other = '999 Lunch ';
picture dfmt other = '999 Dinner';
run;
proc calendar data=act holidata=hol;
start date;
holistart date;
holivar name;
format brkfst bfmt.;
format lunch lfmt.;
format dinner dfmt.;
sum brkfst lunch dinner / format=4.0;
mean brkfst lunch dinner / format=6.2;
label brkfst = 'Breakfasts Served'
lunch = ' Lunches Served'
dinner = ' Dinners Served';
run;
/* Example 2: Summary Calendar with MEAN Values by Observation */
title1 'System Performance Summary';
title2 'First National Bank Computer Center';
data bankact;
input date: date. jobs act cpu;
cards;
02May88 873 22.1 7.6
03May88 881 23.8 11.7
04May88 940 24.0 7.7
05May88 194 5.3 1.5
06May88 154 17.4 7.1
09May88 807 24 10.5
10May88 829 23.4 10.5
11May88 915 24 10.6
12May88 388 21 6.9
13May88 . . .
16May88 806 24.0 10.0
17May88 848 23.6 10.5
18May88 906 23 10.1
19May88 103 23.4 18.7
20May88 103 20.1 20
23May88 729 24 4.9
24May88 652 21.3 12.2
25May88 809 23.8 12.3
26May88 168 15.8 10.7
27May88 85 7 5.6
31May88 100 11.1 1.8
;
proc format;
picture jfmt . = '000 jobs' (noedit)
other = '000 jobs';
picture afmt . = '00.0 act' (noedit)
other = '00.0 act';
picture cfmt . = '00.0 cpu' (noedit)
other = '00.0 cpu';
run;
title3 'Mean Usage per Business Day';
proc calendar data=bankact;
start date;
format jobs jfmt.
act afmt.
cpu cfmt.;
sum jobs act cpu / format = 7.0;
mean jobs act cpu / format = 6.1;
label jobs = 'Jobs Run'
act = 'Active Hours'
cpu = 'Cpu Hours';
run;
/* Example 3: Summary Calendar with MEAN Values by Day */
proc format;
picture jfmt . = '000 jobs' (noedit)
other = '000 jobs';
picture afmt . = '00.0 act' (noedit)
other = '00.0 act';
picture cfmt . = '00.0 cpu' (noedit)
other = '00.0 cpu';
run;
title1 'System Performance Summary';
title2 'First National Bank Computer Center';
title3 'Mean Usage per Day';
proc calendar missing data=bankact meantype=ndays;
start date;
format jobs jfmt.
act afmt.
cpu cfmt.;
sum jobs act cpu / format = 7.0;
mean jobs act cpu / format = 6.1;
label jobs = 'Jobs Run Daily'
act = 'Active Hours' cpu = 'Cpu Hours';
run;
/* Example 4: Summary Calendar with Separated Output */
data wellact;
input task $ 1-16 dur 21-30 date datetime. _cal_ $ cost;
cards;
Drill Well 3.50 01JUL85:12:00:00 CAL1 1000
Lay Power Line 3.00 04JUL85:12:00:00 CAL1 2000
Assemble Tank 4.00 05JUL85:08:00:00 CAL1 1000
Build Pump House 3.00 08JUL85:12:00:00 CAL1 2000
Pour Foundation 4.00 11JUL85:08:00:00 CAL1 1500
Install Pump 4.00 15JUL85:14:00:00 CAL1 500
Install Pipe 2.00 19JUL85:08:00:00 CAL1 1000
Erect Tower 6.00 20JUL85:08:00:00 CAL1 2500
Deliver Material 2.00 01JUL85:12:00:00 CAL2 500
Excavate 4.75 03JUL85:08:00:00 CAL2 3500
;
data wellhol;
input date date. holiday $ 11-25 _cal_ $;
cards;
04JUL85 Independence CAL1
07JUL85 Vacation CAL2
;
data wellcal;
input _sun_ $ _sat_ $ _cal_ $;
cards;
Holiday Holiday CAL1
Holiday Halfday CAL2
;
data wellwor;
input halfday time8.;
cards;
08:00
12:00
;
title 'Well Drilling Cost Summary: Output=Separate';
proc sort data=wellact;
by _cal_ date;
run;
proc calendar data=wellact
holidata=wellhol caledata=wellcal workdata=wellwor
datetime legend;
calid _cal_ / output=separate;
start date;
format cost dollar9.2;
sum cost / format=dollar9.2;
holistart date;
holivar holiday;
outstart Monday;
outfin Saturday;
run;
/* Example 5: Summary Calendars with Combined Output */
title 'Well Drilling Cost Summary: Output=Combine';
proc sort data=wellact;
by date;
run;
proc calendar data=wellact
holidata=wellhol caledata=wellcal workdata=wellwor
datetime legend;
calid _cal_ / output=combine;
start date;
format cost dollar9.2;
sum cost / format=dollar9.2;
holistart date;
holivar holiday;
outstart Monday;
outfin Saturday;
run;
/* Example 6: Summary Calendars with Mixed Output */
options pagesize=66 linesize=132 nodate ;
title 'Well Drilling Cost Summary: Output=Mix';
proc sort data=wellact;
by date;
run;
proc calendar data=wellact
holidata=wellhol caledata=wellcal workdata=wellwor
datetime legend;
calid _cal_ / output=mix;
start date;
format cost dollar9.2;
sum cost / format=dollar9.2;
holistart date;
holivar holiday;
outstart Monday;
outfin Saturday;
run;
/* Example 7: Schedule Calendar */
title 'Summer Planning Calendar: Julia Q. Wydget, President';
title2 'Better Products Inc.';
options pagesize=60 linesize=132 nodate;
data act;
input date:date7. happen $ 9-36 who $ 37-48 long;
cards;
01JUL91 Dist. Mtg. All 1
02JUL91 Mgrs. Meeting District 6 2
03JUL91 Interview JW 1
05JUL91 VIP Banquet JW 1
08JUL91 Sales Drive District 6 5
08JUL91 Trade Show Knox 3
11JUL91 Mgrs. Meeting District 7 2
11JUL91 Planning Council Group II 1
12JUL91 Seminar White 1
15JUL91 Sales Drive District 7 5
16JUL91 Dentist JW 1
17JUL91 Bank Meeting 1st Natl 1
18JUL91 NewsLetter Deadline All 1
18JUL91 Planning Council Group III 1
19JUL91 Seminar White 1
19JUL91 Co. Picnic All 1
22JUL91 Inventors Show Melvin 3
24JUL91 Birthday Mary 1
25JUL91 Planning Council Group IV 1
25JUL91 Close Sale WYGIX Co. 2
;
data hol;
input date: date7. dur name & $15.;
cards;
04JUL91 1 Independence
29JUL91 3 Vacation
;
proc calendar data=act holidata=hol;
start date;
dur long;
holistart date;
holivar name;
holidur dur;
outstart Monday;
outfin Friday;
run;
/* Example 8: Schedule Calendar with Separated Output */
title 'Well Drilling Work Schedule: Output=Separate';
proc sort data=wellact;
by _cal_ date;
run;
proc calendar data=wellact
holidata=wellhol
caledata=wellcal workdata=wellwor datetime;
calid _cal_ / output=separate;
start date;
dur dur;
format cost dollar9.2;
holistart date;
holivar holiday;
outstart Monday;
outfin Saturday;
run;
/* Example 9: Schedule Calendar with Combined Output */
options pagesize=66 linesize=132 nodate ;
title 'Well Drilling Work Schedule: Output=Combine';
proc sort data=wellact;
by date;
run;
proc calendar data=wellact
holidata=wellhol caledata=wellcal workdata=wellwor datetime;
calid _cal_ / output=combine;
start date;
dur dur;
format cost dollar9.2;
holistart date;
holivar holiday;
outstart Monday;
outfin Saturday;
run;
/* Example 10: Schedule Calendar with Mixed Output */
title 'Well Drilling Work Schedule: Output=Mix';
proc sort data=wellact;
by date;
run;
proc calendar data=wellact
holidata=wellhol caledata=wellcal workdata=wellwor datetime;
calid _cal_ / output=mix;
start date;
dur dur;
format cost dollar9.2;
holistart date;
holivar holiday;
outstart Monday;
outfin Saturday;
run;
/* Example 11: Schedule Calendar with Holidays Only */
data acts;
input sta:date7. act $ 11-30 dur;
cards;
01JAN88 Start 0
31DEC88 Finish 0
;
data holidays;
input sta:date7. act $ 11-30 dur;
cards;
01JAN88 New Year's 1
01APR88 Good Friday 1
30MAY88 Memorial Day 1
04JUL88 Independence Day 1
05SEP88 Labor Day 1
24NOV88 Thanksgiving 2
26DEC88 Christmas 3
;
options pagesize=30 linesize=132;
proc calendar data=acts holidata=holidays fill;
start sta;
dur dur;
holistart sta;
holidur dur;
holivar act;
run;
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
Summary Calendar
Meals Served in Community Hospital Cafeteria
----------------------------------------------------------------------------------------------------------
| |
| December 1991 |
| |
|--------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|--------------+--------------+--------------+--------------+--------------+--------------+--------------|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| | | | | | | |
| 123 | 123 | 188 | 123 | 200 | 176 | 156 |
| 234 | 234 | 188 | 183 | 267 | 165 | . |
| 123 | 238 | 198 | 176 | 243 | 177 | 167 |
|--------------+--------------+--------------+--------------+--------------+--------------+--------------|
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| | | | | | | |
| 198 | 178 | 165 | 187 | 176 | 187 | 164 |
| 143 | 198 | 176 | 176 | 187 | 187 | 187 |
| 167 | 187 | 187 | 231 | 222 | 123 | 231 |
|--------------+--------------+--------------+--------------+--------------+--------------+--------------|
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| | | | | | | |
| 187 | 187 | 198 | 187 | 187 | 156 | 176 |
| 165 | 198 | 187 | 165 | 176 | 211 | 156 |
| 167 | 156 | 156 | 178 | 156 | 199 | 143 |
|--------------+--------------+--------------+--------------+--------------+--------------+--------------|
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| | | | | | | |
| 165 | 187 | 185 | 187 | 167 | 167 | 267 |
| 167 | 176 | 167 | 178 | 156 | 239 | 287 |
| 211 | . | 167 | 187 | 198 | 267 | 256 |
|--------------+--------------+--------------+--------------+--------------+--------------+--------------|
| 29 | 30 | 31 | | | | |
| | | | | | | |
| 276 | 267 | 243 | | | | |
| 243 | 287 | 231 | | | | |
| 234 | 256 | 243 | | | | |
----------------------------------------------------------------------------------------------------------
--------------------------------------------
| | Sum | Mean |
| | | |
| BRKFST | 5733 | 184.935 |
| LUNCH | 5914 | 197.133 |
| DINNER | 5844 | 194.800 |
--------------------------------------------
Schedule Calendar
Summer Planning Calendar: Julia Q. Wydget, President
Better Products Inc.
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1991 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| | 1 | 2 | 3 | 4 | 5 | 6 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | |+=Interview/JW==+| | | |
| |+Dist. Mtg./All=+|+====Mgrs. Meeting/District 6=====+| |+VIP Banquet/JW=+| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | |+Planning Counci+|+=Seminar/White=+| |
| |+==================Trade Show/Knox==================+|+====Mgrs. Meeting/District 7=====+| |
| |+================================Sales Drive/District 6=================================+| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | |+Planning Counci+| | |
| | |+==Dentist/JW===+|+Bank Meeting/1s+|+NewsLetter Dead+|+=Seminar/White=+| |
|+Co. Picnic/All=+|+================================Sales Drive/District 7=================================+| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | |+=Birthday/Mary=+|+======Close Sale/WYGIX Co.=======+| |
| |+===============Inventors Show/Melvin===============+|+Planning Counci+| | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 28 | 29 | 30 | 31 | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
-------------------------------------------------------------------------------------------------------------------------------
Multiple Calendars
Summer Planning Calendar: Julia Q. Wydget, President
Better Products Inc.
Work and Home Schedule
------------------------------------------------------------------------------------------------------------------------
| |
| July 1991 |
| |
|----------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
----------+----------------+----------------+----------------+----------------+----------------+----------------+----------------|
| | | 1 | 2 | 3 | 4 | 5 | 6 |
|.........|................|................|................|................|................|................|................|
| CAL1 | | | |+=Interview/JW=+|**Independence**| | |
| | |+Dist. Mtg./All+|+===Mgrs. Meeting/District 6====+| |+VIP Banquet/JW+| |
|.........|................|................|................|................|................|................|................|
| CAL2 | | | | | | |+Beach trip/fam>|
| | | | | | | | |
|---------+----------------+----------------+----------------+----------------+----------------+----------------+----------------|
| | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
|.........|................|................|................|................|................|................|................|
| CAL1 | | | | |+Planning Counc+|+Seminar/White=+| |
| | |+================Trade Show/Knox=================+|+===Mgrs. Meeting/District 7====+| |
| | |+==============================Sales Drive/District 6==============================+| |
|.........|................|................|................|................|................|................|................|
| CAL2 |<Beach trip/fam+| |+Orthodontist/M+| | | | |
|---------+----------------+----------------+----------------+----------------+----------------+----------------+----------------|
| | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|.........|................|................|................|................|................|................|................|
| CAL1 | | | | |+Planning Counc+| | |
| | | |+==Dentist/JW==+|+Bank Meeting/1+|+NewsLetter Dea+|+Seminar/White=+| |
| |+Co. Picnic/All+|+==============================Sales Drive/District 7==============================+| |
|.........|................|................|................|................|................|................|................|
| CAL2 |+======Business trip/Fred=======+| |+Real estate ag+| | | |
|---------+----------------+----------------+----------------+----------------+----------------+----------------+----------------|
| | 21 | 22 | 23 | 24 | 25 | 26 | 27 |
|.........|................|................|................|................|................|................|................|
| CAL1 | | | |+Birthday/Mary=+|+=====Close Sale/WYGIX Co.======+| |
| | |+=============Inventors Show/Melvin==============+|+Planning Counc+| | |
|.........|................|................|................|................|................|................|................|
| CAL2 | | | | | | |+Ballgame/Famil+|
| | | | | | | | |
|---------+----------------+----------------+----------------+----------------+----------------+----------------+----------------|
| | 28 | 29 | 30 | 31 | | | |
|.........|................|................|................|................|................|................|................|
| CAL2 | |****vacation****| | | | | |
| | | | | | | | |
| | | | | | | | |
| | | | | | | | |
| | | | | | | | |
----------------------------------------------------------------------------------------------------------------------------------
Scheduling Activities and Holidays
The SAS System
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1986 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| | | 1 | 2 | 3 | 4 | 5 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | |+=========project/JW/CAL1=========>| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| |+finish/JW/CAL1=+| | | | | |
| |<project/JW/CAL1+| | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 27 | 28 | 29 | 30 | 31 | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
-------------------------------------------------------------------------------------------------------------------------------
The SAS System
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1986 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| | | 1 | 2 | 3 | 4 | 5 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | |+==project/JW===>|**Independence***| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| |+===finish/JW===+| | | | | |
| |<===========project/JW============+| | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 27 | 28 | 29 | 30 | 31 | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
-------------------------------------------------------------------------------------------------------------------------------
The SAS System
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1986 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| | | 1 | 2 | 3 | 4 | 5 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | |+==project/JW===>|**Independence***| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| |**Independence***|+===finish/JW===+| | | | |
| |**Independence***|<===========project/JW============+| | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 27 | 28 | 29 | 30 | 31 | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
-------------------------------------------------------------------------------------------------------------------------------
Example 1: Summary Calendar
Meals Served in Community Hospital Cafeteria
--------------------------------------------------------------------------------------------
| |
| December 1991 |
| |
|------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|------------+------------+------------+------------+------------+------------+------------|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| | | | | | | |
| 123 Brkfst | 123 Brkfst | 188 Brkfst | 123 Brkfst | 200 Brkfst | 176 Brkfst | 156 Brkfst |
| 234 Lunch | 234 Lunch | 188 Lunch | 183 Lunch | 267 Lunch | 165 Lunch | . |
| 123 Dinner | 238 Dinner | 198 Dinner | 176 Dinner | 243 Dinner | 177 Dinner | 167 Dinner |
|------------+------------+------------+------------+------------+------------+------------|
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| | | | | | | |
| 198 Brkfst | 178 Brkfst | 165 Brkfst | 187 Brkfst | 176 Brkfst | 187 Brkfst | 164 Brkfst |
| 143 Lunch | 198 Lunch | 176 Lunch | 176 Lunch | 187 Lunch | 187 Lunch | 187 Lunch |
| 167 Dinner | 187 Dinner | 187 Dinner | 231 Dinner | 222 Dinner | 123 Dinner | 231 Dinner |
|------------+------------+------------+------------+------------+------------+------------|
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| | | | | | | |
| 187 Brkfst | 187 Brkfst | 198 Brkfst | 187 Brkfst | 187 Brkfst | 156 Brkfst | 176 Brkfst |
| 165 Lunch | 198 Lunch | 187 Lunch | 165 Lunch | 176 Lunch | 211 Lunch | 156 Lunch |
| 167 Dinner | 156 Dinner | 156 Dinner | 178 Dinner | 156 Dinner | 199 Dinner | 143 Dinner |
|------------+------------+------------+------------+------------+------------+------------|
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| | | |*Christmas**| | | |
| 165 Brkfst | 187 Brkfst | 185 Brkfst | 187 Brkfst | 167 Brkfst | 167 Brkfst | 267 Brkfst |
| 167 Lunch | 176 Lunch | 167 Lunch | 178 Lunch | 156 Lunch | 239 Lunch | 287 Lunch |
| 211 Dinner | . | 167 Dinner | 187 Dinner | 198 Dinner | 267 Dinner | 256 Dinner |
|------------+------------+------------+------------+------------+------------+------------|
| 29 | 30 | 31 | | | | |
| | | | | | | |
| 276 Brkfst | 267 Brkfst | 243 Brkfst | | | | |
| 243 Lunch | 287 Lunch | 231 Lunch | | | | |
| 234 Dinner | 256 Dinner | 243 Dinner | | | | |
--------------------------------------------------------------------------------------------
-------------------------------------
| | Sum | Mean |
| | | |
| Breakfasts Served | 5733 | 184.94 |
| Lunches Served | 5914 | 197.13 |
| Dinners Served | 5844 | 194.80 |
-------------------------------------
Example 2: Summary Calendar with MEAN Values by Observation
System Performance Summary
First National Bank Computer Center
Mean Usage per Business Day
------------------------------------------------------------------------------
| |
| May 1988 |
| |
|----------------------------------------------------------------------------|
| Sunday | Monday | Tuesday |Wednesday | Thursday | Friday | Saturday |
|----------+----------+----------+----------+----------+----------+----------|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| | | | | | | |
| | 873 jobs | 881 jobs | 940 jobs | 194 jobs | 154 jobs | |
| | 22.1 act | 23.8 act | 24.0 act | 5.3 act | 17.4 act | |
| | 7.6 cpu | 11.7 cpu | 7.7 cpu | 1.5 cpu | 7.1 cpu | |
|----------+----------+----------+----------+----------+----------+----------|
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| | | | | | | |
| | 807 jobs | 829 jobs | 915 jobs | 388 jobs | 000 jobs | |
| | 24.0 act | 23.4 act | 24.0 act | 21.0 act | 00.0 act | |
| | 10.5 cpu | 10.5 cpu | 10.6 cpu | 6.9 cpu | 00.0 cpu | |
|----------+----------+----------+----------+----------+----------+----------|
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| | | | | | | |
| | 806 jobs | 848 jobs | 906 jobs | 103 jobs | 103 jobs | |
| | 24.0 act | 23.6 act | 23.0 act | 23.4 act | 20.1 act | |
| | 10.0 cpu | 10.5 cpu | 10.1 cpu | 18.7 cpu | 20.0 cpu | |
|----------+----------+----------+----------+----------+----------+----------|
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| | | | | | | |
| | 729 jobs | 652 jobs | 809 jobs | 168 jobs | 85 jobs | |
| | 24.0 act | 21.3 act | 23.8 act | 15.8 act | 7.0 act | |
| | 4.9 cpu | 12.2 cpu | 12.3 cpu | 10.7 cpu | 5.6 cpu | |
|----------+----------+----------+----------+----------+----------+----------|
| 29 | 30 | 31 | | | | |
| | | | | | | |
| | | 100 jobs | | | | |
| | | 11.1 act | | | | |
| | | 1.8 cpu | | | | |
------------------------------------------------------------------------------
-----------------------------------
| | Sum | Mean |
| | | |
| Jobs Run | 11290 | 564.5 |
| Active Hours | 402 | 20.1 |
| Cpu Hours | 191 | 9.5 |
-----------------------------------
Example 3: Summary Calendar with MEAN Values by Day
System Performance Summary
First National Bank Computer Center
Mean Usage per Day
------------------------------------------------------------------------------
| |
| May 1988 |
| |
|----------------------------------------------------------------------------|
| Sunday | Monday | Tuesday |Wednesday | Thursday | Friday | Saturday |
|----------+----------+----------+----------+----------+----------+----------|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| | | | | | | |
| 000 jobs | 873 jobs | 881 jobs | 940 jobs | 194 jobs | 154 jobs | 000 jobs |
| 00.0 act | 22.1 act | 23.8 act | 24.0 act | 5.3 act | 17.4 act | 00.0 act |
| 00.0 cpu | 7.6 cpu | 11.7 cpu | 7.7 cpu | 1.5 cpu | 7.1 cpu | 00.0 cpu |
|----------+----------+----------+----------+----------+----------+----------|
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| | | | | | | |
| 000 jobs | 807 jobs | 829 jobs | 915 jobs | 388 jobs | 000 jobs | 000 jobs |
| 00.0 act | 24.0 act | 23.4 act | 24.0 act | 21.0 act | 00.0 act | 00.0 act |
| 00.0 cpu | 10.5 cpu | 10.5 cpu | 10.6 cpu | 6.9 cpu | 00.0 cpu | 00.0 cpu |
|----------+----------+----------+----------+----------+----------+----------|
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| | | | | | | |
| 000 jobs | 806 jobs | 848 jobs | 906 jobs | 103 jobs | 103 jobs | 000 jobs |
| 00.0 act | 24.0 act | 23.6 act | 23.0 act | 23.4 act | 20.1 act | 00.0 act |
| 00.0 cpu | 10.0 cpu | 10.5 cpu | 10.1 cpu | 18.7 cpu | 20.0 cpu | 00.0 cpu |
|----------+----------+----------+----------+----------+----------+----------|
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| | | | | | | |
| 000 jobs | 729 jobs | 652 jobs | 809 jobs | 168 jobs | 85 jobs | 000 jobs |
| 00.0 act | 24.0 act | 21.3 act | 23.8 act | 15.8 act | 7.0 act | 00.0 act |
| 00.0 cpu | 4.9 cpu | 12.2 cpu | 12.3 cpu | 10.7 cpu | 5.6 cpu | 00.0 cpu |
|----------+----------+----------+----------+----------+----------+----------|
| 29 | 30 | 31 | | | | |
| | | | | | | |
| 000 jobs | 000 jobs | 100 jobs | | | | |
| 00.0 act | 00.0 act | 11.1 act | | | | |
| 00.0 cpu | 00.0 cpu | 1.8 cpu | | | | |
------------------------------------------------------------------------------
-------------------------------------
| | Sum | Mean |
| | | |
| Jobs Run Daily | 11290 | 364.2 |
| Active Hours | 402 | 13.0 |
| Cpu Hours | 191 | 6.2 |
-------------------------------------
Example 4: Summary Calendar with Separated Output
Well Drilling Cost Summary: Output=Separate
_CAL_=CAL1 ........................................................................................................................
-------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 1 | 2 | 3 | 4 | 5 | 6 |
| | | |***Independence***| | |
| Drill Well | | | Lay Power Line | Assemble Tank | |
| 3.5 | | | 3 | 4 | |
| $1,000.00 | | | $2,000.00 | $1,000.00 | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 8 | 9 | 10 | 11 | 12 | 13 |
| | | | | | |
| Build Pump House | | | Pour Foundation | | |
| 3 | | | 4 | | |
| $2,000.00 | | | $1,500.00 | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | |
| Install Pump | | | | Install Pipe | Erect Tower |
| 4 | | | | 2 | 6 |
| $500.00 | | | | $1,000.00 | $2,500.00 |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 29 | 30 | 31 | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
-------------------------------------------------------------------------------------------------------------------
------------------------
| Legend | Sum |
| | |
| TASK | |
| DUR | |
| COST | $11500.00 |
------------------------
Well Drilling Cost Summary: Output=Separate
_CAL_=CAL2 ........................................................................................................................
-------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 1 | 2 | 3 | 4 | 5 | 6 |
| | | | | | |
| Deliver Material | | Excavate | | | |
| 2 | | 4.75 | | | |
| $500.00 | | $3,500.00 | | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 8 | 9 | 10 | 11 | 12 | 13 |
|*****Vacation*****| | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 29 | 30 | 31 | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
-------------------------------------------------------------------------------------------------------------------
------------------------
| Legend | Sum |
| | |
| TASK | |
| DUR | |
| COST | $4,000.00 |
------------------------
Example 5: Summary Calendars with Combined Output
Well Drilling Cost Summary: Output=Combine
-------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
----------+------------------+------------------+------------------+------------------+------------------+------------------|
| | 1 | 2 | 3 | 4 | 5 | 6 |
|.........|..................|..................|..................|..................|..................|..................|
| CAL1 | Drill Well | | | Lay Power Line | Assemble Tank | |
| | 3.5 | | | 3 | 4 | |
| | $1,000.00 | | | $2,000.00 | $1,000.00 | |
|.........|..................|..................|..................|..................|..................|..................|
| CAL2 | Deliver Material | | Excavate | | | |
|---------+------------------+------------------+------------------+------------------+------------------+------------------|
| | 8 | 9 | 10 | 11 | 12 | 13 |
|.........|..................|..................|..................|..................|..................|..................|
| CAL1 | Build Pump House | | | Pour Foundation | | |
| | 3 | | | 4 | | |
| | $2,000.00 | | | $1,500.00 | | |
| | | | | | | |
| | | | | | | |
|---------+------------------+------------------+------------------+------------------+------------------+------------------|
| | 15 | 16 | 17 | 18 | 19 | 20 |
|.........|..................|..................|..................|..................|..................|..................|
| CAL1 | Install Pump | | | | Install Pipe | Erect Tower |
| | 4 | | | | 2 | 6 |
| | $500.00 | | | | $1,000.00 | $2,500.00 |
| | | | | | | |
| | | | | | | |
|---------+------------------+------------------+------------------+------------------+------------------+------------------|
| | 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|---------+------------------+------------------+------------------+------------------+------------------+------------------|
| | 29 | 30 | 31 | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
-----------------------------------------------------------------------------------------------------------------------------
Well Drilling Cost Summary: Output=Combine
----------------------------------
| | Legend | Sum |
|.........|..........|...........|
| DEFAULT | TASK | |
| | DUR | |
| | COST | $0.00 |
|.........|..........|...........|
| CAL1 | TASK | |
| | DUR | |
| | COST | $11500.00 |
|.........|..........|...........|
| CAL2 | TASK | |
| | DUR | |
| | COST | $4,000.00 |
|=========|==========|===========|
| | TASK | |
| | DUR | |
| | COST | $15500.00 |
----------------------------------
Example 6: Summary Calendars with Mixed Output
Well Drilling Cost Summary: Output=Mix
-------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 1 | 2 | 3 | 4 | 5 | 6 |
| | | |***Independence***| | |
| Deliver Material | | Excavate | Lay Power Line | Assemble Tank | |
| 2 | | 4.75 | 3 | 4 | |
| $500.00 | | $3,500.00 | $2,000.00 | $1,000.00 | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 8 | 9 | 10 | 11 | 12 | 13 |
| | | | | | |
| Build Pump House | | | Pour Foundation | | |
| 3 | | | 4 | | |
| $2,000.00 | | | $1,500.00 | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | |
| Install Pump | | | | Install Pipe | Erect Tower |
| 4 | | | | 2 | 6 |
| $500.00 | | | | $1,000.00 | $2,500.00 |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|------------------+------------------+------------------+------------------+------------------+------------------|
| 29 | 30 | 31 | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
-------------------------------------------------------------------------------------------------------------------
------------------------
| Legend | Sum |
| | |
| TASK | |
| DUR | |
| COST | $14500.00 |
------------------------
Example 7: Schedule Calendar
Summer Planning Calendar: Julia Q. Wydget, President
Better Products Inc.
-----------------------------------------------------------------------------------------------------------------------------------
| |
| July 1991 |
| |
|---------------------------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday |
|-------------------------+-------------------------+-------------------------+-------------------------+-------------------------|
| 1 | 2 | 3 | 4 | 5 |
| | | |******Independence*******| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | |+=====Interview/JW======+| | |
|+====Dist. Mtg./All=====+|+============Mgrs. Meeting/District 6=============+| |+====VIP Banquet/JW=====+|
|-------------------------+-------------------------+-------------------------+-------------------------+-------------------------|
| 8 | 9 | 10 | 11 | 12 |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |+Planning Council/Group +|+=====Seminar/White=====+|
|+==============================Trade Show/Knox==============================+|+============Mgrs. Meeting/District 7=============+|
|+====================================================Sales Drive/District 6=====================================================+|
|-------------------------+-------------------------+-------------------------+-------------------------+-------------------------|
| 15 | 16 | 17 | 18 | 19 |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |+Planning Council/Group +|+====Co. Picnic/All=====+|
| |+======Dentist/JW=======+|+=Bank Meeting/1st Natl=+|+NewsLetter Deadline/All+|+=====Seminar/White=====+|
|+====================================================Sales Drive/District 7=====================================================+|
|-------------------------+-------------------------+-------------------------+-------------------------+-------------------------|
| 22 | 23 | 24 | 25 | 26 |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | |+=====Birthday/Mary=====+|+==============Close Sale/WYGIX Co.===============+|
|+===========================Inventors Show/Melvin===========================+|+Planning Council/Group +| |
|-------------------------+-------------------------+-------------------------+-------------------------+-------------------------|
| 29 | 30 | 31 | | |
|********Vacation*********|********Vacation*********|********Vacation*********| | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
-----------------------------------------------------------------------------------------------------------------------------------
Example 8: Schedule Calendar with Separated Output
Well Drilling Work Schedule: Output=Separate
_CAL_=CAL1 ........................................................................................................................
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 1 | 2 | 3 | 4 | 5 | 6 |
| | | |****Independence****| | |
| | | | | | |
| | | | | | |
| | | | |+Assemble Tank/$1,0>| |
| | | | |+Lay Power Line/$2,>| |
|+====================Drill Well/$1,000.00====================>| |<Drill Well/$1,000.+| |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 8 | 9 | 10 | 11 | 12 | 13 |
| | | | | | |
| | | | | | |
| | | | | | |
|+===========================Build Pump House/$2,000.00============================+| | |
|<=============================Assemble Tank/$1,000.00=============================+| | |
|<=======Lay Power Line/$2,000.00========+| |+=======Pour Foundation/$1,500.00=======>| |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|+=========================================Install Pump/$500.00=========================================+| |
|<=================Pour Foundation/$1,500.00==================+| |+Install Pipe/$1,00>| |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|+========================================Erect Tower/$2,500.00=========================================>| |
|<========Install Pipe/$1,000.00=========+| | | | |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 29 | 30 | 31 | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|<Erect Tower/$2,500+| | | | | |
-------------------------------------------------------------------------------------------------------------------------------
Well Drilling Work Schedule: Output=Separate
_CAL_=CAL2 ........................................................................................................................
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 1 | 2 | 3 | 4 | 5 | 6 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | |+===============================Excavate/$3,500.00================================>|
|+==================Deliver Material/$500.00==================+| | | |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 8 | 9 | 10 | 11 | 12 | 13 |
|******Vacation******| | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| |<==========Excavate/$3,500.00===========+| | | |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 29 | 30 | 31 | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
-------------------------------------------------------------------------------------------------------------------------------
Example 9: Schedule Calendar with Combined Output
Well Drilling Work Schedule: Output=Combine
-------------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
----------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------|
| | 1 | 2 | 3 | 4 | 5 | 6 |
|.........|...................|...................|...................|...................|...................|...................|
| CAL1 | | | |***Independence****|+Assemble Tank/$1,>| |
| | | | | |+Lay Power Line/$2>| |
| |+==================Drill Well/$1,000.00===================>| |<Drill Well/$1,000+| |
|.........|...................|...................|...................|...................|...................|...................|
| CAL2 | | |+=============================Excavate/$3,500.00==============================>|
| |+================Deliver Material/$500.00=================+| | | |
|---------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------|
| | 8 | 9 | 10 | 11 | 12 | 13 |
|.........|...................|...................|...................|...................|...................|...................|
| CAL1 |+=========================Build Pump House/$2,000.00==========================+| | |
| |<===========================Assemble Tank/$1,000.00===========================+| | |
| |<======Lay Power Line/$2,000.00=======+| |+======Pour Foundation/$1,500.00======>| |
|.........|...................|...................|...................|...................|...................|...................|
| CAL2 |*****Vacation******|<=========Excavate/$3,500.00==========+| | | |
| | | | | | | |
|---------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------|
| | 15 | 16 | 17 | 18 | 19 | 20 |
|.........|...................|...................|...................|...................|...................|...................|
| CAL1 |+======================================Install Pump/$500.00=======================================+| |
| |<================Pour Foundation/$1,500.00================+| |+Install Pipe/$1,0>| |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|---------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------|
| | 22 | 23 | 24 | 25 | 26 | 27 |
|.........|...................|...................|...................|...................|...................|...................|
| CAL1 |+======================================Erect Tower/$2,500.00======================================>| |
| |<=======Install Pipe/$1,000.00========+| | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
|---------+-------------------+-------------------+-------------------+-------------------+-------------------+-------------------|
| | 29 | 30 | 31 | | | |
|.........|...................|...................|...................|...................|...................|...................|
| CAL1 |<Erect Tower/$2,50+| | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
-----------------------------------------------------------------------------------------------------------------------------------
Example 10: Schedule Calendar with Mixed Output
Well Drilling Work Schedule: Output=Mix
-------------------------------------------------------------------------------------------------------------------------------
| |
| July 1985 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 1 | 2 | 3 | 4 | 5 | 6 |
| | | | | | |
| | | | | | |
| | | | |+Assemble Tank/$1,0>| |
| | |+===============================Excavate/$3,500.00================================>|
|+==================Deliver Material/$500.00==================+|****Independence****|+Lay Power Line/$2,>| |
|+====================Drill Well/$1,000.00====================>|****Independence****|<Drill Well/$1,000.+| |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 8 | 9 | 10 | 11 | 12 | 13 |
| | | | | | |
| | | | | | |
|+===========================Build Pump House/$2,000.00============================+| | |
|<=============================Assemble Tank/$1,000.00=============================+| | |
|<=======Lay Power Line/$2,000.00========+| | | | |
|******Vacation******|<==========Excavate/$3,500.00===========+|+=======Pour Foundation/$1,500.00=======>| |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|+=========================================Install Pump/$500.00=========================================+| |
|<=================Pour Foundation/$1,500.00==================+| |+Install Pipe/$1,00>| |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 22 | 23 | 24 | 25 | 26 | 27 |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|+========================================Erect Tower/$2,500.00=========================================>| |
|<========Install Pipe/$1,000.00=========+| | | | |
|--------------------+--------------------+--------------------+--------------------+--------------------+--------------------|
| 29 | 30 | 31 | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|<Erect Tower/$2,500+| | | | | |
-------------------------------------------------------------------------------------------------------------------------------
Example 11: Schedule Calendar with Holidays Only (Partial Output)
Well Drilling Work Schedule: Output=Mix
-------------------------------------------------------------------------------------------------------------------------------
| |
| January 1988 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| | | | | | 1 | 2 |
| | | | | |***New Year's****| |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 31 | | | | | | |
| | | | | | | |
-------------------------------------------------------------------------------------------------------------------------------
. . .
Well Drilling Work Schedule: Output=Mix
-------------------------------------------------------------------------------------------------------------------------------
| |
| December 1988 |
| |
|-----------------------------------------------------------------------------------------------------------------------------|
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| | | | | 1 | 2 | 3 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| | | | | | | |
|-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------|
| 25 | 26 | 27 | 28 | 29 | 30 | 31 |
| |****Christmas****|****Christmas****|****Christmas****| | | |
-------------------------------------------------------------------------------------------------------------------------------
These samples are from the "SAS Procedures Guide, Version 6", Chapter 7.
For additional information on the samples refer to this book.
| Type: | Sample |
| Topic: | SAS Reference ==> Procedures ==> CALENDAR |
| Date Modified: | 2005-06-18 03:00:00 |
| Date Created: | 2005-05-23 13:44:17 |
Operating System and Release Information
| Product Family | Product | Host | SAS Release | |
| Starting | Ending | |||
| SAS System | Base SAS | All | n/a | n/a |