XLSX libname to import XLSX file into SAS

Ronein — Sat, 27 Nov 2021 10:52:24 GMT

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;

Re: XLSX libname to import XLSX file into SAS

Ksharp — Sat, 27 Nov 2021 11:05:02 GMT

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;

topic XLSX libname to import XLSX file into SAS in SAS Programming

XLSX libname to import XLSX file into SAS

Re: XLSX libname to import XLSX file into SAS