Hi, We recently found that the skip_space option for ODS Excel is no longer recognised. Deleting the skip_space option causes all our proc tabulate outputs (about 20 per sheet) to write in the same excel worksheet. Are there any other options that can substitute the function of skip_space? Appreciate any help on this. An extract of the code below (there's about 20 proc tabulate macros per sheet and 6 sheets in total): * Sheet 1;
ODS Excel
FILE="&Directory.&Save_File..xlsx"
style=htmlblue
options(
start_at="A2"
sheet_interval='none'
sheet_name='All'
embedded_titles='yes'
zoom='80'
skip_space='1,0,0,0,0');
%proc tabulate macro(1);
%proc tabulate macro(2);
%proc tabulate macro(3);
* Sheet 2;
ODS Excel
style=htmlblue
options(
start_at="A2"
sheet_interval='none'
sheet_name='Small'
embedded_titles='yes'
skip_space='1,0,0,0,0');
%proc tabulate macro(1);
%proc tabulate macro(2);
%proc tabulate macro(3);
... View more