Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (A 21-30)
21: 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.table
B.,table
C.. (missing numeric value)
D.’ ‘ (missing character value)
Answers: D
22: The contents of the raw data file CALENDAR are listed below:
—-|—-10—|—-20—|—-30
01012000
The following SAS program is submitted:
data test;
infile ‘calendar’;
input @1 date mmddyy10.;
if date = ‘01012000’d then event = ‘January 1st’;
run;
Which one of the following is the value of the EVENT variable?
A.01012000
B.January 1st
C.. (missing numeric value)
D.The value can not be determined as the program fails to execute due to errors.
Answers: D
23: 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
Answers: C
24: 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.
Answers: B
25: 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)
Answers: C
26: The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 – sales4;
run;
Which one of the following represents the variables that are contained in the output data set?
A.SALES1, SALES2, SALES3, SALES4
B.AGENTS1, AGENTS2, AGENTS3, AGENTS4
C.None, the DATA step fails because the ARRAY statement can reference only numeric data.
D.None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.
Answers: A
27: The contents of the raw data file PRODUCT are listed below:
—-|—-10—|—-20—|—-30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile ‘product’;
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
A.25.31
B.$25.31
C.. (missing numeric value)
D.No value is stored as the program fails to execute due to errors.
Answers: C
28: The following SAS program is submitted:
data work.test;
First = ‘Ipswich, England’;
City = substr(First,1,7);
City_Country = City!!’, ‘!!’England’;
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
A.Ipswich!!
B.Ipswich, England
C.Ipswich, ‘England’
D.Ipswich , England
Answers: D
29: The following SAS program is submitted:
data numrecords;
infile ‘file-specification’;
input @1 patient $15.
relative $ 16-26 @;
if relative = ‘children’ then
input @54 diagnosis $15. @;
else if relative = ‘parents’ then
input @28 doctor $15.
clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step during execution?
A.1
B.2
C.3
D.4
Answers: A
30: The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
A.0
B.5
C.7
D.12
Answers: A
If you want to pass the SAS A00-201 exam sucessfully, recommend to read latest SAS A00-201 Braindumps full version.
