topic Re: How do I display subset of time values on XAXIS in SGPLOT in Graphics Programming

How do I display subset of time values on XAXIS in SGPLOT

eshupp — Tue, 14 Feb 2017 17:32:00 GMT

I am producing a stacked VBAR with SGPLOT (replicating a GCHART) with 24 hours of 5 minute interval data on zOS SAS 9.4 TS1M4. I only want to display hourly values on the XAXIS (ie: 1, 2, 3,...23) but SGPLOT wants to display a value for each 5 minute time value. Based on other answers I tried createing a tick format with VALUE entries for each hourly time value ('01:00:00't ... '23:00:00't) translating to a value and OTHER='' and then using the VALUESFORMAT= option on the XAXIS statement but that did not work and the chart displayed unreadable values for each bar.

my code:

proc sgplot data=vmlpar;
by sysid;
vbar time / response=lnxbusy fill group=vmduser grouporder=ascending stat=sum;
xaxis label='Time of Day' valueattrs=(blue) valuesformat=tick.;

Re: How do I display subset of time values on XAXIS in SGPLOT

Shmuel — Tue, 14 Feb 2017 17:48:12 GMT

I'm not sure - can you enter a format statment in the sqgplot - like

format time time2. ;

If not, create a new variable to be used on VBAR statement:

hour = hour(time);

Re: How do I display subset of time values on XAXIS in SGPLOT

DanH_sas — Tue, 14 Feb 2017 18:02:21 GMT

Since you are using SAS 9.4m3 or greater, try adding TYPE=TIME to your XAXIS statement and see if you get what you want. You can also control the intervals displayed by using the INTERVAL option on the XAXIS statement.

Hope this helps!

Dan

Re: How do I display subset of time values on XAXIS in SGPLOT

ballardw — Tue, 14 Feb 2017 18:06:25 GMT

did you try the INTERVAL=HOUR option on your XAXIS statement?

You may also need to use TICKVALUEFORMAT=time2.

This does assume that that your variable time is a SAS time value.

Re: How do I display subset of time values on XAXIS in SGPLOT

eshupp — Wed, 15 Feb 2017 13:10:40 GMT

TYPE=TIME in addition to INTERVAL=MINUTE along with the TICKVALUEFORMAT=myformat. resolved my display issue. Thanks to all for the input.