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