BookmarkSubscribeRSS Feed
Scottcom4
Calcite | Level 5
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.
1 REPLY 1
LinusH
Tourmaline | Level 20
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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2612 views
  • 0 likes
  • 2 in conversation