Help using Base SAS procedures

read excel file at special row and column

Reply
Regular Contributor
Posts: 222

read excel file at special row and column


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,

.....

Contributor
Posts: 65

Re: read excel file at special row and column

Posted in reply to Mike_Davis

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;

Ask a Question
Discussion stats
  • 1 reply
  • 309 views
  • 0 likes
  • 2 in conversation