Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (B 1-10)
Part: B
1: The SAS data set EMPLOYEE_INFO is listed below:
Braindump2go Online Free Latest Microsoft Exam Questions and Practice Tests
Part: B
1: The SAS data set EMPLOYEE_INFO is listed below:
61: Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
51: The contents of the SAS data set PERM.JAN_SALES are listed below:
31: The contents of the raw data file SIZE are listed below:
—-|—-10—|—-20—|—-30
72 95
The following SAS program is submitted:
data test;
infile ‘size’;
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?
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?
11: Click the Exhibit button to view a listing of the SASUSER.HOUSES data set.
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price lt 100000;
<insert DEFINE statement here>
define price / mean width = 9;
title;
run;
The following ouput is created by the REPORT procedure:
Which one of the following DEFINE statements completes the above program and produces the above output?
Part: A
1: The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet; run;
Which one of the following is needed to display the standard deviation with only two decimal places?
A.Add the option MAXDEC = 2 to the MEANS procedure statement.
B.Add the statement MAXDEC = 7.2; in the MEANS procedure step.
C.Add the statement FORMAT STD 7.2; in the MEANS procedure step.
D.Add the option FORMAT = 7.2 option to the MEANS procedure statement.
Answers: A