Hello all,

I am using following Proc Gchart code to get change the best %change from baseline of the longest diameter ( Prt )

*Use the proc gchart method:*; PROC GCHART DATA=best; VBAR Prt / DISCRETE Ascending subgroup=Arm_Trt legend=legend1 raxis=axis1 maxis=axis2 coutline=black SUMVAR=prtdiff vref = -30 CREF=blue vref = 20 CREF=blue ; run; quit;

This would give me a waterfall graph for various lesions . But the statistician wanted it this way

"That way all the data from the same dose group will be grouped together and show mini waterfall plots for each along the x-axis."

Even though I sort the dataset the graph is still grouping ascending order of Prt , . How can group by Arm_trt in this graph.

thanks all for your help and time Please let me know If I make sense or not. If needed I can send over whole program ( which is long) and sample data.

thanks SL