topic Create a challenging multiple bar graph in Graphics Programming

Create a challenging multiple bar graph

xinjian — Tue, 08 Sep 2015 20:50:35 GMT

Dear all,

I want to create a graph like attached from reference.

below is my data&colon;

Status ID sbp dbp
normal 46 125 72
normal 53 134 63
low 54 114 71
normal 59 126 72
normal 66 167 85
normal 78 185 80
normal 79 147 94
normal 80 169 91
normal 83 129 73
low 90 122 69
normal 93 153 89
normal 100 147 77
normal 109 126 71
low 110 152 70
normal 111 133 77
normal 113 130 77
normal 115 152 86
low 117 135 79
normal 120 144 73
normal 128 113 77

my syntax is:

data want;

set A;

if 0<sbp<140 or 0<dbp<90 then combp=0;/*normal group*/
if sbp>=140 or dbp>=90 then combp=1;/*hypertension group*/

proc gplot data=want;
plot ( sbp dbp)*ID/overlay;
run;

I have not figured out using variable 'combp' to split two groups and highlight status 'low' in graph. Is it possible to use my data to created same kind of reference graph?

Thanks in advance.

Re: Create a challenging multiple bar graph

Rick_SAS — Wed, 09 Sep 2015 12:05:32 GMT

Your image is too small for me to see the details, but it looks somewhat like a waterfall plot that is used in clinical studies. Look at the article "How to create a waterfall plot in SAS" and see if you can adapt that technique to your data.

Re: Create a challenging multiple bar graph

Jay54 — Mon, 14 Sep 2015 17:54:31 GMT

Looks like you can use a HIGHLOW plot in the SGPLOT procedure.

Re: Create a challenging multiple bar graph

Jay54 — Mon, 14 Sep 2015 19:11:19 GMT

Here is how you can use the HIGHLOW plot to create such a graph. Data uses sashelp.heart (age> 59) sorted by ascending Systolic, with Reference Lines at 80 and 120.

title 'Individual Systolic and Diastolic Blood Pressure';
proc sgplot data=heart2 noborder nowall;
highlow x=id high=systolic low=diastolic / type=line;
refline 80 120;
xaxis display=none;
yaxis min=0 grid;
run;