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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.