With this technique, I get no extra rows.
Options validVarName=v8 ;
This is working on Windows98.
Edward Heaton, Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1550 Research Boulevard, Room 2018, Rockville, MD 20850-3195
Voice: (301) 610-4818 Fax: (301) 294-3992
From: Huang, Ya [mailto:ya.huang@PFIZER.COM]
Sent: Monday, July 29, 2002 1:51 PM
Subject: proc import, excel, always get one extra record?
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
I know I can delete this record in SAS, just wonder why it happens.