topic Re: PROC EXPORT to Excel problem in SAS Procedures

PROC EXPORT to Excel problem

Dick_Shryock — Wed, 15 Jun 2011 19:37:24 GMT

I am using SAS Enterprise Guide 4.3 on SAS 9.2 and am having a problem with the following code snippit

PROC EXPORT
DATA=WORK.EDPEDS
OUTFILE= "S:\EDPeds.XLS"
DBMS=EXCEL2000 REPLACE;
NEWFILE=YES;
sheet="ED";
run;

When it runs I get the following error in the log:
282 /*Export data to an excel file*/
283 PROC EXPORT
284 DATA=WORK.EDPEDS
285 OUTFILE= "S:\EDPeds.XLS"
286 DBMS=EXCEL2000 REPLACE;
ERROR: DBMS type EXCEL2000 not valid for export.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Can someone point me in the right direction?

Thanks,
Dick Shryock
On the rock bound coast of Maine

Re: PROC EXPORT to Excel problem

DF — Wed, 15 Jun 2011 19:57:08 GMT

I believe that means your computer doesn't have the correct license to output Excel files.

I have a similar issue at work with this as our remote server runs on a HP-UX box, and does not have the licences for outputting to Excel. I can however use the built-in EG export to save to an excel file, but that of course means you can't use macro automation for file names and such.

You should be able to see the available products/licenses by running the below. It could be you have an alternative excel licence that would work.

proc setinit noalias;
run;

Re: PROC EXPORT to Excel problem

Dick_Shryock — Wed, 15 Jun 2011 20:24:17 GMT

Thanks So I ran the code and got this:

Product expiration dates:
---Base Product 30DEC2011
---SAS/STAT 30DEC2011
---SAS/GRAPH 30DEC2011
---SAS/ETS 30DEC2011
---SAS/QC 30DEC2011
---SAS/SHARE 30DEC2011
---SAS/CONNECT 30DEC2011
---SAS/SHARE*NET 30DEC2011
---SAS OLAP Server 30DEC2011
---MDDB Server common products 30DEC2011
---SAS Integration Technologies 30DEC2011
---SAS Strategic Performance Management 30DEC2011
---SAS High-Performance Forecasting 30DEC2011
---SAS Solutions Server Components 30DEC2011
---SAS/ACCESS Interface to PC Files 30DEC2011
---SAS/ACCESS Interface to OLE DB 30DEC2011
---SAS/ACCESS Interface to MYSQL 30DEC2011
---SAS Metadata Bridges for General Industry Standards 30DEC2011
---SAS Workspace Server for Local Access 30DEC2011
---SAS Workspace Server for Enterprise Access 30DEC2011
---SAS Table Server 30DEC2011

What am I looking for?

Re: PROC EXPORT to Excel problem

art297 — Wed, 15 Jun 2011 22:23:18 GMT

You have the right licenses. Does your SAS server happen to be a 64-bit machine?

Art

Re: PROC EXPORT to Excel problem

Reeza — Wed, 15 Jun 2011 22:53:17 GMT

Can you export with the libname statement or do you get an error?

libname test excel "s:\EDPeds.xls"

data test.ed;
set edpeds;
run;

libname test;

Re: PROC EXPORT to Excel problem

Ksharp — Thu, 16 Jun 2011 06:42:07 GMT

Did you try
DBMS=EXCEL

Ksharp

Re: PROC EXPORT to Excel problem

Dick_Shryock — Thu, 16 Jun 2011 10:24:38 GMT

Yes the server is 64 Bit the clients are 32bit.

-d

Re: PROC EXPORT to Excel problem

Dick_Shryock — Thu, 16 Jun 2011 10:26:53 GMT

Yes and all of the iterations 2000, 2003, 2007...

Re: PROC EXPORT to Excel problem

Dick_Shryock — Thu, 16 Jun 2011 10:37:10 GMT

