Help using Base SAS procedures

Import only specified columns from excel sheet

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Import only specified columns from excel sheet

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.


Accepted Solutions
Solution
‎04-08-2013 07:11 PM
PROC Star
Posts: 7,474

Re: Import only specified columns from excel sheet

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;

View solution in original post


All Replies
Solution
‎04-08-2013 07:11 PM
PROC Star
Posts: 7,474

Re: Import only specified columns from excel sheet

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;

Regular Contributor
Posts: 151

Re: Import only specified columns from excel sheet

You can specify RANGE option in PROC IMPORT.

range='sheet1$f14:f1782';

Oleg.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 4111 views
  • 3 likes
  • 3 in conversation