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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.