Help using Base SAS procedures

import excel from specific row

Reply
Regular Contributor
Posts: 222

import excel from specific row

Hello everyone,

How could I import an excel file from a sepcified row?

Thanks

Mike

PROC IMPORT

OUT= test

DATAFILE= "c:temp\in.xls"

DBMS=EXCEL REPLACE;

SHEET="test$";

GETNAMES=YES;

MIXED=YES;

DATAROW=5;  /*this has a problem,i want to import data from the fifth row*/

USEDATE=YES;

SCANTIME=YES;

SCANTEXT=YES;

RUN;

PROC Star
Posts: 7,356

Re: import excel from specific row

Mike,

You can do it by including a Range statement.  It is described at:

http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm

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