Problem in importing excel file

[Aman4SAS]

proc import datafile = "C:\Users\loveislife\Desktop\data.xls" out =bank1 replace   

dbms=excel  ;

getnames=yes ;

sheet=sheet1;

run;

proc print data=bank1;run;

i m using this code to import a excel file(attached ) . i m getting 3 extra variable like F7,F8,F9,

Can anyone help me to let me know why i m getting these extra fields?????????

[Tom · Accepted solution]

Because that is what your spreadsheet has in it.  When I open your attachment and press CTRL-END it jumps to column I row 713.  So your spreadsheet has three empty columns.  You can either drop them on the SAS side or edit the spreadsheet and delete those columns.

[Aman4SAS]

Thanks for your kind help.