Help using Base SAS procedures

Excel data via libname

Reply
Regular Contributor
Posts: 217

Excel data via libname

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.

Super User
Super User
Posts: 7,404

Re: Excel data via libname

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

Valued Guide
Posts: 3,208

Re: Excel data via libname

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.

---->-- ja karman --<-----
Regular Contributor
Posts: 217

Re: Excel data via libname

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 Smiley Happy

Ask a Question
Discussion stats
  • 3 replies
  • 211 views
  • 3 likes
  • 3 in conversation