Decide Fast & Get 50% Flat Discount on This Summer Discount offer | Limited Time Offer - Ends In COUPON CODE: Summer50

Practice SAS A00-231 Exam Questions

    1. Page: 1/8
      Total 36 Questions
    Question No 1
    SIMULATION
    Scenario
    This project will use data setcert.input04. At any time, you may save your program
    asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.
    In this program, complete the following mathematical actions, in the following order
    Round VAR1 and VAR2 to the nearest integer values.
    Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.
    Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.
    For observation 16, what is the value ofVAR3? Enter your numeric answer in the space below
    Choose the Choices:


    Question No 2
    SIMULATION
    Scenario
    This project will use data setcert.input04. At any time, you may save your program
    asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.
    In this program, complete the following mathematical actions, in the following order
    Round VAR1 and VAR2 to the nearest integer values.
    Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.
    Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.
    For observation 16, what is the value ofVAR20? Enter your numeric answer in the space below.
    Round your answer to the nearest whole number. Save your program
    asprogram04.sasincert\programs before continuing with the next project
    Choose the Choices:


    Question No 3
    SIMULATION
    This project will use data set cert.input08a and cert.input08b. At
    any time, you may save your program
    as program08 in cert\programs.
    Both data sets contain a common numeric variable named ID.
    Write a program that will use a SAS DATA Step to
    o Combine data sets cert.input08a and cert.input08b by
    matching values of the ID variable.
    o Write only observations that are in both data sets to a
    new data set named results.match08.
    o Write all other non - matching observations from either
    data set to a new data set named results.nomatch08.
    o Exclude all variables that begin with
    "ex" from results.nomatch08.
    How many observations (rows) are inresults.match08?
    Enter your numeric answer in the space below
    Choose the Choices:


    Question No 4
    SIMULATION
    Scenario
    This project will use data set cert.input08a and cert.input08b. At
    any time, you may save your program
    as program08 in cert\programs.
    Both data sets contain a common numeric variable named ID.
    Write a program that will use a SAS DATA Step to
    o Combine data sets cert.input08a and cert.input08b by
    matching values of the ID variable.
    o Write only observations that are in both data sets to a
    new data set named results.match08.
    o Write all other non - matching observations from either
    data set to a new data set named results.nomatch08.
    o Exclude all variables that begin with
    "ex" from results.nomatch08.
    How many variables (columns) are in results.match08
    Choose the Choices:


    Question No 5
    SIMULATION
    Scenario
    This project will use data set cert.input08a and cert.input08b. At
    any time, you may save your program
    as program08 in cert\programs.
    Both data sets contain a common numeric variable named ID.
    Write a program that will use a SAS DATA Step to
    o Combine data sets cert.input08a and cert.input08b by
    matching values of the ID variable.
    o Write only observations that are in both data sets to a
    new data set named results.match08.
    o Write all other non - matching observations from either
    data set to a new data set named results.nomatch08.
    o Exclude all variables that begin with
    "ex" from results.nomatch08.
    How many observations (rows) are inresults.nomatch08?
    Choose the Choices:



    1. Page: 1/8
      Total 36 Questions