08-10-2016 09:28 AM
I am using base SAS 9.3 and have a dataset that I need to export to excel (xlsx extension because rows are > 65k). I want to include a footer on the exel output. Please advise how to add a footer to a xlsx file.
08-10-2016 03:32 PM
Since you are using 9.3 version of the SAS, you won't be able to use ODS excel to create .xlsx file. You can create .xls file using ODS tagsets.excelXP with a footnote.
ods _all_ close; ods tagsets.excelxp path = "path_here" file = "file_name.xls" style = XLsansPrinter options(embedded_footnotes = "yes"); footnote "Your footnote here"; proc print data=dataset_name noobs; run; ods tagsets.excelxp close;
08-10-2016 09:55 AM
You can put footnotes in, using footnote statement, however they will only appear in print preview in Excel - that is Excel functionality not SAS! If you want it in the grid - which is not Excel method - then add another row or two to your dataset, with the footnote you want, e.g.
(Col2 being the first variable in your dataset - assumed its called this, and that it is character).
It will then get printed per the data. Excel itself doesn't have titles/footnotes in the same way as RTF or PDF.