Desktop productivity for business analysts and programmers

Export into excel 2010

Reply
N/A
Posts: 0

Export into excel 2010

I have SAS EG 4.1 and excel 2010.
Is it possible to export SAS dataset into excel 2010 which has more than 65k rows?. I tried to export SAS data with 80k rows, however am getting an error message - "An error ocurred saving the file. Spreadsheet is full." Any suggestions? Thanks.
Super Contributor
Posts: 356

Re: Export into excel 2010

I would check with Tech support, but would suspect 4.1 is not supported/compatable with office2010 products.

Barry
Contributor
Posts: 53

Re: Export into excel 2010

EG 4.1 will only export to an .xls file, not the .xlsx format used by Excel 2007 and 2010 that allow more than 65k rows. I suggest you export to a .csv file which will export fine and be utilized by Excel 2010.
Ask a Question
Discussion stats
  • 2 replies
  • 480 views
  • 0 likes
  • 3 in conversation