Hello,
Is it possible to remove the blank row that appears after output tables when using ODS EXCEL with the SHEET_INTERVAL='NONE' option?
In the ExcelXP tagset, there had been a SKIP_SPACE option to control this feature, but as documented in Chevell Parker's excellent "Ringside Seat" article (https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf), the SKIP_SPACE option is not available in ODS EXCEL.
Example code:
data test;
i = 1;
run;
ods _all_ close;
ods excel file="&OUTFILE"
options(
sheet_interval='none'
/*skip_space='0,0,0,0,0'*/ /* not supported in ODS Excel */
);
proc report data=test; run;
proc report data=test; run;
ods _all_ close;
Resulting Excel file:
Thanks,
Jake
... View more