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;
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.