From: demin on
Hi,
Can we specify one column when importing excel file? I've tried:
proc import...
range="sheetname$B1:B516";
....
run;

It works, but we cannot specify the range like B1:B516, any other
method?

or any other import way? thanks a lot.
From: Arthur Tabachneck on
Demin,

Would something like the following suffice (where f2 represents col
b):?

libname have excel "k:\art\rangetest.xls";
data want;
set have."sheet1$"n (keep=f2);
run;

HTH,
Art
-------------
On May 13, 5:51 pm, demin <qdmi...(a)gmail.com> wrote:
> Hi,
> Can we specify one column when importing excel file? I've tried:
> proc import...
>   range="sheetname$B1:B516";
> ...
> run;
>
> It works, but we cannot specify the range like B1:B516, any other
> method?
>
> or any other import way? thanks a lot.