nerdexam
SAS_Institute

A00-211 · Question #270

This questions will ask you to provide two missing variable names. The following SAS program is submitted: data WORK.TOTAL; set WORK.SALARY; by Department Gender; if First. <insert variable 1 here>…

The correct answer is B. variable 1: Gender variable 2: Gender. See the full explanation below for the reasoning.

Question

This questions will ask you to provide two missing variable names. The following SAS program is submitted:

data WORK.TOTAL; set WORK.SALARY; by Department Gender; if First. <insert variable 1 here> then Payroll=0 Payroll+Wagerate; if Last.<insert variable 2 here>; run; The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

Options

  • Avariable 1: Gender variable 2: Department
  • Bvariable 1: Gender variable 2: Gender
  • Cvariable 1: Department variable 2: Gender
  • Dvariable 1: Department variable 2: Department

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    71% (20)
  • C
    14% (4)
  • D
    11% (3)

Community Discussion

No community discussion yet for this question.

Full A00-211 Practice