How to remove missing variable in legend.

[pearson101]

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?

[pearson101]

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;

```

[Reeza]

You can add a WHERE statement to filter out missing values?
Fill in the variable name as needed.

Where not missing(variable) and not missing(variable) and not missing(variable);

[pearson101]

Thank you, would that go in the sgplot section?

[Reeza]

Yes, WHERE statements generally go after the PROC statement (good practice) and can go in almost every PROC/DATA STEP in SAS.

[Rick_SAS · Accepted solution]

On the SERIES statement, include the NOMISSINGGROUP option, which specifies that missing values of the group variable are not included in the plot.