I am trying to use libname XLSX to read a file into SAS. It is pulling in all but the first column. As a background - I have 3 excel files I created in the same program, all with the same columns (but different row content in each one). I used libname xlsx to output and save these files. I later try to read these into SAS using libname XLSX. For 2 of them, it creates the SAS datasets with all variables. For the 3rd one, it is not reading in the first column. After opening the file in excel, I tried the following changes to the file, and then to read it into SAS (using Libname XLSX): I tried copying that column and putting it as the last column - still doesn't read in that column. I deleted this first column, keeping the copied version at the end - still doesn't read in the column. I renamed the column (and file) - still doesn't read it in. When I use proc import - it reads in all columns. Any idea why this is? These files only have 7 variables, so it is easy to see that one is not being read in. Thanks!
... View more