Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. SAS Institute
  5. A00-212

SAS Institute A00-212 Exam Questions
SAS Advanced Programming Exam for SAS 9 (Page 3 )

Updated On: 16-Feb-2026
Page 3 of 38
PDF with 184 Questions

The following SAS program is submitted:

%micro test(var);
%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;
%let type=%index(&jobs, &var);
%put type = &type;
%mend;
%test(SMITH)

What is the value of the macro variable TYPE when the %PUT statement executes?

  1. 0
  2. Null
  3. 6
  4. 3

Answer(s): C



The following SAS program is submitted:

%macro check(num=4);
%let result=%eval(&nm gt 5);
%put result is &result;
%mend;
%check (num=10)

What is written to the SAS log?

  1. result is true
  2. result is 10 gt 5
  3. result is 1
  4. result is 0

Answer(s): C



The following SAS program is submitted:

data temp;
length 1 b 3 x;
infile 'file reference';
input a b x;
run;

What is the result?

  1. The data set TEMP is not created because variables A and B have invalid lengths
  2. The data set TEMP is created, but variable X is not created
  3. The data set TEMP is not created because variable A has an invalid length
  4. The data set TEMP is created and variable X has a length of 8

Answer(s): C



Given the SAS data sets ONE and TWO:


The following SAS program is submitted:
Proc sql;
Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year,
Quit;
The following output is desired:

Which JOIN operator completes the program and generates the desired output?

  1. FULL JOIN
  2. INNER JOIN
  3. LEFT JOIN
  4. RIGHT JOIN

Answer(s): A



Given the SAS data set SAUSER.HIGWAY:
SASUSER.HIGHWAY


The following SAS program is submitted:

%macro highway;
proc sql nonprint;
%let numgrp=6;
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?

  1. 2
  2. 6
  3. 0
  4. 5

Answer(s): A






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

Join the A00-212 Discussion