topic Excel data via libname in SAS Procedures

Excel data via libname

Miracle — Fri, 09 May 2014 08:37:38 GMT

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.

Re: Excel data via libname

RW9 — Fri, 09 May 2014 09:07:46 GMT

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

Re: Excel data via libname

jakarman — Fri, 09 May 2014 10:14:49 GMT

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.

Re: Excel data via libname

Miracle — Sun, 11 May 2014 10:45:11 GMT

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