I am using the exportToXL macro. However, the mergeacross option is not working. Excel pops up a 'Format Cell' dialoque box and wants me to manually merge the cells. I'm running Excel 2002 (soon to be 2007) and SAS 9.1.3. Does anyone have any suggestions? My program is below:
data title2;
format text $100.;
text = '^ICD-10 code: I00-I09, I11, I13, I20-I51';
run;
%let exroot = C:\Program Files\SAS\exportToXL;
%let outroot = C:\Documents and Settings\bubates\Desktop\Buddy;
options sasautos=( "&exroot" ) mautosource mcompilenote=all notes source source2;
%exportToXL(dsin=title2,
savepath=&outroot, savename=Heart_Disease,
tmplpath=&outroot, sheet=Town, tmplname=Heart_Disease,
wsformat=none, cell1row = 160 , cell1col = 1 , mergeacross = 7 , exportheaders=no,
endclose=no, exportvarfmts=no );