A00-231 Exam Question 6

Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?
  • A00-231 Exam Question 7

    The following program is submitted:
    proc sort data=SASUSER.PROJECTS out=PSORT;
    by Code descending Date Cost;
    run;
    Which of the following is true concerning the submitted program?
  • A00-231 Exam Question 8

    The following SAS program is submitted:
    data combine;
    prefix='505';
    middle='6465 ';
    end='09090';
    <insert statement here>;
    run;
    Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?
  • A00-231 Exam Question 9

    Which is a valid LIBNAME statement?
  • A00-231 Exam Question 10

    The following SAS program is submitted:
    data work.empsalary;
    set work.people (in = inemp)
    work.money (in = insal);
    if insal and inemp;
    run;
    The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
    How many observations will the data set WORK.EMPSALARY contain?