Dear All,
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
Syntax:
PROC EXPORT DATA=<Dataset>
OUTFILE = "E:\CONTACTIBILITY_PRAMOD\REPORTS\abc\SHEET3P_BRANCH_REGIONWISE_REPORT_FINAL.XLSX"
DBMS = EXCEL REPLACE;
SHEET = "&CAT";
RUN;
Log Mesage:
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.
Thanks,
Prasad Devasthali
Hdfc Bank.
Hi,
Look here:
https://communities.sas.com/t5/SAS-Procedures/Error-in-proc-export/td-p/82833
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.
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.