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
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.
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.