PO10 : Multiple Forest Plots and the SAS

1
PO10 Multiple Forest Plots and the SAS System
Anne Barfield, Quanticate, Manchester, UK
The Forest Plot can be created using a single
Macro Call The Macro has been split into four
parts for ease of explanation
Firstly the creation of the Confidence Intervals
macro hazard(byvar, meas, cens,
censval, sign, var1) proc phreg
datadata1 outestpdata2 by byvar.
model meas.cens.(censval.) var1 /
alphasign. rl ODS OUTPUT
PARAMETERESTIMATES ESTS run ods
listing ANY MANIPULATION REQUIRED
For Manipulation of the
estimates dataset mend Once the
dataset with the estimates for the Confidence
Intervals and Hazard Ratios is created the
annotation dataset for the drawing of the
Confidence Intervals can be created mac
ro confid (order, sty, col, tips, haz, low,
upp) data bars set est if haz
ne . length function 8. text 40. xsys
'2' ysys '2' colorcol yid
xhaz. function'move' output
if lcl gt 0 then do xlcl
function'draw' output link
tips end if ucl ne . then do
xucl function'draw'
output link tips end return
--- Tips of Confidence intervals
yid-tips. function 'move' output
yidtips. function 'draw' output yid
function'move' output
return run mend The information created in
the macro above will be added to the estimates
dataset and stored as the dataset BARS . The
Hazard Ratio and Confidence Interval variables
are included in the Macro call for ease where you
have multiple results calculated on different
groups in a dataset.
For the Macro to be as robust as possible it is
recommended that the Macro be written for the
data manipulation AND the creation of the
Annotate Dataset.