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. 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;
SAS Import Wizard is not that reliable, even when converting an .xlsx to .xls (93-2000 version). For example, columns with mixed types are often improporely read into SAS, such that missing data occurs. Consider a column with a majority of 3 digit numeric values and a small number of values having leading zeros. Those latter values are missed by the Import Wizard and converted to missing values (null).
Even changing the INFORMAT while in the Wizard does not always work and the blanks occur. (E.g. try this with ICD-9 or DRG codes.)
I get consistent and accurate imported products with the fewest problems when I first convert the native Excel file to a .csv file. Next. I'll import the .csv file into SAS. .csv files import quite easily if you are using R.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.