From SAS when we run the proc export procedure to export the data into MS-Excel 2010 version i.,e XLSX extension the spreadsheet created successfully. No error in the SAS log When I try to open the spread sheet its throwing me the pop-up like ‘’ "Excel Found Unredable Contents '..........xlsx' do you want to recover the contents of this workbook? If you trust the source of this work book click 'yes'” Even though if u click yes the data will not be there in the spreadsheet. SAS version is 9.3 SAS Procedure used to export the data: Proc export dbms=xlsx Data=a outfile ‘ b.xlsx’ replace Sheet=’’All’’; Run; Could you please anyone suggest me how can i fix this...?
... View more