05-08-2012 02:30 PM
It has nothing to do with SAS. 256 is the limit of Excel before 2007 version. Before 2007, the column limit is 256, and the row limit is 16k; while after 2007, the column limit is 64k and the row limit is 1M.
05-08-2012 04:11 PM
The problem is not with Excel, it is with the library used to access it (JET or ACE). For a somewhat clunky workaround, look at the split255 macro described here :
05-17-2012 06:05 PM
05-17-2012 06:31 PM
I'm confused. You said that a csv file would suffice. The following, using 9.2 on Windows, creates a 1002 column file that opens in Excel 2010 without any problem:
do i=1 to 100;
do j=1 to 1000;
proc export data=work.test
06-21-2012 10:14 AM
I also downloaded the SAS Addin called: Export to Microsoft Excel 2007/2010 from the SAS website. It's working great but it's like a Wizard. It doesn't produce code you can use in batch. And it will only Export to a Windows environment so if you have a large file, it takes a bit. Have a great day..