BookmarkSubscribeRSS Feed
Cruise
Ammonite | Level 13

I'm trying to visualize 20 years time trend in Rate Ratios of cancer incidence across 3 different regions POP, VOC and other. Most examples on the forest plot has CI95 on the x plot and subgroups on Y which I find different from my purpose.

 

Any hints or direct coding help will be greatly appreciated.

 

Image should look something like below.

ci95 by zones.png

 

Data for the plot is following:

 

data CI_timetrend;
input year	Exposure $	RR	LCL	UCL;
cards;
1995 Other 0.54 0.34 0.85
1996 Other 1.11 0.80 1.54
1997 Other 1.13 0.81 1.56
1998 Other 0.86 0.59 1.23
1999 Other 1.15 0.82 1.60
2000 Other 1.13 0.81 1.58
2001 Other 0.79 0.55 1.15
2002 Other 1.15 0.84 1.58
2003 Other 1.00 0.71 1.41
2004 Other 1.14 0.83 1.55
2005 Other 1.03 0.74 1.42
2006 Other 0.76 0.52 1.10
2007 Other 1.03 0.75 1.41
2008 Other 1.17 0.87 1.58
2009 Other 1.03 0.75 1.41
2010 Other 0.92 0.66 1.28
2011 Other 1.20 0.90 1.59
2012 Other 1.08 0.79 1.45
2013 Other 1.16 0.88 1.55
2014 Other 0.97 0.72 1.31
2015 Other 1.11 0.84 1.48
1995 POP 0.98 0.84 1.13
1996 POP 1.03 0.89 1.19
1997 POP 1.04 0.90 1.20
1998 POP 1.02 0.88 1.17
1999 POP 1.08 0.93 1.25
2000 POP 1.10 0.95 1.27
2001 POP 0.91 0.79 1.05
2002 POP 1.12 0.97 1.29
2003 POP 1.19 1.03 1.36
2004 POP 0.98 0.85 1.13
2005 POP 1.00 0.87 1.15
2006 POP 0.98 0.85 1.12
2007 POP 0.97 0.84 1.11
2008 POP 0.99 0.86 1.13
2009 POP 0.99 0.86 1.13
2010 POP 0.99 0.86 1.13
2011 POP 1.02 0.89 1.16
2012 POP 1.06 0.93 1.21
2013 POP 0.94 0.83 1.08
2014 POP 1.03 0.91 1.17
2015 POP 0.98 0.86 1.12
1995 VOC 1.03 0.91 1.18
1996 VOC 0.97 0.84 1.11
1997 VOC 0.97 0.84 1.11
1998 VOC 0.95 0.83 1.09
1999 VOC 1.04 0.91 1.19
2000 VOC 1.04 0.91 1.19
2001 VOC 1.05 0.92 1.19
2002 VOC 1.06 0.93 1.21
2003 VOC 1.18 1.04 1.34
2004 VOC 0.98 0.86 1.11
2005 VOC 1.09 0.96 1.24
2006 VOC 1.08 0.96 1.23
2007 VOC 0.98 0.86 1.11
2008 VOC 1.02 0.90 1.15
2009 VOC 1.02 0.90 1.15
2010 VOC 1.03 0.91 1.16
2011 VOC 1.04 0.92 1.17
2012 VOC 1.04 0.92 1.17
2013 VOC 0.98 0.87 1.10
2014 VOC 0.98 0.87 1.10
2015 VOC 1.03 0.92 1.16
;

 

4 REPLIES 4
PeterClemmensen
Tourmaline | Level 20

How do want the actual values plottet? Does not make sense to me?

Cruise
Ammonite | Level 13
these values are actual values but POP, VOC and Other, three categories are in very close margin. which part doesn't make sense to you?
PeterClemmensen
Tourmaline | Level 20

I'm not sure how you want the intervals plotted. I only see the axes?

 

Do you want the intervals to be plotted vertically for every year for every category?

Cruise
Ammonite | Level 13

@PeterClemmensen

Thanks for asking. Since i'm running out of time, I'm considering just to table the data as shown in the screen shot below. However, what I originally wanted for the forest plot was having years on the x axis as for a time-trend while multiple axis on Y by POP, VOC and Other to plot the RR along its LCL and UCL. Just like a hybrid of forest plot and time-series chart. 

 

plotci95.png

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 856 views
  • 0 likes
  • 2 in conversation