I'm using ODS EXCEL to export results produced by PROC FREQ to Excel. The output includes an empty row between the table title and the start of the table (see highlighted in yellow in Excel file). How can I delete that row in my SAS code?
Do I do this in the PROC TEMPLATE or in the ODS EXCEL statement?
Here's my sample code:
*Create sample dataset;
data test;
set sashelp.Class;
run;
*Create template;
proc template;
edit base.freq.onewaylist;
edit FVariable;
just=varjust;
style=rowheader;
header="Age at survey date";
end;
end;
run;
ods excel file="PATHNAME\test.xlsx"
options(sheet_name="Female"
embedded_titles="yes"
embed_titles_once="yes");
proc freq data = test(where=(sex="F"));
tables age;
title "Age at survey for female participants";
run;
ods excel close;
proc template;
delete base.freq.onewaylist;
run;
Thank you!