DATA Step, Macro, Functions and more

Export SAS 9.4 (64 bit) into Excel

Reply
Occasional Contributor
Posts: 12

Export SAS 9.4 (64 bit) into Excel

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.

 

Super User
Super User
Posts: 7,392

Re: Export SAS 9.4 (64 bit) into Excel

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.

Respected Advisor
Posts: 3,887

Re: Export SAS 9.4 (64 bit) into Excel

[ Edited ]

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;

 

Ask a Question
Discussion stats
  • 2 replies
  • 193 views
  • 0 likes
  • 3 in conversation