Hi:
One possible workaround is to make a category variable that contains the value and the variable name, that forces the variable name (Q01a or Q01b) in each cell -- which still may not be optimal, but will allow you to get rid of the "double wide" cell.
cynthia
[pre]
data test;
length Q01a Q01b $10;
input division Q01aclass Q01bclass;
Q01a = 'Q01a: '||put(q01aclass,1.0);
Q01b = 'Q01b: '||put(q01bclass,1.0);
output test;
return;
datalines;
1 1 1
1 2 1
1 3 1
1 1 2
2 3 1
2 1 3
1 2 2
3 2 1
3 1 1
3 3 3
;
run;
Ods tagsets.ExcelXp file="C:\temp\test.xls";
proc tabulate data=test ;
class division Q01a Q01b ;
table N='Base' colpctn='Column Percent Total' N*(Q01a=' ' Q01b=' ')
(colpctn='Column Percent')*(Q01a=' ' Q01b=' '),
all='Total' division / row=float;
run;
Ods tagsets.ExcelXp close;
[/pre]