Free SASInstitute A00-212 Exam Dumps Questions & Answers

The following SAS program is submitted:
% macro test(var);
% let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
% let type = %index(&jobs,&var);
% mend;
% test(SMITH)
Which one of the following is the resulting value of the macro variable TYPE?

• A.  3
• B.  null
• C.  0
• D.  6

Given the following SAS data sets ONE and TWO:
ONE TWO
OBS COMMON X OBS COMMON Y
1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14
The following SAS DATA step is submitted:
data combine;
merge one two;
by common;
run;
Which one of the following represents the data values stored in data set COMBINE?

• A.  OBS COMMON X Y
  1 A 10 1
  2 A 13 3
  3 B 14 4
  4 B 9 2
  5 C 8 5
• B.  OBS COMMON X Y
  1 A 10 1
  2 A 13 3
  3 A 14 3
  4 B 9 4
  5 B 9 2
  6 C 8 5
  7 C 14 5
• C.  OBS COMMON X Y
  1 A 10 1
  2 A 13 1
  3 A 14 1
  4 A 10 3
  5 A 13 3
  6 A 14 3
  7 B 9 4
  8 B 9 2
  9 C 8 5
  10 C 14 5
• D.  OBS COMMON X Y
  1 A 10 1
  2 A 13 3
  3 B 9 4
  4 C 8 5

Which one of the following statements is true regarding a SAS DATA step view?

• A.  It contains a partially compiled DATA step.
• B.  It allows write capabilities.
• C.  It contains data and a descriptor portion.
• D.  It contains global statements.

Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
M 28 200 20
M 25 100 10
M 28 300 10
M 33 300 30
F 18 100 50
F 25 200 10
F 35 400 50
The following SQL program is submitted:
proc sql;
create table two as
select distinct age
from one
where age < 33;
quit;
How many rows are written to the SAS data set TWO?

• A.  5
• B.  4
• C.  3
• D.  6

The following SAS program is submitted:
data new (bufsize = 6144 bufno = 4);
set old;
run;
Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

• A.  BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.
• B.  BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.
• C.  BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.
• D.  BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.