read excel file at special row and column

[Mike_Davis]

hello everyone,

How i can read excel file into SAS only from special col and row to special col and row?

if the excel file I want read from E 10 to  K20.

Thanks

Mike

the code like:

proc import

out=one

datafile=''c:\temp\a.xls"

DBMS=excel replace;

sheet="aa$";

StartRow=10,

StartCol=E,

EndRow=20,

EndCol=K,

.....

[Pritish]

Try using Range option in Proc Import.

Something like this:

proc import file='c:\temp\op.xls' out=op dbms=xls replace;

Range = "E10:K20";

getnames=yes;

run;