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-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 2528 views
  • 0 likes
  • 2 in conversation