Proper study guides for Most up-to-date SAS Institute SAS Base Programming for SAS ® 9 certified begins with SAS Institute A00-211 preparation products which designed to deliver the Simulation A00-211 questions by making you pass the A00-211 test at your first time. Try the free A00-211 demo right now.
Q57. The following SAS program is submitted:
data one; date = ‘04juI2005’d; format date weekdate.; run; proc print data = one; run;
What output is generated?
A. Obs date 1 Monday, July 4, 2005
B. Obs date 1 July4, 2005
C. Obs date 1 04Jul2005
D. Obs date 1 Monday, 07/04/2005
Answer: A
Q58. When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library'
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
A. 400 for PROC PRINT 4500 for PROC MEANS
B. 401 for PROC PRINT 4501 for PROC MEANS
C. 401 for PROC PRINT 4500 for PROC MEANS
D. 500 for PROC PRINT 5000 for PROC MEANS
Answer: B
Q59. Given the SAS data set AGES:
AGES AGE
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
A. 0
B. 1
C. 2
D. 3
Answer: A
Q60. The following SAS program is submitted:
What is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS.
Answer: B
Q61. 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. 6
B. 9
C. . (missing numeric value)
D. The program fails to execute due to errors.
Answer: B
Q62. The following SAS program is submitted:
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
Which one of the following is the value of the DATE variable?
A. a character string with the value '23mar2000'
B. a character string with the value '03/23/2000'
C. a numeric value of 14692, which represents the SAS date value for March 23, 2000
D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000
Answer: C
Q63. Which one of the following SAS procedures displays the data portion of a SAS data set?
A. PRINT
B. FSLIST
C. CONTENTS
D. DATASETS
Answer: A
Q64. The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY fname age name salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata;
by fname; totsal + salary; run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
A. merge work.employee
work.salary (fname = name);
B. merge work.employee
work.salary (name = fname);
C. merge work.employee
work.salary (rename = (fname = name));
D. merge work.employee
work.salary (rename = (name = fname));
Answer: D