Using PROC SQL to Access Excel Files - Exchanging Data Between SAS and Microsoft Excel - page 164

Figure 10.10: Excel File with a New Named Range.
Figure 10.11a: PROC SQL Code to Read a Named Range from an Excel Workbook.
PROC SQL;
CONNECT TO pcfiles AS db (PATH="C:\My_Excel_Files\Shoes_1.xlsx");
CREATE TABLE New_shoes1 as
SELECT * FROM CONNECTION TO db
(
SELECT * FROM "New_range2"n
) ;
DISCONNECT FROM db;
QUIT;
The SQL code in Figure 10.11a reads the Excel named range and converts the blank row in the named
range to variable names F1, F2, F3, etc., the SAS variable names are generated, as shown in Figure 10.11b.