Excel data via libname

[Miracle]

Dear all,

I wish to read in my Excel data via libname but SAS doesn't read in all the columns when I open it.

Here is my SAS syntax if you could please tell me what's wrong with it?

• libname chk EXCEL '\\IDMS\IDMS 2013.xlsx' mixed=yes stringdates=yes dbMax_text=32767;

Thank you very much.

[RW9]

perhaps you could post an example excel file where this problem occurs.  I cannot tell much from what you have posted. 

[jakarman]

Check the columns have been defined like a table. All of them must have a name (first row) that conforms SAS naming conventions.

Putting a missing column in between will stop the reading at that point.

As the conversion Excel/SAS using libnames is based on range definitions. You could define a named range in Excel.

[Miracle]

Thanks for your reply.

I checked that there is neither a missing column nor invalid SAS naming conventions.
I managed to read in all my data by proc import with GUESSINGROWS=2147483647; statement and I still don't understand why I can't do it with libname statement :smileyconfused:
Because I need to meet deadline I'll just use proc import for now