topic Re: forest plot for subgroup in Graphics Programming

forest plot for subgroup

lillymaginta — Tue, 31 Oct 2017 14:41:11 GMT

Subgroup oddsratio LCL UCL 
age<=65          0.68 0.61  0.76
age>65           0.90 0.71  1.14                                                                                              
MI               0.71 0.64  1.84
diabetes         0.71 0.62  0.82                                                                                                
hypertension     0.51 0.45  2.58                                                                                                 
asthma           0.55 0.43  0.70                                                                                               
cancer           0.61 0.54  0.69                                                                                                
hic              0.64 0.53  0.76                                                                                                 
rt               0.67 0.38  1.77                                                                                                
Overall          0.68 0.61  0.46

Hi i have the following summary table of subgroup analysis, can someone help with a code to draw a forest plot out of this table? thanks

Re: forest plot for subgroup

PeterClemmensen — Tue, 31 Oct 2017 14:57:19 GMT

Something like this?

data have;
input Subgroup$ oddsratio LCL UCL;
datalines;
age<=65          0.68 0.61  0.76
age>65           0.90 0.71  1.14
MI               0.71 0.64  1.84
diabetes         0.71 0.62  0.82
hypertension     0.51 0.45  2.58
asthma           0.55 0.43  0.70
cancer           0.61 0.54  0.69
hic              0.64 0.53  0.76
rt               0.67 0.38  1.77
Overall          0.68 0.61  0.46
;

title "Simple Forest Plot";
ods graphics on;
proc sgplot data=have;
	scatter x=oddsratio y=Subgroup / xerrorlower=LCL xerrorupper=UCL;
run;
title;

Re: forest plot for subgroup

lillymaginta — Tue, 31 Oct 2017 15:08:39 GMT

Thank you for the quick reply. I want something that looks like this with the groups listed on the left side, ignores the no of patients, and the odds ratios and confidence intervals on the right side. Also, I need the line that shows that extend from the value 1

Re: forest plot for subgroup

Rick_SAS — Tue, 31 Oct 2017 15:11:06 GMT

To add to Draycut's answer, see the discussion and examples in the article "Regression coefficient plots in SAS." For odds ratio plots, see the article "Odds ratio plots with a logarithmic scale in SAS"

Re: forest plot for subgroup

Rick_SAS — Tue, 31 Oct 2017 15:29:16 GMT

@WarrenKuhfeld and @Jay54 have both written about this. Start with this blog post.