SAS9-EXECL

zhaozj2021-02-16  67

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;

转载请注明原文地址:https://www.9cbs.com/read-17591.html

New Post(0)