A quick way to solve it is to use DDE, which you can specify the first
row to be read as data and specify the informat as well.
On 8/8/05, Joan Zhao <firstname.lastname@example.org> wrote:
> I found a problem when I read a excel file into SAS. The initial seceral
> rows(more than 8 rows) of one of the column in this file are blank and then
> follwed by numeric numbers. In this column, most cells are empty. When SAS
> read in this file by no matter what approach(SAS/ACCESS--import procedure
> or OLEDB), nothing in this column is read in. The generated SAS dataset is
> empty. If I change the whole column's datatype to character(text) in excel,
> then problem is solved. Or if I fill in a numeric number within first 8
> rows, then the whole column can be read in as well. But if I fill in the
> number after 8th row, then nothing is read in.
> Does anybody know what's going on? Why cannot the data be read in if the
> data is numeric and with first 8 rows blank? Thank you in advance!
> Joan Zhao
WenSui Liu, MS MA
Senior Decision Support Analyst
Division of Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center