I am using proc import to get xlsx file to SAS like this: PROC IMPORT OUT=work.W32HONJM DATAFILE="filename.xlsx" DBMS=XLSX Replace; GETNAMES=YES; RUN; The file in question only has one sheet, the first row has the column names and then there is a mix of number and text data for the columns. In the output table i get all the data rows (33), but no columns. (total rows 34). Is there something wrong in the code, or can someone please suggest an alternative solution.
... View more