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

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

The following SAS program is submitted:

Data sasuser.history;
Set sasuser.history(keep=state x y
Rename = (state=ST));
Total=sum(x, y);
Run;

The SAS data set SASUSER.HISTORY has an index on the variable STATE. Which describes the result of submitting the SAS program?

  1. The index on STATE is deleted and an index on ST is created
  2. The index on STATE is recreated as an index on ST
  3. The index on STATE is deleted
  4. The index on STATE is updated as an index on ST

Answer(s): C



Which one of the following techniques concatenates data in SAS?

  1. the APPEND procedure
  2. the DATA step with a MERGE statement
  3. the DATA step with a COMBINE statement
  4. the INTERSECT operator in the SQL procedure

Answer(s): A



In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

  1. data three;
    set one;
    set two key = char1;
    run;
  2. data three;
    set one;
    if char1 in ('new york' 'los angeles');
    run;
  3. data three;
    set one;
    where char1 in ('new york' 'los angeles');
    run;
  4. proc sql;
    create table three as
    select *
    from one, two
    where one.char1 > two.char1;
    quit;

Answer(s): A



Given the following SAS data set ONE:

ONE
CATEGORY AGE SALARY BONUS
M 28 200 20
M 25 100 10
M 28 300 10
M 33 300 30
F 18 100 50
F 25 200 10
F 35 400 50

The following SQL program is submitted:
proc sql;
create table two as
select distinct age
from one
where age < 33;
quit;

How many rows are written to the SAS data set TWO?

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

Answer(s): A



Which one of the following should be avoided when creating and using an SQL procedure view?

  1. using a HAVING clause
  2. using summary functions
  3. referencing a view multiple times in the same program
  4. creating views on tables whose structures remain constant

Answer(s): C



Viewing page 2 of 38
Viewing questions 6 - 10 out of 184 questions



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

Join the A00-212 Discussion