The CALENDAR Procedure

Example 8: Multiple Summary Calendars with Atypical Workshifts (Separated Output)

Procedure features:

PROC CALENDAR statement
options:

	DATETIME
	LEGEND

CALID statement:

	_CAL_ variable
	OUTPUT=SEPARATE option

OUTSTART statement

OUTFIN statement

SUM statement

Data sets:

WELL.ACT and WELL.HOL .

This example

produces a summary calendar for multiple calendars in a single PROC step
prints the calendars on separate pages
displays holidays
uses separate work patterns, work shifts, and holidays for each calendar

Producing Different Output for Multiple Calendars
This example produces separate output for multiple calendars. To produce combined or mixed output for these data, you need to change only two things:

how the activities data set is sorted
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'; run;

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 datetime legend;

calid _cal_ / output=separate;

start date; holistart date; holivar holiday;

sum cost / format=dollar10.2;

outstart Monday; outfin Saturday; title 'Well Drilling Cost Summary'; title2 'Separate Calendars'; format cost dollar10.2; run;

Output

Separated Output for Multiple Summary Calendars

Chapter Contents
Previous
Next
Top of Page