how to export large-scale SAS tables to excel?

[marzieh]

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

[Cynthia_sas · Accepted solution]

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

[marzieh]

Thanks Cynthia