Import and export to same file.

deleted_user — Wed, 14 Oct 2009 19:55:28 GMT

Hi,
I'm trying to Import an excel file process it and export to the same file. When I try doing this I get this following error. Can SAS handle this?

WARNING: File _IMEX_.'Sheet1$$'n.DATA does not exist.
WARNING: Table _IMEX_."Sheet1$$" has not been dropped.
ERROR: The MS Excel table Sheet1$ has been opened for OUTPUT. This table already exists, or there is
a name conflict with an existing object. This table will not be replaced. This engine does not
support the REPLACE option.
ERROR: Export unsuccessful. See SAS Log for details.

My code:
PROC IMPORT OUT= WORK.EXTRACTMASTER
DATAFILE= "V:\LifeMaster\2009-05TestNS\RawData\ExtractMaster.xls"
DBMS=EXCEL REPLACE;
SHEET="Sheet1$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

Proc export data = work.updated_excel
outfile = "V:\LifeMaster\2009-05TestNS\RawData\ExtractMaster.xls"
dbms = excel
replace;
SHEET="Sheet1$";
run;

Re: Import and export to same file.

ChrisNZ — Wed, 14 Oct 2009 20:31:24 GMT

Try using a stylesheet name without the $ sign to export.

topic Import and export to same file. in SAS Procedures

Import and export to same file.

Re: Import and export to same file.