SAS Base (12)

The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR

Which statement correctly assigns a library reference to the Excel workbook?
A. libname qtrdata ‘qtr1.xls’;
B. libname ‘qtr1.xls’ sheets=3;
C. libname jan feb mar ‘qtr1.xls’;
D. libname mydata ‘qtr1.xls’ WORK.heets=(jan,feb,mar);

Check Answer
Answer: A

注解:使用Excel SAS/ACCESS LIBNAME Engine读取Excel文件的格式:LIBNAME  libref  ‘文件路径’。

Leave a Reply

Your email address will not be published. Required fields are marked *