SASInstitute A00-201 問題集

質問 1：
A raw data record is shown below:
07Jan2002
Which one of the following informats would read this value and store it as a SAS date value?
A. ddmmmyyyy9.
B. ddMMMyy9.
C. date9.
D. ddmonyy9.
正解：C

質問 2：
The following SAS program is submitted:
proc datasets lib = sasuser;
contents data = class varnum;
quit;
Which one of the following is the purpose of the VARNUM option?
A. to print the total number of variables
B. to print a list of variable names
C. to print a list of the variables in alphabetic order
D. to print a list of the variables in the order they were created
正解：D

質問 3：
The following SAS program is submitted:
libname temp 'SAS-data-library';
data work.new;
set temp.jobs;
format newdate mmddyy10.;
qdate = qtr(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2000.
What output is produced if April 15, 2000 falls on a Saturday?
A. Obs newdate qdate ddate
1 APR152000 2 7
B. Obs newdate qdate ddate
1 04/15/2000 2 7
C. Obs newdate qdate ddate
1 APR152000 2 6
D. Obs newdate qdate ddate
1 04/15/2000 2 6
正解：B

質問 4：
The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?
A. 9
B. . (missing numeric value)
C. 6
D. The program fails to execute due to errors.
正解：A

質問 5：
The contents of the raw data file FURNITURE are listed below:
----|----10---|----20---|----30
chair,,table
chair,couch,table
The following SAS program is submitted:
data stock;
infile 'furniture' dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?
A. ' ' (missing character value)
B. . (missing numeric value)
C. ,table
D. table
正解：A

質問 6：
A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH';
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations will the output data set contain?
A. 0
B. 3
C. 7
D. 5
正解：B

質問 7：
The following SAS DATA step executes on Monday, April 25, 2000:
data newstaff;
set staff;
start_date = today();
run;
Which one of the following is the value of the variable START_DATE in the output data set?
A. a character string with the value 'Monday, April 25, 2000'
B. a character string with the value '04/25/2000'
C. the numeric value 14725, representing the SAS date for April 25, 2000
D. the numeric value 04252000, representing the SAS date for April 25, 2000
正解：C

質問 8：
The following SAS program is submitted:
data work.report;
set work.sales_info;
if qtr(sales_date) ge 3;
run;
The SAS data set WORK.SALES_INFO has one observation for each month in the year
2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.
How many of the original twelve observations in WORK.SALES_INFO are written to the
WORK.REPORT data set?
A. 9
B. 2
C. 3
D. 6
正解：D

質問 9：
The SAS data set EMPLOYEE_INFO is listed below:

The following SAS program is submitted:
proc sort data = employee_info;
< insert BY statement here>
run;
Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?
A. by Expenses IDNumber;
B. by ascending (IDNumber Expenses);
C. by IDNumber Expenses;
D. by ascending IDNumber ascending Expenses;
正解：C