A00-231 Exam Question 36

The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?
  • A00-231 Exam Question 37

    What is the purpose or the MISSOVER option on the INFILE statement?
  • A00-231 Exam Question 38

    Given the SAS data set WORK.ONE:

    What value will SAS assign to Total?
  • A00-231 Exam Question 39

    Given the raw data record DEPT:
    ----|----10---|----20---|----30
    Printing 750
    The following SAS program is submitted:
    data bonus;
    infile 'dept';
    inputdept$ 1-11 number 13- 15;
    <insert statement here>
    run;
    Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
  • A00-231 Exam Question 40

    On which portion(s) of a SAS data set does the PRINT procedure report?