01-24-2014 12:16 PM
hi, I have a spreadsheet with Dates, and events for two groups, I want to create a monthly calendar from this. Is there any way to do?
for example, the spreadsheet is with hearder: DATE, GROUP_A, GROUP_B
the data in the file is like below:
1-JAn-2014, A_EVENT1, B_EVENT2
Appreciate the input
01-24-2014 03:46 PM
can you elaborate your requirement , these events occur on these dates for every month?? and you just want to populate these events for every month on same dates?
01-24-2014 05:41 PM
If you plan to create a summary calendar only, then one strategy is to collapse all of your events into one variable.
events = GROUP_A || ' ' || GROUP_B
Make sure the data being read into PROC CALENDAR has one "events" observation per day.
01-24-2014 06:15 PM
informat date date9.;
format date date9.;
input date (groupa groupb) ($);
1jan2014 A_EVENT1 B_EVENT2
2jan2014 A_EVENT2 .
3jan2014 . B_EVENT3
3jan2014 . B_EVENT4
data events (keep=date event long _cal_);
if not missing(groupa) then do;
if not missing(groupb) then do;
proc sort data=events;
options nodate pageno=1 linesize=132 pagesize=60;
proc calendar data=events;
title1 'Summer Planning Calendar: Julia Cho';