SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

exporttoXL: mergeacross not working

Reply
N/A
Posts: 0

exporttoXL: mergeacross not working

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 );
SAS Super FREQ
Posts: 8,646

Re: exporttoXL: mergeacross not working

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
N/A
Posts: 0

Re: exporttoXL: mergeacross not working

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
Post a Question
Discussion Stats
  • 2 replies
  • 156 views
  • 0 likes
  • 2 in conversation