Hi Michael,

Can I suggest that you use the activity table to create 2 separate calendar before using proc calendar?

In this way you can put them together on 1 calendar.

Below are shots of my calendar.

DATA ACTS;

INPUT STA : DATE7. ACT $ 11-30 DUR _CAL_ $;

DATALINES;

01JAN09 START 0 CAL1

20MAR09 TRAVEL 2 CAL2

22MAR09 SGF 2009 4 CAL1

31DEC09 FINISH 0 CAL1

;

RUN;

DATA HOLIDAYS;

INPUT STA : DATE7. ACT $ 11-50 DUR;

DATALINES;

01JAN09 NEW YEAR'S DAY 1

13JAN09 STEPHEN FOSTER MEMORIAL DAY 1

19JAN09 MARTIN LUTHER KING DAY 1

01FEB09 NATIONAL FREEDOM DAY 1

02FEB09 GROUNDHOG DAY 1

14FEB09 VALENTINE'S DAY 1

16FEB09 PRESIDENTS' DAY 1

17MAR09 ST. PATRICK'S DAY 1

20MAR09 VERNAL EQUINOX 1

12APR09 EASTER SUNDAY 1

15APR09 TAX DAY 1

22APR09 ADMINISTRATIVE PROFESSIONALS DAY 1

01MAY09 LOYALTY DAY 1

01MAY09 LAW DAY 1

05MAY09 CINCO DE MAYO 1

07MAY09 NATIONAL DAY OF PRAYER 1

10MAY09 MOTHER'S DAY 1

15MAY09 PEACE OFFICERS MEMORIAL DAY 1

15MAY09 NATIONAL DEFENSE TRANSPORTATION DAY 1

22MAY09 NATIONAL MARITIME DAY 1

25MAY09 MEMORIAL DAY 1

14JUN09 FLAG DAY 1

21JUN09 FATHER'S DAY 1

21JUN09 JUNE SOLSTICE 1

03JUL09 INDEPENDENCE DAY 1

04JUL09 'INDEPENDENCE DAY' OBSERVED 1

26JUL09 PARENTS' DAY 1

19AUG09 NATIONAL AVIATION DAY 1

07SEP09 LABOR DAY 1

11SEP09 PATRIOT DAY 1

12SEP09 CARL GARNER FEDERAL LANDS CLEANUP DAY 1

13SEP09 NATIONAL GRANDPARENTS DAY 1

17SEP09 CONSTITUTION DAY AND CITIZENSHIP DAY 1

22SEP09 AUTUMNAL EQUINOX 1

27SEP09 GOLD STAR MOTHER'S DAY 1

05OCT09 CHILD HEALTH DAY 1

09OCT09 LEIF ERIKSON DAY 1

12OCT09 COLUMBUS DAY (MOST REGIONS) 1

15OCT09 WHITE CANE SAFETY DAY 1

31OCT09 HALLOWEEN 1

01NOV09 ALL SAINTS 1

11NOV09 VETERANS DAY 1

26NOV09 THANKSGIVING DAY 1

27NOV09 BLACK FRIDAY 1

07DEC09 PEARL HARBOR REMEMBRANCE DAY 1

17DEC09 PAN AMERICAN AVIATION DAY 1

17DEC09 WRIGHT BROTHERS DAY 1

21DEC09 DECEMBER SOLSTICE 1

24DEC09 CHRISTMAS EVE 1

25DEC09 CHRISTMAS DAY 1

31DEC09 NEW YEAR'S EVE 1

;

RUN;

PROC CALENDAR DATA =ACTS HOLIDATA=HOLIDAYS FILL INTERVAL=DAY;

START STA;

DUR DUR;

HOLISTA STA;

HOLIVAR ACT;

HOLIDUR DUR;

RUN;

The above code should give you a pretty nice calendar. Just add your friends birthday and death date in and it should be fine. If you want to read more about the Proc Calendar, I can send you my manuscript for NESUG 2009.

-- Regards, Murphy Choy

Certified Advanced Programmer for SAS V9 Certified Basic Programmer for SAS V9 DataShaping Certified SAS Professional