How do i remove the row between my Data and the Footnote in ODS EXCEL? Here is the code: ods excel
file="H:\DATA\Berechtigungsgruppen_nach_Department2.xls"
options(autofilter="1-2" embedded_titles="yes" embedded_footnotes="yes" frozen_headers="yes"
sheet_name="Analyse Departments" ) ;
title color=black height=12pt 'Berechtigungsgruppen je Deparment';
footnote color=black height=10pt 'Summierung nach Departments und Berechtigungsgruppen';
proc report data=Eval_Department5 nowd spanrows
style(header)=[background=#A4A4A4 font_size=9pt color=black just=left vjust=c]
style(column)=[font_size=8pt just=left];
define Department / order style(column)={vjust=c just=left};
*define Department / display style(column)=[cellwidth=80pt];
define Gruppe / display style(column)=[cellwidth=142pt];
define Anzahl /display style(column)=[cellwidth=53pt just=right];
define Anzahl/analysis sum;
compute after ;
Department ="Gesamt";
endcomp;
compute department;
if Department = 'Total' then
do;
department=department;
call define(_row_,'style','style={font_weight=bold font_size=8pt background=#A4A4A4 }');
end;
endcomp;
compute gruppe;
if gruppe = 'Gesamt' then
do;
gruppe=gruppe;
call define(_row_,'style','style={font_weight=bold font_size=8pt background=lightgrey }');
end;
endcomp;
run;
od s excel close;
... View more
