XLSX libname to import XLSX file into SAS

[Ronein]

Hello

I saw this example  of XLSX libname.

I want to ask some questions in order to understabd better:

1-Is the XLSX file name  HRworkbook.xlsx?

2-Is the sheet name where we import data is perm_employees ?

3- I don't see Create table statement, what does it mean? No data set is created here? Just print out screen?

libname myhr XLSX "/path/HRworkbook.xlsx";
proc sql;
select lname label="Last Name", empid, start_date format=date9. 
from myhr.perm_employees 
where state="NC";
quit;

[Ksharp · Accepted solution]

1- Yes.
2- Yes.
3- Yes. Just print out the obs which state="NC" in table myhr.perm_employees . Just like the following code:

proc print data=myhr.perm_employees ;
where state="NC";
run;