topic Re: axis statement order by quarter? in SAS Procedures

axis statement order by quarter?

Eva — Thu, 09 Jul 2009 08:23:09 GMT

Dear all,

I have a prog gplot and on the haxis I want to display quarters of a year. On this axis I would like to have only the tick marks of the quarters, nothing else.

I tried haxis=axis1;

axis1 order=(200804 to 200902 by quarter);

And as I have a look in the data I have 200804, 200901, 200902.

But all I get is the tick mark 200902 and the hint that all other values are outside the axis range:
8 observation(s) outside the axis range

What's wrong here? Does the "by quarter" exist in sas?

Best regards
Eva

Re: axis statement order by quarter?

deleted_user — Thu, 09 Jul 2009 12:14:14 GMT

This isn't a direct answer to your question, but you can find examples of graphs that use the tick mark at http://support.sas.com/sassamples/graphgallery/PROC_GPLOT_Graph_Elements_Axis.html. Scroll through and choose the image closest to what you need. Then select the View Code link just above the image.

Re: axis statement order by quarter?

Bill — Thu, 09 Jul 2009 12:49:08 GMT

indeed there is

axis1 order=("&strtyr"d to "&Grfend"d by qtr);

Re: axis statement order by quarter?

Eva — Fri, 10 Jul 2009 06:53:03 GMT

Dear Bill,

I habe the quarters in the format 200804 (yyyyqq). So the "&myqtr"d doesn't work. Unfortunately q instead of d doesn't work either 😉

Best regards
Eva

Re: axis statement order by quarter?

sbb — Fri, 10 Jul 2009 13:06:52 GMT

Assign another SAS numeric variable and convert the character-format date string into another SAS variable using the INPUT function with the appropriate INFORMAT. Another option is to generate a SAS macro variable with a discrete list of values using PROC SQL.

Scott Barry
SBBWorks,Inc.

Re: axis statement order by quarter?

Eva — Fri, 10 Jul 2009 13:20:20 GMT

Dear Scott Barry,

that's exactly how I solved it in the meantime. Another solution is to just change the graph. I though about doing a proc gchart where I can define midpoints. As they are quarters that's easy, because they don't need too much space.

Best regards
Eva

Re: axis statement order by quarter?

Bill — Fri, 10 Jul 2009 14:49:22 GMT

Eva;

The axis statement that I posted earlier (sorry that it was so terse) pre-supposes that the dates will be SAS date values (i.e. days since 01Jan1960).

To force quarters to be the first day of the quarter, I often use the intnx function as follows:

QtrDate=intnx("Quarter',ActualDateValue,0,'b'); This results in values like 01JanYY, 01AprYY,01JulYY,01OctYY when formatted as date5. This date field will then plot very nicely with a qtr increment in the axis statement.

Hope this helps,
Bill

Re: axis statement order by quarter?

Eva — Mon, 13 Jul 2009 11:06:36 GMT

Dear Bill,

great idea - and it works well! Thanx for the advice!

Best wishes
Eva