topic Export SAS 9.4 (64 bit) into Excel in SAS Programming

Export SAS 9.4 (64 bit) into Excel

ImPrasad — Mon, 19 Oct 2015 06:02:38 GMT

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.

Re: Export SAS 9.4 (64 bit) into Excel

RW9 — Mon, 19 Oct 2015 08:36:27 GMT

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.

Re: Export SAS 9.4 (64 bit) into Excel

Patrick — Mon, 19 Oct 2015 08:42:16 GMT

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;