Help using Base SAS procedures

Proc export problem?

Reply
Super Contributor
Posts: 338

Proc export problem?

Hi SAS Forum,

I tried to export a SAS output file using the below code.

PROC EXPORT DATA=work.ABC

OUTFILE="\\abcde-j9-sas01\llk\Income.xlsx"

DBMS=XLS REPLACE;

sheet = "sheet3";

PUTNAMES=YES;

run;

Question:

It gives the following error messege. Could you please help me to identify what is the wrong with the code?

File is not OLE2

Requested Input File Is Invalid

ERROR: Export unsuccessful.  See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

Thank you very much

Mirisage

Trusted Advisor
Posts: 2,113

Re: Proc export problem?

Try using the EXCEL engine; XLS only supports through Excel 2003.  See the documentation for SAS/Access for PC FIle Formats.

Ask a Question
Discussion stats
  • 1 reply
  • 278 views
  • 3 likes
  • 2 in conversation