SAS GChart display issue

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 129
Accepted Solution

SAS GChart display issue

Hi,

I am using Proc GChart to display some graphical bars.. in my table I have dates for 14 days but the graph is displaying just random dates and the associated data.

as an example, I have dates from June 26 2012 to July 9 2012 but graph is showing only 26 June, 29 June 2 July 5 July and 8 July

here is my data

CATEGORYDAY_DATEVOLUME
COM_126Jun2012165,568
COM_127Jun2012134,287
COM_128Jun2012198,094
COM_129Jun2012197,668
COM_130Jun2012142,697
COM_101Jul2012157,581
COM_102Jul2012196,513
COM_103Jul2012174,259
COM_104Jul2012102,094
COM_105Jul2012105,536
COM_106Jul201293,170
COM_107Jul2012129,333
COM_108Jul2012138,129
COM_109Jul2012148,199

Here is the code that I am using

axis1 minor=none label=('Volumes');

axis2 minor=none label=(f='Arial/Bold' justify=centre 'Days')

value = (font="Arial" height = 8pt);

title1 'Title1';

PROC GCHART DATA=WORK.TABLE;

  VBAR3D

  DAY_DATE

/

SUMVAR=VOLUME

  SHAPE=Cylinder

FRAME TYPE=SUM

SUM

  LEGEND=LEGEND1

  COUTLINE=BLACK

  RAXIS=AXIS1

  MAXIS=AXIS2

PATTERNID=MIDPOINT

  LREF=1

  CREF=BLACK

  AUTOREF

  space=0

;

  BY CATEGORY;

RUN; QUIT;

Please advice

Thanks


Accepted Solutions
Solution
‎06-25-2012 04:31 PM
Contributor QLi
Contributor
Posts: 57

Re: SAS GChart display issue

to put  "Discrete" Option in the statement of VBAR3D,  try it

PROC GCHART DATA=have;
  VBAR3D
  DAY_DATE / discrete SUMVAR=VOLUME  SHAPE=Cylinder

FRAME TYPE=SUM SUM

  LEGEND=LEGEND1

  COUTLINE=BLACK

  RAXIS=AXIS1

  MAXIS=AXIS2

PATTERNID=MIDPOINT

  LREF=1

  CREF=BLACK

  AUTOREF

  space=0

;

RUN; QUIT;

View solution in original post


All Replies
Solution
‎06-25-2012 04:31 PM
Contributor QLi
Contributor
Posts: 57

Re: SAS GChart display issue

to put  "Discrete" Option in the statement of VBAR3D,  try it

PROC GCHART DATA=have;
  VBAR3D
  DAY_DATE / discrete SUMVAR=VOLUME  SHAPE=Cylinder

FRAME TYPE=SUM SUM

  LEGEND=LEGEND1

  COUTLINE=BLACK

  RAXIS=AXIS1

  MAXIS=AXIS2

PATTERNID=MIDPOINT

  LREF=1

  CREF=BLACK

  AUTOREF

  space=0

;

RUN; QUIT;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 185 views
  • 1 like
  • 2 in conversation