The following sas program is submitted let

QUESTION 21
The following SAS program is submitted:
%let lib=%upcase(sauser);
proc sql;

A00-212
Actualtests.com - The Power of Knowing
select nvar form dictionary.tables where libname='&lib";
quit;
Several SAS data sets exist in the SAUSER library.
What is generated as output?
A. A report showing the names of the columns in each table in SASUSER
B. A report showing the number of columns in each table in SASUSER
C. A report showing the numeric columns in each table in SASUSER
D. A report showing the number of numeric columns in each table in SASUSER
Answer: B
QUESTION 22
The following SAS program is submitted:
%macro loop;
data one;
%do I=1 %to 3;
var&I=&I;%
end
run;
%mend;
%loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value
is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?
QUESTION 23
Given the SAS data sets ONE and TWO:

A00-212
Actualtests.com - The Power of Knowing
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;
QUESTION 24
The following SAS program is submitted:
%let first=yourname;
%lest last=first
%put &&last;
What is written to the SAS log?
QUESTION 25
The following SAS program is submitted:
proc contents data = testdata.one;

A00-212
Actualtests.com - The Power of Knowing
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;
Answer: B