Online Access Free A00-211 Exam Questions

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?

• A.2
• B.. (missing numeric value)
• C.95
• D.72

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department.
The following SAS program is submitted:

What is the value of the variable Total before the first iteration of the data step?

• A.Missing
• B.Cannot be determined from the information given
• C.0
• D.The value of the first observation's Wagerate.

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.. (missing numeric value)
• B.,table
• C.table
• D.' ' (missing character value)

Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

• A.missing numeric variable values and non-missing numeric variable values only
• B.non-missing character variables and non-missing numeric variable values only
• C.missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values
• D.non-missing numeric variable values only

Which program displays a listing of all data sets in the SASUSER library?

• A.proc contents data = sasuser.all; run;
• B.proc contents lib = sasuser.all; run;
• C.proc contents data = sasuser._all_; run;
• D.proc contents lib = sasuser._alI_; run;