The CALENDAR Procedure

Example 3: Multiple Schedule Calendars with Atypical Workshifts (Separated Output)

Procedure features:

PROC CALENDAR statement
options:

	CALEDATA=
	DATETIME
	WORKDATA=

CALID statement:

	_CAL_ variable
	OUTPUT=SEPARATE option

DUR statement

OUTSTART statement

OUTFIN statement

This example

produces separate output pages for each calendar in a single PROC step
schedules activities around holidays
displays an 8-hour day, 5 1/2-day week
uses separate work patterns and holidays for each calendar.

Producing Different Output for Multiple Calendars
This example and Multiple Schedule Calendars with Atypical Workshifts (Combined and Mixed Output) use the same input data for multiple calendars to produce different output. The only differences in these programs are how the activities data set is sorted and how the OUTPUT= option is set.

To print . . . Sort the activities data set by . . . And set OUTPUT= to See Example

Separate pages for each calendar calendar id and starting date SEPARATE 3, 8

All activities on the same page and identify each calendar starting date COMBINE 4, 2

All activities on the same page and NOT identify each calendar starting date MIX 4

To print . . .	Sort the activities data set by . . .	And set OUTPUT= to	See Example
Separate pages for each calendar	calendar id and starting date	SEPARATE	3, 8
All activities on the same page and identify each calendar	starting date	COMBINE	4, 2
All activities on the same page and NOT identify each calendar	starting date	MIX	4

Program

libname well 'SAS-data-library';

data well.act; input task & $16. dur : 5. date : datetime16. _cal_ $ cost; datalines; Drill Well 3.50 01JUL96:12:00:00 CAL1 1000 Lay Power Line 3.00 04JUL96:12:00:00 CAL1 2000 Assemble Tank 4.00 05JUL96:08:00:00 CAL1 1000 Build Pump House 3.00 08JUL96:12:00:00 CAL1 2000 Pour Foundation 4.00 11JUL96:08:00:00 CAL1 1500 Install Pump 4.00 15JUL96:14:00:00 CAL1 500 Install Pipe 2.00 19JUL96:08:00:00 CAL1 1000 Erect Tower 6.00 20JUL96:08:00:00 CAL1 2500 Deliver Material 2.00 01JUL96:12:00:00 CAL2 500 Excavate 4.75 03JUL96:08:00:00 CAL2 3500 ;

data well.hol; input date date. holiday $ 11-25 _cal_ $; datalines; 09JUL96 Vacation CAL2 04JUL96 Independence CAL1 ;

data well.cal; input _sun_ $ _sat_ $ _mon_ $ _tue_ $ _wed_ $ _thu_ $ _fri_ $ _cal_ $; datalines; Holiday Holiday Workday Workday Workday Workday Workday CAL1 Holiday Halfday Workday Workday Workday Workday Workday CAL2 ;

data well.wor; input halfday time5.; datalines; 08:00 12:00 ;

proc sort data=well.act; by _cal_ date; run;

options nodate pageno=1 linesize=132 pagesize=60;

proc calendar data=well.act holidata=well.hol caledata=well.cal workdata=well.wor datetime;

calid _cal_ / output=separate;

start date; dur dur;

holistart date; holivar holiday;

outstart Monday; outfin Saturday; title1 'Well Drilling Work Schedule: Separate Calendars'; format cost dollar9.2; run;

Output

Separate Output for Multiple Schedule Calendars

Chapter Contents
Previous
Next
Top of Page