I'm running SAS 9.4 on a 64 bit PC (Windows 8.1 Pro).
Code I'm submitting:
proc export data=cluster_snapshot outfile="G:\Departments\Research\test scores\act\yr2.\State Test Reporting\reports\SCDE Release by School\20&yr2. ACT SCDE Release for Cluster Snapshots.xlsb"
dbms=excelcs replace;
run;
Error Message I'm getting:
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver]General error
Unable to open registry key Temporary (volatile) Ace DSN for process 0x1e54 Thread 0x1554
DBC 0x2c276c4 Excel'.
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 3.88 seconds
cpu time 0.20 seconds
I run proc export a lot and have never gotten this error.
Try DBMS=XLSX and using XLSX instead of xlsb?
I will note that I didn't get an error using SAS 9.4 TS1M3 (64 bit) on Windows 7 using your exact code.
1 proc export data=sashelp.class outfile="C:\_LOCALdata\temp\temp.xlsb"
2 dbms=excelcs replace;
3 run;
NOTE: "CLASS" range/sheet was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 4.78 seconds
cpu time 0.12 seconds
Try DBMS=XLSX and using XLSX instead of xlsb?
I will note that I didn't get an error using SAS 9.4 TS1M3 (64 bit) on Windows 7 using your exact code.
1 proc export data=sashelp.class outfile="C:\_LOCALdata\temp\temp.xlsb"
2 dbms=excelcs replace;
3 run;
NOTE: "CLASS" range/sheet was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 4.78 seconds
cpu time 0.12 seconds
Look at the bolded part of your code:
="G:\Departments\Research\test scores\act\yr2.\State Test Reporting\reports\SCDE Release by School\20&yr2. ACT SCDE Release for Cluster Snapshots.xlsb"
Is that first yr2. supposed to be the same &yr2. ?
the error is likely that the path you resolve to without the macro complains about the . in the path.
That macro variable was not a global variable. I fixed it and it works fine. Thanks!
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.