topic Re: gplot order and dates in Graphics Programming

gplot order and dates

deleted_user — Fri, 05 Mar 2010 21:15:44 GMT

I have dates in the following format monyy (eg JAN06, FEB06, etc).
How do I plot dates from JAN09 to FEB10 by quarter?
Thank you.

Re: gplot order and dates

sbb — Fri, 05 Mar 2010 21:32:27 GMT

Share a sample of your SAS data set that you want to plot/chart. And you will want your SAS variables to be NUMERIC, DATE variables, not tranformed character-string representations of a mmmyy flavor.

For SAS 9.2, consider XAXIS and INTERVAL= option. Or option to derive a quarter-start date variable and use the SAS output FORMAT to display as needed.

http://support.sas.com/documentation/cdl/en/grstatproc/61948/HTML/default/xaxis-stmt.htm

Scott Barry
SBBWorks, Inc.

Re: gplot order and dates

MikeZdeb — Fri, 05 Mar 2010 21:41:47 GMT

hi ... the following makes a data set with 1000 dates then does a histogram
of the dates grouped by year-quarter

I made the assumption that when you said PLOT you meant CHART since
I'm not quite sure how a PLOT fits with grouping data on the X-AXIS

so, here's a suggestion
[pre]
* make some fake data;
data x;
do j=1 to 1000;
dt = ceil(750*ranuni(123)) + 15000;
output;
end;
format dt monyy.;
drop j;
run;

* look at the data ... table of MONTH-YEAR;
proc freq data=x;
table dt;
run;

* histogram ... dates grouped by quarter within year using YYQ. format;
proc gchart data=x;
vbar dt / discrete;
format dt yyq.;
run;
quit;
[/pre]