topic Re: dattrmap not working in SAS Programming

dattrmap not working

Leo9 — Wed, 10 Mar 2021 19:38:58 GMT

Hi All,

I am trying to create a higlow graph. I want to color the bars with different colors based on the treatment subject received. For some reason this is not working as desired. I first created this dataset

data barcol ;

length id value fillcolor $50 ;

retain linecolor "black" ;

id = "coh"; value = "a" ; fillcolor = "red" ; output;

id = "coh"; value = "b" ; fillcolor = "green" ; output;

id = "coh"; value = "c" ; fillcolor = "orange" ; output;

run;

then I used this in proc sgplot statement

proc sgplot data=final noautolegend nocycleattrs dattrmap=barcol;

styleattrs wallcolor = lightyellow ;

highlow y=subj low=start high=end1 / highcap=acap group=coht type=bar nooutline nomissinggroup transparency=0.1 name = 'proj' attrid = coh ;

Any suggestions ?

Re: dattrmap not working

ballardw — Wed, 10 Mar 2021 20:12:40 GMT

What are the formatted values of the variable Coht?

If you have a default format for the variable that displays text other than 'a' 'b' 'c' then the values don't match.

Or if the actual values and no custom format is assigned then 'A' is not the same as the 'a' in the dattrmap data set.

Re: dattrmap not working

Leo9 — Wed, 10 Mar 2021 20:28:31 GMT

Thanks for your response. I realize the mistake I made. It seems that same variable has to be used in group and attrid (atleast with same value).