topic Problem in importing excel file in SAS Programming

Problem in importing excel file

Aman4SAS — Sat, 07 Sep 2013 18:37:21 GMT

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?????????

Re: Problem in importing excel file

Tom — Sat, 07 Sep 2013 19:46:37 GMT

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.

Re: Problem in importing excel file

Aman4SAS — Sun, 08 Sep 2013 05:12:21 GMT

Thanks for your kind help.