I'm using the code that the online help provided. Just modify the output file path and name.
I have two proc tabulate and supposed to generate two sheets in one workbook. Instead, it always generate two separate workbook with name aedata and aedata1.
I'm using Macbook pro Bootcamp installing Window7-64bit. However my SAS version is 9.2 (32bit).
Can anybody find out what is the problem?
Thanks a lot!
The code is as following:
options center;
title; footnote;
ods listing close;
ods tagsets.ExcelXP path=' ' file='aedata.xml' style=default;
proc tabulate data=sashelp.shoes;
class region;
var sales;
table region, sales='Sales'
*format=dollar20.0*sum='';
run;
proc tabulate data=sashelp.retail;
class year;
var sales;
table year='', sales='Sales (in M$)' *
format=dollar20.0 * sum=''/box='Year';
run;
ods tagsets.ExcelXP close;
... View more