Import only specified columns from excel sheet

[Efka]

Hello,

I was trying to find out if it is possible to import only specific columns from a specified excel sheet, however couldn't find anything useful.

If it is possible, please give me examples,

Thank You.

[art297 · Accepted solution]

There is no reason you can't simply keep or drop variables when calling proc import.  e.g., the following code reads a file that has seven variables (id, x, y, z, a, b and c), but only keeps id, x, y and z):

PROC IMPORT OUT= WORK.want (keep=id x y z)

            DATAFILE= "C:\art\test.xls"

            DBMS=xls REPLACE;

     GETNAMES=YES;

RUN;

[Oleg_L]

You can specify RANGE option in PROC IMPORT.

range='sheet1$f14:f1782';

Oleg.