When it runs I get the following error in the log:
282 /*Export data to an excel file*/
283 PROC EXPORT
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?
On the rock bound coast of Maine
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.
Product expiration dates:
---Base Product 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
> I am using SAS Enterprise Guide 4.3 on SAS 9.2 and am
> having a problem with the following code snippit
> PROC EXPORT
> OUTFILE= "S:\EDPeds.XLS"
> DBMS=EXCEL2000 REPLACE;
> 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?
> Dick Shryock
> On the rock bound coast of Maine