Hello, I've been trying to figure out how to create a THICK Border around my groups. A,B, C and sub-categories which add up to the Characters Name. I've attached what the final product needs to look like. I've included the last compute statement that I came up with before asking for help. This is the code I am using: Proc Report data=Final_4SIMP out=Final_4SIMP_Table
nowindows nowd missing nocompletecols spanrows
style(report) =[borderwidth=2];
columns (SIMP_Order CIP_4SIMP Program_Order Program)
(Acad_Period, (Homer Marge Bart Lisa Maggie "Stupid Flanders"n) ) ;
define Cart_Order / group " " order = internal noprint;
define Cart_4SIMP / group " " order=internal
style(column)={tagattr='format:0000' vjust=m just=center }
;
define Program_Order / group " " order=internal noprint;
define Program / group " ";
define Acad_Period / across " " ;
define Homer / "Homer" format=comma10.0 style(column)=[tagattr='format:###,##0'] nozero;
define Marge / "Marge" format=comma10.0 style(column)=[tagattr='format:###,##0'] nozero;
define Bart / "Bart" format=comma10.0 style(column)=[tagattr='format:###,##0'] nozero;
define Lisa / "Lisa" format=comma10.0 style(column)=[tagattr='format:###,##0'] nozero;
define Maggie / "Maggie" format=comma10.0 style(column)=[tagattr='format:###,##0'] nozero;
define "Stupid Flanders"n / "Stupid Flanders" format=comma10.0 style(column)=[tagattr='format:###,##0'] nozero;
compute Program_Order ;
if Program_Order in (10, 11, 12, 13) then do;
call define(_row_,'style', 'STYLE={font_weight=bold BACKGROUND=cxD9D9D9}');
end;
endcomp;
compute Program;
if Program_Order in (2, 3, 4) then do;
call define(_col_,"style","style={indent=2}");
end;
endcomp;
compute CIP_4SIMP;
if CIP_4SIMP = ^. then do;
call define(_row_,'style','style={bordertopcolor=black bordertopwidth=2}');
end;
endcomp;
run;
... View more