Proc GCHART - how to show data for all available days in a month

[tparvaiz]

Hi, I am using Proc GCHART to show some data by day for the last 90 days...

my only issue is that if the data is not available for a specific date then it doesn't show up, is there a way to show a blank when the data is not available in a particular month.?

Here is the code that I've used

PROC GCHART DATA=WORK.TABLE_A

;

  VBAR

  YEAR_MONTH_DAY

/ discrete

  SUMVAR=VOL

  SUBGROUP=CITY

  CLIPREF

FRAME TYPE=SUM

  LEGEND=LEGEND1

  COUTLINE=BLACK

  RAXIS=AXIS1

  MAXIS=AXIS2

;

Thanks

[tparvaiz]

anyone...?