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;
s excel close;
od
Try Use option POSTTEXT= instead of footnote.
proc report data=Eval_Department5 nowd spanrows style(report)=[posttext='my footnote' ]
Thanks for your quick answer.
It also creates an extra row between my Data and the posttext.
compute block ?
compute after; line 'My footnote' ; endcomp;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.