If add define x / style=[Asis=on]; the space issue can be fixed. Thanks ... View more

Got it. Thanks ... View more

Tom,         Great. Understand now.   Thanks George ... View more

  Below is my code based on the above link method. This works well, but not best.   proc report data=a nocompletecols; column gr _gr trt visno, (param, value); define gr / group noprint; define trt / group; define visno / across; define param / across; define _gr/ computed; compute before gr; temp=gr; endcomp; compute _gr / character length=8; _gr=temp; endcomp; run;   ... View more

Hi All, Sometimes there are some ways to get the same goal, I Will show you other way to get It. You can use a new library to Excel file with LIBNAME MyExcel XLSX "path\name.xlsx"; Then if you have a dataset named "Wombat", you only must to do a data step DATA MyExcel.Wombat; SET Work.Wombat; RUN; And you can append all sheets that you need with only a data step. If you any ods in excel, you could merge all in an only Excel file with Excel libraries Finally you must disconnect all Excel file with. LIBNAME MyExcel CLEAR; ... View more

Great Thanks ... View more

Thanks. Got it.   ... View more

proc sort data=sashelp.prdsale out=consumer; where division = 'CONSUMER'; by country region; run; proc report data=consumer;   title '1) testing absolute columns for ACROSS items';   column country region,prodtype,actual;   define country / group;   define region / across;   define prodtype / across;   define actual / sum;   compute actual;     if _c2_ gt 25000 then        call define ('_c2_','style','style={background=lightyellow');     if _c4_ gt 25000 then        call define ('_c4_','style','style={background=lightgreen');   endcomp; run; proc report data=consumer;   column country region,prodtype,actual;   title '2) also testing country value for highlight';   define country / group;   define region / across;   define prodtype / across;   define actual / sum;   compute actual;     if _c2_ gt 25000 then        call define ('_c2_','style','style={background=lightyellow');     if _c4_ gt 25000 then        call define ('_c4_','style','style={background=lightgreen');     if country = 'CANADA' and _c4_ lt 25000 then        call define ('_c4_','style','style={background=lightred');   endcomp; run; ... View more

Got it. ... View more