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
SAS Advanced Programming Exam for SAS 9 (Page 5 )

Updated On: 26-Jan-2026
Page 5 of 38
PDF with 184 Questions

The following SAS program is submitted:
%let var = chicago, 1;
data a;
var = 'new york, 2';
newvar = %scan(&var,2,%str());
run;

Which one of the following explains why the program fails to execute?

  1. The %STR() is invalid syntax.
  2. The %SCAN function does not exist.
  3. The %SCAN function has too many arguments.
  4. The macro variable VAR does not get created properly.

Answer(s): C



This question will ask you to provide a segment of missing code.
The following SAS program submitted:


Which segment of code will successfully run an in-line view?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Answer(s): D



Given the SAS data sets:


The SAS program is submitted:


What output will be produced?

  1. Name
    ----------
    Lauren
    Smith
    Patel
    Farmer
    Chang
    Hiller
  2. Name
    ----------
    Chang
    Chang
    Lauren
  3. Name
    ----------
    Patel
    Chang
  4. Name
    ----------
    Lauren
    Patel
    Chang
    Chang

Answer(s): A



Given the SAS data sets:


A SAS program is submitted and the following is written to SAS to:


What would allow the program to successfully execute without errors?

  1. Qualify the column names with the table names.
  2. Replace the 104 with:
    Where EMPLOYEE.Name = Any (Select names separated with ‘,’
    From WORK.NEWEMPLOYEE
    Where Salary > 40000);
  3. Replace the where clause with:
    Where EMPLOYEE.Name = (Select Names delimited with ‘,’
    From WORK.NEWEMPLOYEE
    Where Salary > 40000);
  4. Replace the equal sign with In operator.

Answer(s): B



Given the data sets:


The following SAS program is submitted:


Which result set would be generated?

  1. 100
  2. 200
  3. 300
  4. 400

Answer(s): A



Viewing page 5 of 38
Viewing questions 21 - 25 out of 184 questions



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

Join the A00-212 Discussion