PROC SGPANEL how to avoid inconsistent colors by group?

[A_Kh]

Hello Community, 

My group values are not getting consistently colored across all groups. I found a similar topic with PROC SGPLOT where   @djrisks gave a solution using Discrete Attribute Maps method. I'm wondering if this technique works for SGPANEL as well or there are different ways to get consistent colors by group values.  

For clarity I used the below code (where 'yellow' represents  Cylinders=10  in SUV group and Cylinders=12  in Sports group. I need 'yellow' to represent only Cylinders=10). 

		proc sort data=sashelp.cars out=cars; by origin type; run; 

		proc freq data=cars;
			where cylinders in (4 5 6 8 10 12); 
			by origin;
			tables type*cylinders/out=have totpct outpct;
		run; 
		
		title 'SUV cars';
		proc SGPANEL data=have;
			where type eq "SUV";
			panelby origin;
			styleattrs datacolors=(blue red green yellow orange purple);
			vbar type / response=pct_row group=cylinders groupdisplay=stack;
			colaxis discreteorder=data valueattrs=(size=7pt) fitpolicy=rotate label="Cylinders";;
			rowaxis grid values=(0 to 100 by 10) label="Percent";
		run;

		title 'Sports cars';
		proc SGPANEL data=have;
			where type eq "Sports";
			panelby origin;
			styleattrs datacolors=(blue red green yellow orange purple);
			vbar type / response=pct_row group=cylinders groupdisplay=stack;
			colaxis discreteorder=data valueattrs=(size=7pt) fitpolicy=rotate label="Cylinders";;
			rowaxis grid values=(0 to 100 by 10) label="Percent";
		run;
		title; 

Any help much appreciated. 

Thank you!

[PaigeMiller]

Use discrete attribute maps.

https://www.lexjansen.com/sesug/2021/SESUG2021_Paper_77_Final_PDF.pdf

https://support.sas.com/resources/papers/proceedings19/3794-2019.pdf

[A_Kh]

Thank you for the quick reply and tips!
As documentation focused on SGPLOT procedure, I couldn't replicate it in my SGPANEL.. But appreciate sharing those info with me!!

[Ksharp · Accepted solution]

Or for your this special case. Try options SPARSE :
tables type*cylinders/out=have totpct outpct;

-->
tables type*cylinders/out=have totpct outpct sparse;

[A_Kh]

Thank you so much, it works perfectly!

And the most efficient way.