Unable to assign custom range attribute map in SAS heatmap plot

dubyamick

Below is my SAS code. I am trying to create a custom color gradient for a heat map. However, I can't get it to work. Any thoughts on why I'm recieving this error (warning)?

WARNING: Range Attribute Map 'myID' could not be found to extract colour map. Will revert tothree-colour map

Code:

data myrattrmap;
retain id "myID" name "myID";
length min $ 5 max $ 5;
input min $ max $ color $ altcolor $;
datalines;
min -1 purple purple
-1 1 gold gold
1 max green green
;
run;

proc sgpanel data=graph_data() rattrmap=myrattrmap;
heatmapparm x=patient_age_group y=patient_gender colorresponse=col1 / rattrid=myID;
panelby NAME;
gradlegend / title="Lift" position=bottom;
label NAME="SOURCE";
run;

Nicholas_21406

Hi @dubyamick ,

This sort of question probably requires you to file a Support ticket, which you can do by visiting support.altair.com so that we can get a copy of your data, and have a screensharing session with you. I'm not an expert on SAS, but I do have a short response from a SAS expert:

"The reason they are getting that WARNING: Range Attribute Map 'myID' could not be found to extract colour map. Will revert tothree-colour map is because of their definition of the myrattrmap data. While min and max columns are character variables they are expected to define a numeric range such as -99 -1 not min -1. 'min' and 'max' string values cannot be turned into numeric, whereas the range -1 1 can."