|
Ya;
With this technique, I get no extra rows.
Options validVarName=v8 ;
LibName xls
odbc
complete="dsn=Excel Files;dbq=H:\SasTestBed\SAS-L\Book1.xls"
;
This is working on Windows98.
Ed
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
mailto:EdHeaton@westat.com http://www.westat.com
-----Original Message-----
From: Huang, Ya [mailto:ya.huang@PFIZER.COM]
Sent: Monday, July 29, 2002 1:51 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc import, excel, always get one extra record?
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
|
