nerdexam
SAS_Institute

A00-202 · Question #28

Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT ----------------------------------------------------------------------------- absent no 0-29…

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

Question

Given the following SAS data set SASUSER.HIGHWAY:

SASUSER.HIGHWAY 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; SAS A00-202 Exam 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

  • A0
  • B2
  • C5
  • D5
  • E1

How the community answered

(28 responses)
  • A
    14% (4)
  • B
    75% (21)
  • C
    4% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice