topic How to remove missing variable in legend. in Graphics Programming

How to remove missing variable in legend.

pearson101 — Tue, 12 Jan 2021 23:22:20 GMT

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?

Re: How to remove missing variable in legend.

pearson101 — Tue, 12 Jan 2021 23:31:42 GMT

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;

```

Re: How to remove missing variable in legend.

Reeza — Wed, 13 Jan 2021 00:24:20 GMT

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);

Re: How to remove missing variable in legend.

pearson101 — Wed, 13 Jan 2021 00:32:34 GMT

Thank you, would that go in the sgplot section?

Re: How to remove missing variable in legend.

Reeza — Wed, 13 Jan 2021 00:51:38 GMT

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

Re: How to remove missing variable in legend.

Rick_SAS — Wed, 13 Jan 2021 13:50:25 GMT

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