Hi i am getting excel file but i should read from 6 th row(In 6 th row i am having the variables).The variables have space in between them how can i do it.
I have atttached the sample Excel file.
Hi,
I saved your file as a .xls file then ran the code below:
proc import datafile="c:\temp\test_data.xls"
dbms=xls
out=DataSet
replace
;
sheet="Sheet1";
getnames=no;
datarow=7;
run;
proc print;run;
Obs A B
1 12 23
2 34 67
3 56 78
Linlin
Or if you want to read in the column titles, one way is like this :
libname xl excel "&SASForum.\datasets\test_data.xlsx";
proc print data=xl.'Sheet1$A6:B99'n; run;
date_of_
emp_num_ join_in_
Obs det the_org
1 12 23
2 34 67
3 56 78
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.