Help using Base SAS procedures

PROC EXPORT to Excel problem

Reply
Contributor
Posts: 25

PROC EXPORT to Excel problem

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
Frequent Contributor
Frequent Contributor
Posts: 94

Re: PROC EXPORT to Excel problem

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;
Contributor
Posts: 25

Re: PROC EXPORT to Excel problem

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?
PROC Star
Posts: 7,362

Re: PROC EXPORT to Excel problem

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

Art
Contributor
Posts: 25

Re: PROC EXPORT to Excel problem

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

-d
Super User
Posts: 17,785

Re: PROC EXPORT to Excel problem

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;
Contributor
Posts: 25

Re: PROC EXPORT to Excel problem

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.
Super User
Posts: 9,676

Re: PROC EXPORT to Excel problem

Did you try
DBMS=EXCEL


Ksharp
Contributor
Posts: 25

Re: PROC EXPORT to Excel problem

Yes and all of the iterations 2000, 2003, 2007...
N/A
Posts: 1

Re: PROC EXPORT to Excel problem

Thank you. This worked finally.

PROC Star
Posts: 7,362

Re: PROC EXPORT to Excel problem

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
Contributor
Posts: 25

Re: PROC EXPORT to Excel problem

Thanks Art the Excelcs worked thanks for your help

=d
Contributor
Posts: 33

Re: PROC EXPORT to Excel problem

Hi everybody,

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

Thanks.

Super User
Posts: 17,785

Re: PROC EXPORT to Excel problem

You should post this as a new question.

Are you using EG? SAS Base, what version?

Contributor
Posts: 33

Re: PROC EXPORT to Excel problem

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

Ask a Question
Discussion stats
  • 17 replies
  • 14472 views
  • 1 like
  • 9 in conversation