Data visualization with SAS programming

Adding missing values in the legend when using heatmap

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Adding missing values in the legend when using heatmap

Hi,

 

I am using the Template and the Sgrender procedures to create a heatmap graphic. I have some missing values in my data, and I use the white color to see them. I would like to add this color next to the heatmap legend so other people would know that white=missing, but I did not find a way to do this.

 

If anyone has an idea, I would really appreciate it.

 

Thanks!


Accepted Solutions
Solution
‎08-11-2016 09:50 AM
SAS Super FREQ
Posts: 3,234

Re: Adding missing values in the legend when using heatmap

[ Edited ]

I haven't done this myself, but look at the LEGENDITEM statement.  The example at the end looks like you ought to be able to do something like this (untested):

 

legenditem type=marker name="missingVal" / markerattrs=(color=white symbol=squarefilled size=14)

                  label="Missing Value";

 

Then use a DISCRETELEGEND statement inside the LAYOUT OVERLAY to place the missing value swatch where you want it.

 

Of course, the simpler way is to use TITLE2 or FOOTNOTE  :-)

footnote "The color white represents a missing value";

 

 

 

 

View solution in original post


All Replies
Solution
‎08-11-2016 09:50 AM
SAS Super FREQ
Posts: 3,234

Re: Adding missing values in the legend when using heatmap

[ Edited ]

I haven't done this myself, but look at the LEGENDITEM statement.  The example at the end looks like you ought to be able to do something like this (untested):

 

legenditem type=marker name="missingVal" / markerattrs=(color=white symbol=squarefilled size=14)

                  label="Missing Value";

 

Then use a DISCRETELEGEND statement inside the LAYOUT OVERLAY to place the missing value swatch where you want it.

 

Of course, the simpler way is to use TITLE2 or FOOTNOTE  :-)

footnote "The color white represents a missing value";

 

 

 

 

Occasional Contributor
Posts: 11

Re: Adding missing values in the legend when using heatmap

Yes it's working fine. I just had to add a slash before "markerattrs".

 

Thanks and have a great day !

SAS Super FREQ
Posts: 3,234

Re: Adding missing values in the legend when using heatmap

Ah, yes. Sorry. I editted my response to fix that error, in case someone else searches for your question and finds this page.

Post a Question
Discussion Stats
  • 3 replies
  • 196 views
  • 0 likes
  • 2 in conversation