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 3 )

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

The following SAS program is submitted. filename sales ('external-file1' 'external-file2');

filename sales ('external-file1' 'external-file2');
data new;
infile sales;
input date date9. company $ revenue;
run;

Which one of the following is the result of including the FILENAME statement in this program?

  1. The FILENAME statement produces an ERROR message in the SAS log.
  2. The FILENAME statement associates SALES with external-file2 followed by external-file1.
  3. The FILENAME statement associates SALES with external-file1 followed by external-file2.
  4. The FILENAME statement reads record 1 from external-file 1, reads record 1 from external-file 2, and combines them into one record.

Answer(s): C



The SAS data set ONE contains the variables X, Y, Z, and W.
The following SAS program is submitted:
proc transpose data = one
out = trans
name = new;
by x;
var y;
run;

Which one of the following contains all the names of the columns created by the TRANSPOSE procedure?

  1. X, Y, Z, and W
  2. _NAME_, X, and Y
  3. new, X, and COL1
  4. new, X, Y, and _COL1_

Answer(s): C



Given the following SAS data set ONE:

ONE
JOB LEVEL SALARY
ACC 2 300
SEC 1 100
SEC 2 200
MGR 3 700
ACC 1 .
ACC 3 .
MGR 2 400
The following SAS data set TWO is created:
TWO
JOB LEVEL BONUS
ACC 2 30
MGR 3 70
MGR 2 40

Which one of the following SAS programs creates data set TWO?

  1. proc sql;
    create table two as
    select job, level, salary * 0.1 as bonus
    from one
    where bonus > 20;
    quit;
  2. proc sql;
    create table two as
    select job, level, salary * 0.1 as bonus
    from one
    where salary > 20;
    quit;
  3. proc sql;
    create table two as
    select job, level, salary * 0.1 as bonus
    from one
    where calculated salary * 0.1 > 20;
    quit;
  4. proc sql;proc sql;
    create table two as
    select job, level, salary * 0.1 as bonus
    from one
    where calculated bonus > 20;
    quit;

Answer(s): D



The following are values of the variable STYLE from the SAS data set
SASUSER.HOUSES:

SASUSERS.HOUSES
OBS STYLE
1 RANCH
2 SPLIT
3 CONDO
4 TWOSTORY
5 RANCH
6 SPLIT
7 SPLIT

The following SAS program is submitted:

proc sql noprint;
select distinct style
into :styles separated by ' '
from sasuser.houses
order by style;
quit;

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

  1. CONDO RANCH SPLIT TWOSTORY
  2. RANCH SPLIT CONDO TWOSTORY
  3. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
  4. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

Answer(s): A



The following SAS program is submitted:
%let value = .5;
%let add = 5;
%let newval = %eval(&value + &add);

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

  1. 5
  2. 5.5
  3. .5 + 5
  4. null

Answer(s): D



Viewing page 3 of 38
Viewing questions 11 - 15 out of 184 questions



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

Join the A00-212 Discussion