I typically receive Excel files with some sort of explanatory material on the first few lines, and a data table below with variable names in the first row.
So far, I have been unable to come up with the right options (FIRSTOBS? DBDSOPTS?) and placement so that I can get just the data table, and I know I've got to be missing something obvious in the documentation.
Could someone please point me to some examples?
The following is a starting point for a table that starts with variable names on row 5, data on row 6.
Is the data in the spreadsheets contained in named ranges? If not, can you get to them to define the ranges you want prior to reading them? This is the only way I'm aware of to get SAS to start reading data anywhere other than the top left cell on the specified sheet. For example, if you defined the name 'datarange' for the data you wanted on the sheet 'daily q phase i', then you could read this with