topic Re: Proc GCHART Date X axis in Graphics Programming

Proc GCHART Date X axis

minfante — Fri, 08 May 2015 19:54:52 GMT

Hi,

I am trying to plot a simple bar chart in SAS 9.3. My data looks like this:

Date Plot

07jan2010 10

12jan2010 4

22feb2010 1

etc.

Using the following code:

proc gchart data=dataset;

vbar plot / discrete sumvar = plot

type=sum;

run;

quit;

The axis that shows is a text axis -- the dates for which no observations exist in the dataset (ex.: Jan 8 2010) do not show up on the x axis. Does anyone have corrections to my codes?

Thanks,

Matt

Re: Proc GCHART Date X axis

n6 — Fri, 08 May 2015 20:49:41 GMT

Is the date variable stored as a date or as text? If it's text then 25Jan2010, for instance, would show up after 22Feb2010 even though you woudn't want it to.

Also, you say that the dates for which there are no observations in the dataset don't show up on the x-axis. Isn't that a good thin? I mean, if there are 0 observations for Feb 1, 2010, wouldn't you want it to just not show up on the x-axis instead of having it say Feb 1, 2010 on the x-axis and then have a blank space above it where there is no bar because it Feb 1, 2010 wasn't in the dataset?

Re: Proc GCHART Date X axis

minfante — Fri, 08 May 2015 20:53:45 GMT

The date variable is stored as date..

I'd prefer to have missing bars for Feb 1, 2010 so that the x-axis has a common interval.

Re: Proc GCHART Date X axis

DanH_sas — Fri, 08 May 2015 21:15:38 GMT

This should work for you:

data dataset;

informat date date9.;

format date date9.;

input date $ plot;

cards;

07jan2010 10

12jan2010 4

22feb2010 1

;

run;

proc gchart data=dataset;

vbar date / discrete sumvar = plot

type=sum midpoints=('07jan2010'd to '22feb2010'd);

run;

quit;