Export SAS 9.4 (64 bit) into Excel

[ImPrasad]

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.

[RW9]

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.

[Patrick]

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;