proc template shade cells with indices

haesol42 — Thu, 19 Oct 2023 17:49:06 GMT

Hello,

I am trying to make a report that that highlights some cells in a table.

I have a matrix (say IND) that contains column and row indices created in iml, and pass it to proc template routine to hightlight the cells that correspond to IND.

For example:

proc template;

define table CustomColor;

cellstyle

_COL_ = "want to place column index from IND" && _ROW_ = "want to place row index from IND" as {backgroundcolor=LightRed};

end;

run;

proc iml;

tbl = TableCreateFromDataSet("Sashelp", "Class");

IND = {2 3,

4 2

5 4};

/% this means that I want to hightlight the matrix elements indexed by (2,3), (4,2) and (5,4). And the matrix IND is not hard-coded in practice. %/

call TablePrint(tbl) numobs=6

template="CustomColor";

quit;

How can I write a program that template picks up the values defined in IND, and paint the cells properly?

Thank you.

Re: proc template shade cells with indices

Bari_sas — Thu, 16 Nov 2023 21:21:57 GMT

PROC TEMPLATE's CELLSTYLE AS can be helpful here, but you will need to code your ROW / COLUMN combinations in PROC TEMPLATE, not IML. Here's an example:

ods path work.template(update) sashelp.tmplmst;

proc template;
define table Checkerboard;
cellstyle _row_=2 && _col_=3 as data{backgroundcolor=yellow fontweight=bold },
_row_=4 && _col_=2 as data{backgroundcolor=yellow fontweight=bold },
_row_=5 && _col_=4 as data{backgroundcolor=yellow fontweight=bold },
1 as data;
end;
run;

ods trace on;
proc iml;
tbl = TableCreateFromDataSet("Sashelp", "Class");
IND = {2 3,
4 2,
5 4};
call TablePrint(tbl) numobs=6
template="Checkerboard"
;
quit;

Here are my results from SAS 9.4m8:

topic proc template shade cells with indices in ODS and Base Reporting

proc template shade cells with indices

Re: proc template shade cells with indices