Hello, I am creating a report using proc tabulate in SAS Studio 9.4. Below is the sample code that I run: DATA EXAMPLE;
INPUT LOCK $3. MONTH_TYPE $ LEVEL $ CHANNEL $ PPL;
DATALINES;
May Type1 lvl1 chn1 200
May Type1 lvl1 chn1 30
May Type2 lvl1 chn1 4
May Type2 lvl1 chn1 45
Jun Type1 lvl1 chn1 67
Jun Type1 lvl1 chn1 1
Jun Type2 lvl1 chn1 6
Jun Type2 lvl1 chn1 8
May Type1 lvl1 chn2 76
May Type1 lvl1 chn2 45
May Type2 lvl1 chn2 90
May Type2 lvl1 chn2 76
Jun Type1 lvl1 chn2 56
Jun Type1 lvl1 chn2 67
Jun Type2 lvl1 chn2 90
Jun Type2 lvl1 chn2 43
May Type1 lvl2 chn1 66
May Type1 lvl2 chn1 55
May Type2 lvl2 chn1 33
May Type2 lvl2 chn1 22
Jun Type1 lvl2 chn1 34
Jun Type1 lvl2 chn1 23
Jun Type2 lvl2 chn1 76
Jun Type2 lvl2 chn1 87
May Type1 lvl2 chn2 100
May Type1 lvl2 chn2 56
May Type2 lvl2 chn2 13
May Type2 lvl2 chn2 27
Jun Type1 lvl2 chn2 26
Jun Type1 lvl2 chn2 45
Jun Type2 lvl2 chn2 87
Jun Type2 lvl2 chn2 91
;
RUN;
PROC FORMAT;
VALUE $CHANNELfmt
'chn1'='Channel1'
'chn2'='Channel2'
;
VALUE $CHANNELcolor
'chn1'='White'
'chn2' = 'GWH'
;
RUN;
/* ODS EXCEL FILE="....example.xlsx" */
/* */
/* OPTIONS */
/* ( */
/* ABSOLUTE_COLUMN_WIDTH='15' */
/* ABSOLUTE_ROW_HEIGHT='20' */
/* SHEET_INTERVAL="NONE" */
/* SHEET_LABEL="Test" */
/* ); */
PROC TABULATE DATA=EXAMPLE S=[JUST=C VJUST=C TAGATTR="WRAP:NO"];
CLASS MONTH_TYPE LOCK LEVEL CHANNEL;
CLASSLEV MONTH_TYPE/STYLE=[FONT_STYLE=ITALIC JUST=R VJUST=C FONT_FACE='Arial' TAGATTR="WRAP:NO"];
CLASSLEV LEVEL/STYLE=[BACKGROUND=LILG JUST=C VJUST=C FONTSIZE=3.7 FONT_FACE='Arial' TAGATTR="WRAP:NO"];
CLASSLEV LOCK/STYLE=[JUST=C VJUST=C FONTSIZE=3 FONT_FACE='Arial' TAGATTR="WRAP:NO" BACKGROUND=YWH];
CLASSLEV CHANNEL/STYLE=[JUST=C VJUST=C FONTSIZE=3.5 FONT_FACE='Arial' BACKGROUND=$CHANNELcolor. TAGATTR="WRAP:NO"];
FORMAT CHANNEL $CHANNELfmt. LEVEL $LEVEL.;
VAR PPL/STYLE=<PARENT>;
TABLE
MONTH_TYPE=''*LOCK='',
LEVEL=''*CHANNEL=''*PPL='' *F=COMMA10.*[STYLE=<PARENT>[FONTSIZE=2 FONT_FACE='Arial' TAGATTR="WRAP:NO"]]
/RTS=25 ROW=FLOAT
BOX=[LABEL="Test" STYLE=[FONTSIZE=3.7 FONT_FACE='Arial' BACKGROUND=BIGB FOREGROUND=WHITE TAGATTR="WRAP:NO"]];
KEYLABEL SUM=' ';
KEYWORD SUM/STYLE=<PARENT>;
RUN;
/* ODS EXCEL CLOSE; */
I commented out excel output portion of it but it works well and I get Excel file. I want to have thick borders around class variable level. In other words I get: And I would like to have this: It does not have to be red, I want to have a more readable report that separates lvl1 and lvl2 with thicker borders. Can anyone help? Thank you, Regina.
... View more
