I'm using SAS 9.2 on a 32-bit machine and I'm trying to PROC EXPORT to an existing Excel 2007 file (or a new file for that matter). My co-workers are not having this issue, so there must be some kind of setting on my computer or in SAS that needs to be adjusted.
I've searched this forum as well as GOOGLED key words. I've tried a few things that I thought might work, but I'm stuck. Any help with this would be appreciated.
Here is the log when I try to overwrite the file:
5812 proc export data = FAM_DATA_1
5813 outfile = "&output\E-FAST_&file..xlsx"
5814 dbms = excel replace;
5815 run;
ERROR: Connect: External table is not in the expected format.
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.46 seconds
cpu time 0.23 seconds
This is what I get when I try to create a new *.xlsx file:
5816 proc export data = FAM_DATA_1
5817 outfile = "&output\test.xlsx"
5818 dbms = excel replace;
5819 run;
ERROR: Connect: Cannot update. Database or object is read-only.
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.34 seconds
cpu time 0.20 seconds
Thanks,
Scooter
... View more