Free A00-212 Exam Braindumps (page: 7)

Page 7 of 47

The following SAS program is submitted:

%macro location;
data _null_;
call symput ('dept','sales');
run;
%let country=Germany;
%put_global_;
%mend;
%let company = ABC;
%location;

Which macro variables are written to the SAS log?

  1. COMPANY and DEPT only
  2. COMPANY, COUNTRY and DEPT
  3. COMPANY Only
  4. COMPANY and COUNTRY only

Answer(s): A



What is the purpose of the SASFILE statement?

  1. It requests that SAS data set be opened and loaded into SAS memory one page at a time
  2. It requests that a SAS data set the opened and loaded into SAS memory one variable at a time
  3. It requests that a SAS data set be opened and loaded into SAS memory one observation at a time
  4. It requests that a SAS data set be opened and loaded into SAS memory in its entirety

Answer(s): D



Given the SAS date sets CLASS1 and CLASS2
CLASS1 CLASS2
NAME COURSE NAME COURSE
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hiller MATH2

The following SAS program is submitted:

Proc sql;
Select name from CLASS1
<insert SQL set operator here>
select name from CLASS;
quit;
The following output is desired
NAME
Chang
Chang
Lauren

Which SQL set operator completes the program and generates the desired output?

  1. UNION ALL
  2. EXCEPT ALL
  3. INTERSECT ALL
  4. OUTER UNION ALL

Answer(s): B



The following SAS program is submitted:

data new (bufnp=4);
set old(bufno=4);
run;

Why are the BUFNO options used?

  1. To reduce the number I/O operations
  2. To reduce network traffic
  3. To reduce memory usage
  4. To reduce the amount of data read

Answer(s): A



Page 7 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