Is there a way to delete the empty row that generates between proc reports in an excel when using ods excel. I know you can use skip_space with ods tagset.excelxp, but I need an xlsx file. Thanks!!
Hi:
Are you generating with sheet_interval='none' as a sub-option? do you have titles turned on? Can you show an example of the code, including ODS statements that you're submitting? Are you using Statistical Procedures along with PROC REPORT? The usual behavior is for every separate PROC REPORT to start a new sheet in the workbook.
If this is a fairly standard number of rows in each PROC REPORT, then you can figure out which one of the rows you want to "hide" using a suboption, as shown below:
Cynthia
Check option 'start_at='.
https://blogs.sas.com/content/sgf/2017/02/20/tips-for-using-the-ods-excel-destination/
CODE UNTESTED ods excel file='c:\temp\temp.xlsx' options(sheet_interval='none'); proc print data=sashelp.class(obs=4); run; ods excel options(start_at="1,6"); proc print data=sashelp.heart(obs=10); run; ods excel close;
We can hide line 6 though not deleting.
ods excel file = "d:\temp.xlsx"
options(hidden_rows="6");
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.