read excel file at special row and column

Mike_Davis — Fri, 29 Jun 2012 16:16:01 GMT

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,

.....

Re: read excel file at special row and column

Pritish — Fri, 29 Jun 2012 18:17:08 GMT

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;