10-19-2015 02:02 AM
We are facing an issue while exporting dataset to excel.Currently we are using Sas 9.4 version.Intel(R) Core(TM) i5 processor 64 bit .
Below is the synatx and error message displayed in log
PROC EXPORT DATA=<Dataset>
OUTFILE = "E:\CONTACTIBILITY_PRAMOD\REPORTS\abc\SHEET3P_BRANCH_REGIONWISE_REPORT_FINAL.XLSX"
DBMS = EXCEL REPLACE;
SHEET = "&CAT";
ERROR: DBMS type EXCEL not valid for export.
Same was working successfully when We were using 32 bit OS and Sas 9.2.
Please suggest a solution.
10-19-2015 04:36 AM
As a note, I would always avoid using Excel for anything. Even CSV, which is text based delimited file format (which Excel can parse) is preferable to using closed source proprietary unstrcutured mess which is Excel.
10-19-2015 04:40 AM - edited 10-19-2015 04:42 AM
Try XLSX instead. This engine still needs SAS/Access to PC Files licensed but it doesn't require the PC File Server.
PROC EXPORT DATA=sashelp.class OUTFILE = "c:\temp\test.XLSX" DBMS = xlsx REPLACE; SHEET = "class"; RUN;