Free Latest Braindump2go Exam Dumps

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?

Read more

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?

Read more

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

Read more