SASInstitute A00-202 dumps - 100% Pass Guarantee!

Given the following SAS data set ONE:

ONE GROUP SUM

A 765

B 123

C 564

The following SAS program is submitted:

data _null_;

set one;

call symput(group,sum);

run;

Which one of the following is the result when the program finishes execution?

A. Macro variable C has a value of 564.

B. Macro variable C has a value of 1452.

C. Macro variable GROUP has a value of 564.

D. Macro variable GROUP has a value of 1452.

The SAS data set ONE consists of five million observations and has 25 variables. Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

A. data two; set one; totrev = sum(price * quantity); totcost = sum(fixed,variable); profit = sum(totrev,otcost); if totrev > 1000; run;

B. data two; set one; totrev = sum(price * quantity); if totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

C. data two; set one; totrev = sum(price * quantity); where totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

D. data two; set one; where totrev > 1000; totrev = sum(price * quantity); totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

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 = andnumgrp;

select distinct status

into :group1-:groupandnumgrp

from sasuser.highway;

quit;

%do i = 1 %to andnumgrp;

proc print data = sasuser.highway;

where status = "andandgroupandi" ;

run;

%end;

%mend;

%highway

How many reports are produced by the above program?

A. 0

B. 1

C. 2

D. 5

Given the following SAS data set ONE:

ONE

CATEGORY AGE SALARY BONUS

--------------------------------------------------- M 28 200 .

M 25 100 10

F 100 50

F 25 200 10

The following SAS program is submitted:

proc sql;

create table two as

select category, salary + bonus as EARNINGS

from one; quit;

Which one of the following represents the data values stored in the data set TWO?

A. CATEGORY EARNINGS

M 200

M 110

F 150

F 210

B. CATEGORY EARNINGS

M .

M 110

F 150

F 210

C. CATEGORY SALARY BONUS EARNINGS --------------------------------------------------------------- M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210

D. CATEGORY SALARY BONUS EARNINGS

M 200 . .

M 100 10 110

M 200 . 200

M 100 10 110

F 100 50 150

F 200 10 210

Which one of the following options displays the value of a macro variable in the SAS log?

A. MACRO

B. SOURCE

C. SOURCE2

D. SYMBOLGEN