05-09-2014 04:37 AM
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?
Thank you very much.
05-09-2014 06:14 AM
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.
05-11-2014 06:45 AM
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