LinusH's post had the answer--the second 'ODS excel options' statement needs sheet_interval set to "now".    ods excel file="ABC12.xlsx" options(sheet_name="Sh1" sheet_interval="none"); title 'Table1'; proc print data=sashelp.class(obs=3) noobs; run; title 'Table2'; proc print data=sashelp.shoes(obs=3) noobs; run; ods excel options(sheet_name="Sh2" sheet_interval="now"); /*This tells SAS to start a new sheet for next PROCs*/ proc print data=sashelp.cars(obs=5); run; title 'Table2'; proc print data=sashelp.shoes(obs=3) noobs; run; ods excel close; ... View more

When it's necessary to ensure that certain group levels are assigned the same fill color (or line type, or marker, etc.) then I might suggest using attribute maps. I use them frequently when I need to ensure that certain variables maintain a color scheme across different visualizations. This is not a detailed solution, but it should show the gist of how it works. The levels of "agec" will maintain their color scheme regardless of data sorting.  (This blog post has a good summary if you are not familiar with them: https://blogs.sas.com/content/graphicallyspeaking/2013/04/02/attribute-maps-1/) data attrmap; length ID $ 10 Value $ 30 fillcolor $ 10; infile datalines delimiter='|'; input ID Value fillcolor; datalines; agec|12|CXBE030E agec|13|CX03B1F0 agec|14|CXFFFF01 ; run; data class; set sashelp.class (where=(age=12)) sashelp.class (where=(age=14)) sashelp.class (where=(age=13)); agec=put(age,best.-l); run; proc sort data=class; by descending agec ; run; proc sgplot data=class dattrmap=attrmap; vbarbasic agec / response=height stat=mean group=agec attrid=agec; run; ... View more