topic how to export large-scale SAS tables to excel? in Microsoft Integration with SAS

how to export large-scale SAS tables to excel?

marzieh — Mon, 05 Mar 2012 06:02:01 GMT

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

how to export large-scale SAS tables to excel?

Cynthia_sas — Mon, 05 Mar 2012 19:33:26 GMT

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

how to export large-scale SAS tables to excel?

marzieh — Tue, 06 Mar 2012 05:07:24 GMT

Thanks Cynthia