What graph do I need?

[Filipvdr]

Hi, i'm new to creating graphs in SAS.

I have to create a graph which looks like this:

On x-ax: months

I need two Y-axes: on the left measure A, on the right measure B.

I need bars for measure A, a line with at each month a square for Measure B.

I need a dotted line for the median of measure B.

At last i need an average of measure A for the last year which is also represented as a bar in the graph. Is this possible in the graph or better to calculate up front?

So my main question is: what kind of graph do I have to start with? An example would be nice.

Thanks

Filip

[jcbell]

Filip,

I would probably start with a bar-line graph.  You can either add additional plots or annotate the chart to create the look you want.

See this example:

http://robslink.com/SAS/democd45/gblstock_info.htm

[Filipvdr]

Thanks, this comes quite near of what i have to use... Can you tell me how I can sort on date?

axis1 label=('Volume (%)') order=(0 to 200 by 50) minor=none;
axis2 label=('Tat (DAYS)') order=(0 to 7 by 1) minor=none;
axis3 label=('Month');
axis3 order=("01JAN2010"d to "01MAR2011"d by month);

proc gbarline data=graph;
   bar month / discrete
      sumvar=RQPV raxis=axis1 maxis=axis3
      width=15 des='' name="Test" ;
   plot /
      sumvar=TAT raxis=axis2;
run;

[ballardw]

Filipvdr wrote:
Thanks, this comes quite near of what i have to use... Can you tell me how I can sort on date?

if you have a date variable the use Proc sort data=graph; by <date variable>;run; If you want different bars for Jan 2010, Jan 2011, Feb 2010 and Feb 2011 your variable MONTH is likely not to quite get you there unless MONTH includes a year component. A SAS date variable using a format of MONYY. or MMYY. might work better.

Your code would need changes of :

    bar <datevariable> /   ;

    format <datevariable> MONYY.;

[Rick_SAS]

Here's how to get started with a few lines in PROC SGPLOT:

http://support.sas.com/documentation/cdl/en/grstatproc/64778/HTML/default/viewer.htm#n1mp0swy0atvzun...