Free A00-212 Exam Braindumps (page: 19)

Page 19 of 47

The SAS data set TEMP has the following distribution of values for variable A:

A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000

Which one of the following SAS programs requires the least CPU time to be processed?

  1. data new;
    set temp;
    if a = 8 then
    b = 'Small ';
    else if a in(1, 2) then
    b = 'Medium';
    else if a = 6 then
    b = 'Large';
    run;
  2. data new;
    set temp;
    if a in (1, 2) then
    b = 'Medium';
    else if a = 8 then
    b = 'Small';
    else if a = 6 then
    b = 'Large';
    run;
  3. data new;
    set temp;
    if a = 6 then
    b = 'Large ';
    else if a in (1, 2) then
    b = 'Medium';
    else if a = 8 then
    b = 'Small';
  4. data new;
    set temp;
    if a = 6 then
    b = 'Large ';
    if a in (1, 2) then
    b = 'Small';
    run;

Answer(s): C



The following SAS program is submitted:

%let value = 9;
%let value2 = 5;
%let newval = %eval(&value / &value2);

Which one of the following is the resulting value of the macro variable NEWVAL?

  1. 1
  2. 2
  3. 1.8
  4. null

Answer(s): A



The following SAS program is submitted:

%let lib = %upcase(sasuser);
proc sql;
select nvar
from dictionary.tables
where libname = "&lib";
quit;

Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

  1. no result set
  2. a syntax error in the log
  3. a report showing the names of each table in SASUSER
  4. a report showing the number of columns in each table in SASUSER

Answer(s): D



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?

  1. Macro variable C has a value of 564.
  2. Macro variable C has a value of 1452.
  3. Macro variable GROUP has a value of 564.
  4. Macro variable GROUP has a value of 1452.

Answer(s): A



Page 19 of 47



Post your Comments and Discuss SAS Institute A00-212 exam with other Community members:

Nick commented on October 05, 2023
Just bought it, hope for the best
Anonymous
upvote

Abdul SK commented on September 28, 2023
Please upload it
Anonymous
upvote

SK commented on April 21, 2021
You cannot pass this examinations without the help of this braindumps questions.
SINGAPORE
upvote

Miguel commented on April 09, 2020
Muchas Gracias!
I write my exam last week and got a score of 87%. Good and happy for now.

MEXICO
upvote