Skip to main content

A00-215 Real Exam Questions

SAS 9.4 Programming Fundamentals

60 questions available · Page 1 of 6

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Given the PROC PRINT report of the INVEST data set shown below:

How many observations are in the FORCAST data set after this program executes?

  1. A

    30

  2. B

    10

  3. C

    0

  4. D

    20

Show answer and explanation

Correct answer: A

Question 2 Single choice

Which statement is true about the SUM statement?

  1. A

    The SUM statement includes an equal sign.

  2. B

    Multiple accumulating variables can be created with one SUM statement.

  3. C

    The SUM statement ignores missing values.

  4. D

    By default, the accumulating variable is initialized to 1.

Show answer and explanation

Correct answer: B

Question 3 Single choice

Which statement is true about the DROP statement during the compilation phase of the DATA step?

  1. A

    The DROP statement flags the variables in the Program Data Vector to be dropped at output.

  2. B

    The DROP statement determines the order of the variables in the Program Data Vector

  3. C

    Variables on the DROP statement are removed from the input data set.

  4. D

    Variables on the DROP statement are not created in the Program Data Vector

Show answer and explanation

Correct answer: C

Question 4 Single choice

Which statement is true when creating two SAS data sets with a DATA step?

  1. A

    Name both data sets in the DATA statement

  2. B

    Use an OUT= option in the WHERE statement to output the observations to the appropriate data sets.

  3. C

    Use a PUT statement to output the observations to the appropriate data sets.

  4. D

    Use a separate SET statement for each data set.

Show answer and explanation

Correct answer: D

Question 5 Single choice

Which statements read the input data set SASHELP. SHOES and create the output data set WORK.
TOTAL?

  1. A

    data sashalp.shoes;
    out work.total;

  2. B

    data sashelp.shoes;
    output work.total;

  3. C

    data work.total;
    set sashelp.shoes;

  4. D

    data out=work.total;
    input sasholp.shoes

Show answer and explanation

Correct answer: A

Question 6 Single choice

Given the input data set WORK.RUN:

Given the following DATA step:

What is the correct output data set WORK.RUN2?

  1. A

    Option A

  2. B

    Option B

  3. C

    Option C

  4. D

    Option D

Show answer and explanation

Correct answer: D

Question 7 Single choice

How many statements are In the program shown below?

  1. A

    9

  2. B

    6

  3. C

    10

  4. D

    2

Show answer and explanation

Correct answer: D

Question 8 Single choice

Which step temporarily assign a format to the sales variable?

  1. A

    Proc format;
    Formatsales comma12.;
    Run;

  2. B

    Data sasuer. Shoes
    Set sashelp,sheoes;
    Format sales comma12.;

  3. C

    Proc contents data=sashelp.shoes;
    Format Sales comma12.;
    Run;

  4. D

    Proc print data= sashelp. Shoes
    Format sales comma12.;
    Run;

Show answer and explanation

Correct answer: D

Question 9 Single choice

Which option renames the variable Name to StudentName when reading the ClassRoster data set?

  1. A

    set ClassRoster (rename (StudentName=Name ) ) ;

  2. B

    set ClassRoster (rename (NamestudentName) ) ;

  3. C

    set ClassRoster (renaiae=(Name=studentName) ) ;

  4. D

    set ClassRoster (^name=(StudentName=Name));

Show answer and explanation

Correct answer: B

Question 10 Single choice

Given the following assignment statement:

BirthDate = 15DEC2005'd;

Which statement is true?

  1. A

    15DEC2005 'd is a character constant

  2. B

    BirthDate is a numeric variable.

  3. C

    The byte size of BirthDate is 9.

  4. D

    The assignment statement contains a syntax error.

Show answer and explanation

Correct answer: B