topic Re: Import only specified columns from excel sheet in SAS Procedures

Import only specified columns from excel sheet

Efka — Mon, 08 Apr 2013 21:14:16 GMT

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.

Re: Import only specified columns from excel sheet

art297 — Mon, 08 Apr 2013 23:11:48 GMT

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;

Re: Import only specified columns from excel sheet

Oleg_L — Tue, 09 Apr 2013 08:00:15 GMT

You can specify RANGE option in PROC IMPORT.

range='sheet1$f14:f1782';

Oleg.