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.
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.