BookmarkSubscribeRSS Feed
MarcoHonig
Calcite | Level 5

 

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;


SAS ROW REMOVED.jpg
4 REPLIES 4
Ksharp
Super User

Try Use option POSTTEXT= instead of footnote.

 

 

proc report data=Eval_Department5 nowd spanrows style(report)=[posttext='my footnote' ]

MarcoHonig
Calcite | Level 5

Thanks for your quick answer. 

It also creates an extra row between my Data and the posttext.

Ksharp
Super User

compute block ?

 

compute after;

 line 'My footnote' ;

endcomp;
MarcoHonig
Calcite | Level 5
Same Problem. I guess it can be done with a proc template... But i did not find the right one yet

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1535 views
  • 0 likes
  • 2 in conversation