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. |
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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.