SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training

SAS Institute A00-212 Online Training

The questions for A00-212 were last updated at Dec 25,2024.

Exam Code: A00-212
Exam Name: SAS Advanced Programming Exam for SAS 9
Certification Provider: SAS Institute
Latest update: Dec 25,2024

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?

A . 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;
B . proc sql;
Create table combine as
Select one.id,
Name, salary from one full join two where one.id=two.id;
Quit
C . proc sql;
Create table combine as
Select one.id,name,salary from one inner join two on one.id=two.id
Quit
D . 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;

Reveal Solution Hide Solution

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?

A . proc sql;
Contents table testdata.one;
Quit;
B . proc sql;
Describe table testdata.one;
Quit;
C . proc sql;
describe testdata.one;
Quit;
D . proc sql;
Contents testdata.one;
Quit;

Reveal Solution Hide Solution

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

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

Reveal Solution Hide Solution

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?

A . proc sql;
Drop table one;
Quit;
B . proc sql;
Remove table one;
Quit;
C . proc sql;
Delete table one;
Quit;
D . proc sql;
Delete from one;
Quit;

Reveal Solution Hide Solution

Question #25

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?

A . COMPANY and DEPT only
B . COMPANY, COUNTRY and DEPT
C . COMPANY Only
D . COMPANY and COUNTRY only

Reveal Solution Hide Solution

Question #26

What is the purpose of the SASFILE statement?

A . It requests that SAS data set be opened and loaded into SAS memory one page at a time
B . It requests that a SAS data set the opened and loaded into SAS memory one variable at a time
C . It requests that a SAS data set be opened and loaded into SAS memory one observation at a time
D . It requests that a SAS data set be opened and loaded into SAS memory in its entirety

Reveal Solution Hide Solution

Question #27

Given the SAS date sets CLASS1 and CLASS2

CLASS1 CLASS2

NAME COURSE NAME COURSE

Lauren MATH1 Smith MATH2

Patel MATH1 Farmer MATH2

Chang MATH1 Patel MATH2

Chang MATH3 Hiller MATH2

The following SAS program is submitted:

Proc sql;

Select name from CLASS1

<insert SQL set operator here>

select name from CLASS;

quit;

The following output is desired

NAME

Chang

Chang

Lauren

Which SQL set operator completes the program and generates the desired output?

A . UNION ALL
B . EXCEPT ALL
C . INTERSECT ALL
D . OUTER UNION ALL

Reveal Solution Hide Solution

Question #28

The following SAS program is submitted:

data new (bufnp=4);

set old(bufno=4);

run;

Why are the BUFNO options used?

A . To reduce the number I/O operations
B . To reduce network traffic
C . To reduce memory usage
D . To reduce the amount of data read

Reveal Solution Hide Solution

Question #29

The following SAS program is submitted:

options reuse=YES;

data sasuser RealEstate(compress=CHAR);

set sasuser houses;

run;

What is the effect of the REUSE=YES SAS system option?

A . It tracks and recycles free space
B . It allows a permanently stored SAS data set to be replaced
C . It allows users to access the same SAS data set concurrently
D . It allows updates in place

Reveal Solution Hide Solution

Question #30

The SAS data set ONE contains fifty million observations and contains the variable PRICE, QUANTITY, FIXED and VARIABLE.

Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

A . data two;
Set one;
Where totrev>1000;
Totrev=sum(price*quantity);
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;
B . data two;
Set one;
totrev=sum(price*quantity);
where totrev>1000;
totcost=sum(fixed,variable);
profit=sum(totrev,-totcost);
run;
C . data two;
Set one;
Totrev=sum(price*quantity);
If totrev>1000;
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;
D . data two;
Set one;
Totrev = sum(price*quantity);
Totcost= sum(fixed,variable);
If totrev>1000;
Profit=sum(totrev,-totcost);
Run;