Date:         Mon, 29 Jul 2002 10:50:52 -0700
Reply-To:     "Huang, Ya" <ya.huang@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, Ya" <ya.huang@PFIZER.COM>
Subject:      proc import, excel, always get one extra record?
Content-Type: text/plain

Hi there,

I'm using proc import to convert excel *.xls file to sas date sets.
One of the xls file always get me one extra record (followed the last
obs), with all the var's value missing. I tried to delete all the rows
after the last visible rows in excel, by highlighting the rows and
choose "delete" from edit menu, but the extra record in sas data set
still there.

I know I can delete this record in SAS, just wonder why it happens.

Any clue?

Thanks

Ya Huang