BookmarkSubscribeRSS Feed
tparvaiz
Obsidian | Level 7

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

1 REPLY 1

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 289 views
  • 0 likes
  • 1 in conversation