QUESTION: 37

Given the following partial SAS log:

NOTE: SQL table SASHELP.CLASS was created line
Create table SASHELP.CLASS(bufsize=4096)
(
Name char(8);
Gender Char(1);
Age num;
Height num;
Weight num
);

Which SQL procedure statement generated this output?

DESCRIBE TABLE
LIST TABLE
VALIDATE TABLE
CREATE TABLE

Answer(s): A

Reveal Solution Next Question

QUESTION: 38

The following SAS program is submitted:

options mprint;
%macro test(parm);
proc &parm data = sashelp.prdsale;
run;
%mend;
%test(print)

What is the result of the MPRINT options?

It has no effect in this example
It writes the original program code inside the marco definition to the SAS log
It writes macro execution messages to the SAS.log
It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log

Answer(s): D

Reveal Solution Next Question

QUESTION: 39

Given the SAS data set ONE:

ONE
REP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted:
Proc sql;
Select rep, avg(cost) as AVERAGE
From one
Group by rep
<insert SQL procedure clause here>
quit;

The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?

having avg(cost) < select avg(cost) from one);
Having avg(cost)>(select avg(cost) from one);
Where avg(cost)>(select avg(cost) from one);
Where calculated average > (select avg(cost) from one);

Answer(s): B

Reveal Solution Next Question

QUESTION: 40

Given the data set SASHELP.CLASS:

SASHELP.CLASS
NAME AGE
Mary 15
Philip 16
Robert 12
Ronald 15
The following SAS program is submitted:
%let value = Philip;
proc print data = sashelp.class;
<insert WHERE statement here>
run;

Which WHERE statement successfully completes the program and procedures a report?

Where upcase(name)=%upcase(&value);
Where upcase(name)="upcase(&value)";
Where upcase(name)=upcase(&value);
Where upcase(name)="%upcase(&value)";

Answer(s): D

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 10)

QUESTION: 37

QUESTION: 38

QUESTION: 39

QUESTION: 40