Dear all, I am using SAS University Edition, trying to export charts and graphs to multiple sheets on an excel file called "Final_Report_2013.xlsx". On the first try of creating a single sheet, then again for 2 sheets, it worked fine, but later when I am tried for the complete report I get the message: NOTE: Writing EXCEL file: /folders/myfolders/Final_Report_2013.xlsx
ERROR: ZIP entry duplicate name: xl/media/SGPlot.png. Initially I thought since that file already exists, hence 'duplicate name', but even after deleting it, or changing the new file name, I get the same error. Below I have keyed in the initial part of the code: ods excel file= "/folders/myfolders/Final_Report_2013.xlsx" options (sheet_name = "Change in Price across Months");
ods graphics / reset width=8.0in height=6.0in imagemap;
proc sgplot data=WORK.PRICE_VS_MONTHS;
title "Variation of Laptop Configuration Prices Over Time";
vline month / response=retail_price group=configuration curvelabel stat=mean;
yaxis grid;
run;
ods graphics / reset;
ods excel options (sheet_name = "Variance in price of Laptops across Months");
title 'Variance in price of Laptops across Months';
title " Configuration = 12"; /* Key in the configuration as above */
proc sgplot data=sample_product;
vbar Month / response= Retail_Price
barwidth=1.0 fillattrs=graphdata2;
run; . . . . . . . .
ods excel close; Can someone help me out on this Please?
... View more