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

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
  • 1 reply
  • 2677 views
  • 0 likes
  • 2 in conversation