custom colours for stacked bar chart.

[Manj]

Hi 

I have the following code to create the attaced graph

proc template;

define statgraph bar100;

begingraph ;
layout overlay/ xaxisopts=(display=standard label=" "
discreteopts=(tickdisplaylist=(&xticks) tickvaluefitpolicy=split tickvaluesplitchar="~") )
yaxisopts=(display=standard label='Percentage of Patients' linearopts=(viewmin=0 viewmax=100 tickvaluesequence=(start=0 end=100 increment=10) viewmin=0 viewmax=100 tickvalueformat =pct.));
BARCHARTPARM X = avisn y=percent / group=avalx name="lgnd1" ;

discretelegend "lgnd1" /halign=right across=1 sortorder=DESCENDINGFORMATTED;

endlayout;

endgraph;
end;
run;
proc sgrender data=all template=bar100;
run;

My Query is how to make the custom colours for the stacks?

I tried using 

Begingraph //datacolors=(grey pink lightblue blue orange yellow lightred red lightgreen green black)

This gave me the colours i mentioned  but not as the way i wanted. This pics the colours based on the first xaxis value and so on.  I tried sorting data using my group variable avalx but that make the graph wrong.

My output without using the datacolours is below:

My intention is to give grey = 00  pink=02 lightblue=04  blue=08 orange=12 yellow=16 lightred=20 red=24 lightgreen=32 green=48 black=ND

[ballardw]

Have you considered using a DATTRMAP data set? The data set contains formatted values of your variable and appearance settings.

With SGRENDER

Requirements	Do either one of the following: specify the attribute map ID variable by using the DATTRVAR statement in the SGRENDER procedure. specify the attribute map ID variable using the DISCRETEATTRVAR variable in the StatGraph template. If neither of these requirements is met, the descriptions in the attribute map data set are ignored.
	The values in the DATTRMAP data set must be sorted by ID. If they are not, only the first value is found.

[Manj]

But I see these are for individual bars and not the stacks within each bars. It is a stacked bar chart .May be I'm missing something? 

[DanH_sas]

DATTRMAPS will work for your stacked bar chart as well, as the attribute mapping is tied to your GROUP values. See pages 9-14 in this paper for more information: https://support.sas.com/resources/papers/proceedings17/SAS0675-2017.pdf

Hope this helps!

Dan

[Manj]

Hi
Thanks for this. This works if I specify the colours. I found the below from the sas blogs. It says green to red. Quite unsure of this dynamic way of doing it. Im looking for colours from dark yellow--light yellow--red and I have about 12 stacks. The below code is working fro green to red. but im not sure how to alter this code for the scheme im looking for.

/*--Define attributes map data set--*/
data AttrMap;
length FillColor $8 LineColor $8;
id='Hist';
ghigh=192; /*--High value for Green--*/ ???? not sure of this number
rhigh=255; /*--High value for Red--*/ ???? not sure of this number

mid=(&minbin + &maxbin) / 2;
LineColor='CX000000';

do val=&minbin to &maxbin by &BinInt;
value=put(val, 5.0);
if val < mid then do;
g=ghigh; b=0; r=rhigh*(val-&minbin)/ (mid-&minbin);
end;
else do;
r=rhigh; b=0; g=ghigh*(1-((val-&minbin) - (mid-&minbin))/ (mid-&minbin)); ???? what is this calculation?
end;
fillcolor='CX' || put(r, hex2.) || put(g, hex2.) || put(b, hex2.); ???? what is this calculation?
output;
end;
run;