topic Re: Memo Field in First Row of Excel Export? in SAS Programming

Memo Field in First Row of Excel Export?

shellp55 — Tue, 10 Nov 2020 18:28:40 GMT

Hello

I am using ods Excel to export multiple worksheets to an Excel document. Below is the code I am currently using, and it is working well.

ods Excel file=&dad_export_file options(sheet_name="Incons_Demo" Absolute_Column_Width='12,8,8,14,8,12' tab_color="#FABF8F");
proc print data=demo_2f noobs style(Data)=[just=left] style(Header)=[just=center];
var chartno sex bdate HCN_NoVC acctno disdate;
format HCN_NoVC $12. chartno $12. acctno $12.;
run; quit;

ods Excel close;

What I would like is to have the first row, merged to be the width of all 6 columns above, so I can add narrative about what is showing on the report. Is that possible? Thanks.

Re: Memo Field in First Row of Excel Export?

Reeza — Tue, 10 Nov 2020 20:37:02 GMT

ODS TEXT statement is a good option or use PROC REPORT with a data set with a specific value that is printed before the PRINT.

Re: Memo Field in First Row of Excel Export?

shellp55 — Tue, 10 Nov 2020 21:10:38 GMT

Thanks Reeza, but I'm not understanding what you mean. Where would this statement go in relation to the code I provided? Thanks so much.