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!