BookmarkSubscribeRSS Feed
Dick_Shryock
Calcite | Level 5
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
17 REPLIES 17
DF
Fluorite | Level 6 DF
Fluorite | Level 6
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
Calcite | Level 5
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
Opal | Level 21
You have the right licenses. Does your SAS server happen to be a 64-bit machine?

Art
Dick_Shryock
Calcite | Level 5
Yes the server is 64 Bit the clients are 32bit.

-d
Reeza
Super User
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
Calcite | Level 5
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
Super User
Did you try
DBMS=EXCEL


Ksharp
Dick_Shryock
Calcite | Level 5
Yes and all of the iterations 2000, 2003, 2007...
yyAjax
Calcite | Level 5

Thank you. This worked finally.

art297
Opal | Level 21
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
Calcite | Level 5
Thanks Art the Excelcs worked thanks for your help

=d
kmel56
Calcite | Level 5

Hi everybody,

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

Thanks.

Reeza
Super User

You should post this as a new question.

Are you using EG? SAS Base, what version?

kmel56
Calcite | Level 5

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • 18829 views
  • 1 like
  • 9 in conversation