09-10-2012 06:01 PM
I have a problem of creating a new excel file from SAS and replace an exist excel file,
for example ,I have c:\temp\one.xls with a sheet named sheetone.
I want to update this excel file use SAS code:
PROC EXPORT DATA=sashelp.class
OUTFILE = "C:\Temp\one.xls"
DBMS = EXCEL2002 REPLACE;
SHEET = "sheetone";
BUT this will not replace sheetone, it will create another sheet named sheetone1.
09-10-2012 11:06 PM
You might want to work with Tech Support. I don't remember a DBMS= option named EXCEL2002. It looks in the doc, like the valid values are:
EXCEL, EXCEL4, EXCEL5, EXCELCS and XLS and that EXCEL covers all versions from 97 thru 2003.
So if you are having issues with your PROC EXPORT, you might work with Tech Support to figure out whether there are other issues at work (such as the 32-bit or 64-bit status of both SAS and Microsoft Office; the operating system (Windoes 7 or Windows XP) or the version of SAS you are using 9.2 versus 9.3 versus using SAS EG).
09-11-2012 04:54 PM
Mike: In answer to how to open a ticket with tech support: http://support.sas.com/ctx/supportform//createForm
Weren't there a number of other posts in this thread? If you delete a message you end up also deleting all of the responses to that message.