A00-231 Exam Question 61

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
  • A00-231 Exam Question 62

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

    After a SAS program is submitted, the following is written to the SAS log:

    What changes should be made to the KEEP statement to correct the errors in the LOG?
  • A00-231 Exam Question 64

    Given the SAS data set WORK.TEMPS:

    The following program is submitted:

    Which output is correct?
  • A00-231 Exam Question 65

    The following SAS program is submitted:
    data work.test;
    set work.staff (keep = jansales febsales marsales);
    array diff_sales{3} difsales1 - difsales3;
    array monthly{3} jansales febsales marsales;
    run;
    What new variables are created?