Help using Base SAS procedures

Export Errors

Reply
Contributor
Posts: 42

Export Errors

Good Afternoon Everyone,

I am attempting to export data to an Excel spreadsheet, however upon doing so the following error is posted to the log. Does anyone know how this can be solved? It did work yesterday.

Thank you.

957 Proc Export Data = SevProdSum
958 Outfile = '\\int\GroupData\RACQI\claims\mra\Dev\output\eventforecast\EventExperience TEMPLATE 3 Tier Sample.xls'
959 DBMS = Excel
960 Replace;
961 Sheet = Severity_Cat;
962 Run;

1 The SAS System 12:26 Friday, October 3, 2008

ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: Too many fields defined..

WARNING: File deletion failed for _IMEX_.SEVERITY_CAT.DATA.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.32 seconds
cpu time 0.09 seconds

ERROR: Export unsuccessful. See SAS Log for details.
Super User
Posts: 5,260

Re: Export Errors

When encountering this type errors/messages, I suggest that you first do a search on support.sas.com before you are entering a post.

If you have less columns than 256 in your SAS table, your problem is probably this:

http://support.sas.com/kb/13/891.html

If not, you should open a track to SAS tech support.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 829 views
  • 0 likes
  • 2 in conversation