Proper study guides for Refresh SAS Institute SAS Base Programming for SAS ® 9 certified begins with SAS Institute A00-211 preparation products which designed to deliver the Downloadable A00-211 questions by making you pass the A00-211 test at your first time. Try the free A00-211 demo right now.
Q113. The following SAS program is submitted:
What will the data set WORK.TEST contain?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q114. The following SAS program is submitted:
proc format
value score 1 - 50 = ‘Fail’
51 - 100 = ‘Pass’;
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
A. Fail
B. Pass
C. 50.5
D. (missing numeric value)
Answer: C
Q115. 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. 2
B. 3
C. 6
D. 9
Answer: C
Q116. Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement. Which statement regarding this variable is true?
A. It is assigned a value 0 when the data step begins execution.
B. It is assigned a value of missing when the data step begins execution.
C. It is assigned a value 0 at compile time.
D. It is assigned a value of missing at compile time.
Answer: C
Q117. Consider the following data step:
The computed variables City and State have their values assigned using two different methods, a
RETAIN statement and an Assignment statement. Which statement regarding this program is true?
A. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
B. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.
C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
D. City's value will be assigned one time, State's value 5 times.
Answer: D
Q118. Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?
A. proc sort out=EMPLOYEES data=EMPSORT; by Lname and Fname; run;
B. proc sort data=SASUSER.EMPLOYEES out=EMPSORT;
by Lname Fname;
run;
C. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;
by Lname Fname;
run;
D. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;
by Lname and Fname;
run;
Answer: B
Q119. The following SAS program is submitted:
data test;
infile ‘file specification’;
input name $ amount@@;
run;
Which of the following is true?
A. Two @@ together are the same as one c.
B. Two @@ hold the data records until the bottom of the DATA step.
C. Two @@ hold the raw data record across iterations of the DATA step.
D. Two @@ are invalid syntax and will cause the program to fail to execute.
Answer: C
Q120. The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
A. 0
B. 1
C. 5
D. 60
Answer: D