Customize reading data from XLS using SAS LIBNAME PCFILES method.

rara — Wed, 28 Nov 2018 11:48:14 GMT

Hi There,

I have a requirement reading a bunch of XLS files into sas .

And i am using the PCFILES(LIBNAME statement) method to read it.

But by default , while reading the data it is taking the first row as the header and that is not true all the time in my case.

Also when i set the firstobs= as the start of my data , then sas is giving the default variable naming(i.e. F1,F2...)/

Please help me on the same.

Regards,

Re: Customize reading data from XLS using SAS LIBNAME PCFILES method.

RW9 — Wed, 28 Nov 2018 11:52:55 GMT

Yes, this is default behaviour. Excel is a really bad data source, which is the reason. For instance, you say you want to start in x row, what if someone else wants to read from col y, or row x, col y, or from a form or a picture. Its one of the reasons that Excel is a really bad data source and should not be used. Data should be stored in a logical and structured method. If your data isn't in that, welcome to the world of wasting your time fixing it. You will hit other issues as well, mixed type variables, multiple ranges, special characters etc. Again, Excel is a really bad datasource.

topic Re: Customize reading data from XLS using SAS LIBNAME PCFILES method. in New SAS User

Customize reading data from XLS using SAS LIBNAME PCFILES method.

Re: Customize reading data from XLS using SAS LIBNAME PCFILES method.