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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1410 views
  • 0 likes
  • 2 in conversation