PROC EXPORT to Excel problem

[Dick_Shryock]

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

[DF]

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;

[Dick_Shryock]

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?

[art297]

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

Art

[Dick_Shryock]

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

-d

[Reeza]

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;

[Dick_Shryock]

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.

[Ksharp]

Did you try
DBMS=EXCEL


Ksharp

[Dick_Shryock]

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

[yyAjax]

Thank you. This worked finally.

[art297]

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

[Dick_Shryock]

Thanks Art the Excelcs worked thanks for your help

=d

[kmel56]

Hi everybody,

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

Thanks.

[Reeza]

You should post this as a new question.

Are you using EG? SAS Base, what version?

[kmel56]

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