The Earned Value Management Macros

%EVG_GANTT_CHART

This macro is used to produce a Gantt chart of the planned and revised schedule, along with selected earned value metrics for each task.

%EVG_GANTT_CHART ( parameters ) ;

Note: %EVG_GANTT_CHART requires output from %EVA_METRICS.

Required Parameters

ACTIVITY= variable

specifies the activity variable in the PLANSCHED= and REVISESCHED= data sets.

FINISH= variable

specifies the finish date or datetime variable in the PLANSCHED= and REVISESCHED= data sets.

PLANSCHED= SAS-data-set

identifies the data set containing the planned schedule.

REVISESCHED= SAS-data-set

identifies the data set that contains the updated schedule.

START= variable

specifies the start date or datetime variable in the PLANSCHED= and REVISESCHED= data sets.

Optional Parameters

CHART= SAS-data-set

specifies the name of the output data set. This is an internal data set that is used as input to the GANTT procedure. The default data set name is CHART.

DURATION= variable

specifies a duration variable in the PLANSCHED= or REVISESCHED= data set. The specified variable in the REVISESCHED= data set is used if the variable is present in both data sets. This variable is used only for differentiating milestones from single-day tasks.

HEIGHT= h

specifies a height factor for all text in PROC GANTT. (See the HEIGHT= option for the CHART statement of PROC GANTT (Chapter 8) for more details.)

HPAGES= h

specifies that the Gantt chart is to be produced using h horizontal pages. (See the HPAGES= option for the CHART statement of PROC GANTT (Chapter 8) for more details.)

VPAGES= v

specifies that the Gantt chart is to be produced using v vertical pages. (See the VPAGES= option for the CHART statement of PROC GANTT (Chapter 8) for more details.)

ID= variable(s)

specifies a space-delimited list of the variables from the TASKS= data set to be included in the chart. The choices are: WBS, PV, EV, AC, CV, CVP, SV, SVP, CPI, and SPI. The default value is CV SV.

SCALE= scale

specifies the relative size adjustment of the data columns and chart. (See the SCALE= option for the CHART statement of PROC GANTT (Chapter 8) for more details.)

TASKMETRICS= SAS-data-set

specifies the name of the output data set from the %EVA_TASK_METRICS macro. The default data set name is TASKMETS.

TIMENOW= time

specifies the date (’ddmmmyy’d) or datetime (’ddmmmyy:hh:mm:ss’dt) of the updated schedule and costs. The default value is today’s date, unless the macro variable _TIMENOW_ has been set, in which case the default is the latter. A vertical line and label indicate the value.

Table 11.9 summarizes the parameters used for managing input and output data sets in the %EVG_GANTT_CHART macro.

Table 11.9: %EVG_GANTT_CHART I/O Parameter Summary

Type

Data Set

Variables

INPUT

PLANSCHED

ACTIVITY, DURATION, FINISH, START

INPUT

REVISESCHED

ACTIVITY, DURATION, FINISH, START

INPUT

TASKMETRICS

 

OUTPUT

CHART