It fails on the LIBNAME:
32 libname test excel "s:\EDPeds.xls"
33
34
35 GOPTIONS NOACCESSIBLE;
ERROR: The EXCEL engine cannot be found.
ERROR: Error in the LIBNAME statement.

Re: PROC EXPORT to Excel problem

art297 — Thu, 16 Jun 2011 14:47:30 GMT

Dick,

Since the server is using the 64-bit version, your choices are limited to XLS and EXCELCS, or also loading the 32-bit version. Take a look at: http://support.sas.com/kb/33/228.html

HTH,
Art
-------
> I am using SAS Enterprise Guide 4.3 on SAS 9.2 and am
> having a problem with the following code snippit
>
> PROC EXPORT
> DATA=WORK.EDPEDS
> OUTFILE= "S:\EDPeds.XLS"
> DBMS=EXCEL2000 REPLACE;
> NEWFILE=YES;
> et="ED";
> run;
>
> When it runs I get the following error in the log:
> 282 /*Export data to an excel file*/
> 283 PROC EXPORT
> 284 DATA=WORK.EDPEDS
> 285 OUTFILE= "S:\EDPeds.XLS"
> 286 DBMS=EXCEL2000 REPLACE;
> ERROR: DBMS type EXCEL2000 not valid for export.
> NOTE: The SAS System stopped processing this step
> because of errors.
> NOTE: PROCEDURE EXPORT used (Total process time):
> real time 0.00 seconds
> cpu time 0.00 seconds
>
>
> Can someone point me in the right direction?
>
> Thanks,
> Dick Shryock
> On the rock bound coast of Maine

Re: PROC EXPORT to Excel problem

Dick_Shryock — Thu, 16 Jun 2011 15:00:07 GMT

Thanks Art the Excelcs worked thanks for your help

=d

Re: PROC EXPORT to Excel problem

yyAjax — Wed, 26 Jun 2013 22:07:25 GMT

Thank you. This worked finally.

Re: PROC EXPORT to Excel problem

kmel56 — Mon, 08 Jul 2013 16:04:56 GMT

Hi everybody,

For the same problem, howabout if i don't have Access Interface To PC File Licence?

Thanks.

Re: PROC EXPORT to Excel problem

Reeza — Mon, 08 Jul 2013 16:10:02 GMT

You should post this as a new question.

Are you using EG? SAS Base, what version?

Re: PROC EXPORT to Excel problem

kmel56 — Mon, 08 Jul 2013 16:15:25 GMT

Yes I'm working on EG 5.1, the machie is a SAS 9.3 version

Re: PROC EXPORT to Excel problem

SASKiwi — Mon, 08 Jul 2013 20:29:16 GMT

You can PROC EXPORT to CSV (DBMS = CSV) if you don't have SAS/ACCESS to PC Files licensed, then open the file in Excel and do a File Save As to save in Excel format.

Re: PROC EXPORT to Excel problem

kmel56 — Tue, 09 Jul 2013 08:54:04 GMT

Thanks a lot it works with CSV

Re: PROC EXPORT to Excel problem

FatihAkici — Mon, 02 Nov 2015 15:35:30 GMT

I think this is a duplicate of this thread: https://communities.sas.com/t5/SAS-Procedures/Problem-with-PROC-EXPORT/td-p/88349 and since I am new to this forum, I don't know how to link my answer directly. So I'll just copy and paste my answer into here.

I know this is an old thread, but I just encountered this problem myself, and solved the following way. Actually two ways.

1) Forget about Excel, just export into CSV. (This is what I always did with Python, always easier.)

PROC EXPORT DATA=last

OUTFILE='/home/data.csv'

DBMS=CSV REPLACE;

PUTNAMES = YES;

RUN;

2) If you insist on Excel, here you go:

PROC EXPORT DATA=last

OUTFILE='/home/data.xls'

DBMS=EXCEL5 REPLACE;

RUN;

Long story short, EXCEL5 is the key. Hope this helps.