BookmarkSubscribeRSS Feed
laneylaners
Obsidian | Level 7

In excel, i can get a graph to show a 'gap' for missing data:

 

 gaps.JPG

 

how can i do this in sas?  this is the output i'm getting:

 

gaps 2.JPG

here is a snippet of the  data below, including the missing data as "."

 

 

 date count

11/01/2008 34
12/01/2008 26
01/01/2009 27
02/01/2009 19
03/01/2009 25
04/01/2009 36
05/01/2009 .
06/01/2009 .
07/01/2009 13
08/01/2009 15
09/01/2009 11
10/01/2009 11
11/01/2009 12
12/01/2009 27 

 

 

 

Here is my code for the graph:

ods graphics on / width=10in height=5in ;

goptions htext=15pt ;

title h=15pt "Counts";

proc sgplot data=work.monthly_no_HU_merged;

series x=date y=count/ lineattrs=(color=firebrick thickness=2.5);

xaxis valueattrs=(size=7pt) label="Month/Year" labelattrs=(size=10pt) interval=quarter minor valuesformat=monyy5.;

yaxis valueattrs=(size=10pt) label="#" grid labelattrs=(size=12pt) values=(0 to 100 by 5);

run;

title;

2 REPLIES 2
ballardw
Super User

Add the BREAK option to the SERIES statement.

laneylaners
Obsidian | Level 7

simple solution that worked perfectly.  thank you!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 3323 views
  • 4 likes
  • 2 in conversation