topic Problem of replace an exist excel file in SAS Procedures

Problem of replace an exist excel file

Mike_Davis — Mon, 10 Sep 2012 22:01:42 GMT

Hello everyone,

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

RUN;

BUT this will not replace sheetone, it will create another sheet named sheetone1.

Please help!

Thanks

Mike

Re: Problem of replace an exist excel file

Cynthia_sas — Tue, 11 Sep 2012 03:06:43 GMT

Hi:

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.

from: http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p1d0tocg3njhmfn1d4ld2covlwm0.htm

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

cynthia

Re: Problem of replace an exist excel file

art297 — Tue, 11 Sep 2012 20:54:54 GMT

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.