Hello,
I have a dataset with a few missing dates. I am trying to plot time(year/month) vs rates. When I plot my graph using sgplot grouping by year, it produces icons of all the relevant years as well as the missing dates (in grey) in the legend. There is no grey line plot. Is there a way of fixing this if I am not able to correct the missing dates? How can I remove the grey icon that shows missing dates? is it the proper way to solve it?
On the SERIES statement, include the NOMISSINGGROUP option, which specifies that missing values of the group variable are not included in the plot.
Here is the code I use
```
proc sgplot data=mean_kola_num;
styleattrs datacontrastcolors=(blue red green brown);
series x=month_name y=mean_t_b / group=annee markers
legendlabel="original" ;
xaxis label='Month';
yaxis label='Average';
run;
```
Thank you, would that go in the sgplot section?
On the SERIES statement, include the NOMISSINGGROUP option, which specifies that missing values of the group variable are not included in the plot.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.
Ready to level-up your skills? Choose your own adventure.