Libname Xlstest "C: /Excelfile01.xls"; Data Xlstest.class; set sort data = xlstest.class out = xlstest.class = xlstest.class_sort; by height; run; Excelfile01.xls No need to be pre-created in advance. The SAS system will use Excelfile01.xls as a logic library to transparent access. Each table corresponds to a TAB in Excel.
SAS is an exclusive access to the file when establishing such a logic library, then other programs cannot access Excelfile01.xls until you submit libName Xlstest Clear;