SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

how to export large-scale SAS tables to excel?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

how to export large-scale SAS tables to excel?

Hi All

I have a table with approximately 500 fields and 500000 records and I want to export it to excel, but when I used 'proc export' the following error occurred:

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

Is there any way to export large-scale tables to excel sheets?

Thanks


Accepted Solutions
Solution
‎03-05-2012 02:33 PM
SAS Super FREQ
Posts: 8,645

how to export large-scale SAS tables to excel?

Hi:

  These Tech Support notes might be relevant, depending on your version of SAS and your version of Microsoft Office:

http://support.sas.com/kb/17/879.html

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

http://support.sas.com/kb/34/119.html

  You might consider opening a track with Tech Support on this issue. To open a track with Tech Support, fill out the form at this link:

http://support.sas.com/ctx/supportform/createFor

cynthia

View solution in original post


All Replies
Solution
‎03-05-2012 02:33 PM
SAS Super FREQ
Posts: 8,645

how to export large-scale SAS tables to excel?

Hi:

  These Tech Support notes might be relevant, depending on your version of SAS and your version of Microsoft Office:

http://support.sas.com/kb/17/879.html

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

http://support.sas.com/kb/34/119.html

  You might consider opening a track with Tech Support on this issue. To open a track with Tech Support, fill out the form at this link:

http://support.sas.com/ctx/supportform/createFor

cynthia

Occasional Contributor
Posts: 8

how to export large-scale SAS tables to excel?

Thanks Cynthia

Post a Question
Discussion Stats
  • 2 replies
  • 3798 views
  • 0 likes
  • 2 in conversation