08-17-2012 06:47 AM
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.
08-17-2012 08:26 AM
The answer is dependent upon which version of sas you are using, which operating system you're on, and whether you license SAS/Access for pc file formats.
I don't think dbms=xlsx is valid. try it with dbms=excel
08-17-2012 09:50 AM
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.
I hope this is a viable option for you.