Free A00-212 Exam braindumps download (A00-212 exam dumps Free)

QUESTION: 81

The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE?

data two;
set three;
set one key = X;
run;
data two;
set three key = X;
set one;
run;
data two;
set one;
set three key = X;
run;
data two;
set three;
set one (key = X);
run;

Answer(s): A

Show Answer Next Question

QUESTION: 82

Given the following SAS data set ONE:

ONE
REP AREA COST
SMITH NORTH 100
SMITH SOUTH 200
JONES EAST 100
SMITH NORTH 300
JONES WEST 100
JONES NORTH 200
JONES NORTH 400
SMITH NORTH 400
JONES WEST 100
JONES WEST 300
The following SAS program is submitted:
proc sql;
select rep, area, count(*) as TOTAL
from one
group by rep, area;
quit;

Which one of the following reports is generated?

REP AREA COUNT
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
REP AREA TOTAL
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
SMITH NORTH 3
SMITH SOUTH 1

Answer(s): C,D

Show Answer Next Question

QUESTION: 83

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

MODIFY
FORMAT
CONTENTS
DATASETS

Answer(s): D

Show Answer Next Question

QUESTION: 84

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;
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?