nerdexam
SAS_Institute

A00-202 · Question #21

Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY SAS A00-202 Exam STEERING SEATBELT SPEED STATUS COUNT…

The correct answer is D. 2. See the full explanation below for the reasoning.

Question

Given the following SAS data set SASUSER.HIGHWAY:

SASUSER.HIGHWAY SAS A00-202 Exam STEERING SEATBELT SPEED STATUS COUNT -------------------- ----------------- ------------------ ---------- ---------- absent no 0-29 serious 31 absent no 0-29 not 1419 absent no 30-49 serious 191 absent no 30-49 not 2004 absent no 50+ serious 216 The following SAS program is submitted:

%macro highway; proc sql noprint; select count(distinct status) into :numgrp from sasuser.highway; %let numgrp = &numgrp; select distinct status into :group1-:group&numgrp from sasuser.highway; quit; %do i = 1 %to &numgrp; proc print data = sasuser.highway; where status = "&&group&i" ; run; %end; %mend; %highway How many reports are produced by the above program?

Options

  • A5
  • B0
  • C1
  • D2

How the community answered

(35 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    9% (3)
  • D
    83% (29)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice