Which statement correctly assigns a library reference to the Excel workbook?
A. ibname qtrdata 'qtr1. XLS';
B.l ibname 'qtr1. XLS sheets=3;
C.l ibname jan feb mar 'qtr1. XLS.
D.l ibname mydata 'qtr1. XLS' WORK. The sheets=(jan, feb, mar);
CodePudding user response:
Do not know this thing, but it looks simple may be right, A?
CodePudding user response:
Thank you very much! Has selected A and C, the individual also tend to choose A, followed after the libname is logic library name, option C is equivalent to create the three logical library rather than three working table, in addition to see SAS related reference books, reading Excel file can use the IMPORT process, the SHEET="SHEET - the name" statement can specify which specific reading A work table, but also see some words, XLS format file to be used: logic library name. 'Excel table name $n, I use it in the SAS software, prompt name is illegal, now still confused about,CodePudding user response:
The correct answer is a.Whether reading excel, TXT, CSV format of the data can use the import process, such as
Read the XLS format file use: logic library name. 'Excel table name $n, as a rule of this and read the sas file, the difference is much more' table name $n in single quotes' and absolute symbol $and letters, n, this is because the sas only recognize English named files, plus the symbol to identify Chinese