Free A00-212 Exam Braindumps (page: 20)

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






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

A00-212 Discussions & Posts