Online Access Free A00-211 Practice Test

The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?

• A.The SUM statement produces only subtotals of NUMBER for each value of TYPE.
• B.Nothing is produced by the SUM statement; the program fails to execute.
• C.The SUM statement produces only a grand total of NUMBER.
• D.The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.

Given the contents of the raw data file TYPECOLOR:
----I----10---I----20---I----30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile 'typecolor';
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?

• A.type colordaisygreen
• B.No values are stored for the TYPE and COLOR variables.
• C.type colordaisyyellow" "(missing character value)
• D.type colordaisy ellow

The following SAS program is submitted:
data one;
addressl = '214 London Way';
run;
data one;
set one;
address = tranwrd(address1, 'Way', 'Drive'); run;
What are the length and value of the variable ADDRESS?

• A.Length is 200; value is '214 London Drive'.
• B.Length is 16; value is '214 London Drive'.
• C.Length is 14; value is '214 London Dri'.
• D.Length is 14; value is '214 London Way'.

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.72
• D.95

The following SAS program is submitted:

What will the data set WORK.TEST contain?

• A.Option B
• B.Option A
• C.Option D
• D.Option C