A00-212 Exam Questions and Answers | Exam-Dumps (Page: 5)

QUESTION: 21

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:
Data combine;
Merge one two;
By id;
Run;

Which SQL procedure program procedures the same results?

proc sql;
Create table combine as
Select coalesce (one.id, two.id) as id,
Name,salary from one, two where one.id=two.id;
Quit;
proc sql;
Create table combine as
Select one.id,
Name, salary from one full join two where one.id=two.id;
Quit
proc sql;
Create table combine as
Select one.id,name,salary from one inner join two on one.id=two.id
Quit
proc sql;
Create table combine as
Select coalesce (one id, two id) as id,
Name,salary from one full join two on one.id=two.id;
Quit;

Answer(s): D

Reveal Solution Next Question

QUESTION: 22

The following SAS program is submitted:

proc contents data = testdata.one;
run;

Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?

proc sql;
Contents table testdata.one;
Quit;
proc sql;
Describe table testdata.one;
Quit;
proc sql;
describe testdata.one;
Quit;
proc sql;
Contents testdata.one;
Quit;

Answer(s): B

Reveal Solution Next Question

QUESTION: 23

The following SAS program is submitted:

data temp;
array points{2,3} (10,15,20,25,30,35);
run;

What impact does the ARRAY statement have in the Program Data Vector(PDV)?

No variable are created in the PDV
The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV

Answer(s): C

Reveal Solution Next Question

QUESTION: 24

Given the SAS data set ONE:

ONE
NUM VAR
1 A
2 B
3 C

Which SQL procedure program deletes the data set ONE?

proc sql;
Drop table one;
Quit;
proc sql;
Remove table one;
Quit;
proc sql;
Delete table one;
Quit;
proc sql;
Delete from one;
Quit;

Answer(s): A

Reveal Solution Next Question

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?

COMPANY and DEPT only
COMPANY, COUNTRY and DEPT
COMPANY Only
COMPANY and COUNTRY only

Answer(s): A

Reveal Solution Next Question

SAS Institute A00-212 Exam (page: 5)
SAS Institute SAS Advanced Programming Exam for SAS 9
Updated on: 09-Feb-2026

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

QUESTION: 25

SAS Institute A00-212 Exam (page: 5) SAS Institute SAS Advanced Programming Exam for SAS 9 Updated on: 09-Feb-2026

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

QUESTION: 25

SAS Institute A00-212 Exam (page: 5)
SAS Institute SAS Advanced Programming Exam for SAS 9
Updated on: 09-Feb-2026