Data visualization with SAS programming

forest plot for subgroup

Reply
Frequent Contributor
Posts: 134

forest plot for subgroup

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 

PROC Star
Posts: 1,193

Re: forest plot for subgroup

Posted in reply to lillymaginta

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;
Frequent Contributor
Posts: 134

Re: forest plot for subgroup

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

 

 

 

Image result for forest plot sas

SAS Super FREQ
Posts: 4,125

Re: forest plot for subgroup

Posted in reply to lillymaginta
@WarrenKuhfeld and @Sanjay_SAS have both written about this. Start with this blog post.
SAS Super FREQ
Posts: 4,125

Re: forest plot for subgroup

Posted in reply to lillymaginta
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"
Ask a Question
Discussion stats
  • 4 replies
  • 328 views
  • 3 likes
  • 3 in conversation