topic Re: exporttoXL: mergeacross not working in Microsoft Integration with SAS

exporttoXL: mergeacross not working

deleted_user — Wed, 29 Jul 2009 14:59:09 GMT

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 );

Re: exporttoXL: mergeacross not working

Cynthia_sas — Wed, 29 Jul 2009 17:04:21 GMT

Hi:
It looks from this paper (and others):
http://support.sas.com/resources/papers/proceedings09/023-2009.pdf

like the ExporttoXL macro is a user-written macro program that generates DDE calls. If you are following the guidelines outlined for usage in the macro documentation and are still having issues, your best bet for help may be to work with either the macro author or with Tech Support.

Since the macro is creating DDE calls, you might need to debug at the Excel/DDE end rather than the SAS end.

cynthia

Re: exporttoXL: mergeacross not working

deleted_user — Thu, 30 Jul 2009 18:26:21 GMT

Hi Cynthia,

Thanks for the response. I'm rather new at this, and am not sure where/how to start to debug excel. I'm hoping once we switch from Excel 2002 to Excel ver 2007 that perhaps that bug will work itself out.

Buddy