topic Re: X-Axis on SGPLOTS in SAS Procedures

X-Axis on SGPLOTS

podarum — Sat, 07 Apr 2012 14:15:31 GMT

Hi, I'm running SGPLOTS and although the x-asix is the correct one, it doesn't show up as expected...

My code is

proc sgplot data = Data;

vline Date / response = NHPI y2axis;

xaxis values=('01Jan2010'd to '31Dec11'd by qtr);

xaxis Label = 'Date' Grid Values = (0 to 5 by 1);

refline '31Dec11'd / axis=x;

run;

But the X-Axis still shows up crammed and not readable (from the Jan2000 to Dec2011, rather then the time span specified)... any ideas? Thanks

Re: X-Axis on SGPLOTS

Cynthia_sas — Sat, 07 Apr 2012 14:22:53 GMT

Hi:

Is it an accident that you have 2 XAXIS statements in your code? Each XAXIS statement has a VALUES= option.

cynthia

Re: X-Axis on SGPLOTS

podarum — Sat, 07 Apr 2012 14:33:39 GMT

Thanks Cynthia, I removed the second xaxis line and got the same results..

Re: X-Axis on SGPLOTS

Jay54 — Sat, 07 Apr 2012 15:15:45 GMT

Add TYPE=time on the first xaxis stmt and remove the second xaxis stmt.

xaxis type=time values=('01Jan2010'd to '31Dec11'd by qtr);

Re: X-Axis on SGPLOTS

podarum — Sat, 07 Apr 2012 17:42:38 GMT

Thanks Sanjay.. works fine..

Re: X-Axis on SGPLOTS

podarum — Sat, 07 Apr 2012 17:45:54 GMT

What line could I add if I wanted to show another variable as a secondary Y-Axis but on a different scale.. so have a left and right scale for each of the 2 vars? Thanks

Re: X-Axis on SGPLOTS

Jay54 — Sat, 07 Apr 2012 18:13:21 GMT

See my recent article on this topic at Graphically Speaking

Re: X-Axis on SGPLOTS

podarum — Sun, 08 Apr 2012 01:35:43 GMT

Great stuff.. Thank you.

Re: X-Axis on SGPLOTS

podarum — Sat, 30 Jun 2012 13:35:26 GMT

Hey, what's the best way to show a correlation between Price and say Unemployement rate on a graph? I'm thinking a 2-Y axis chart?

Thanks,