Question 1

Consider this PROC SQL query:

proc sql;

select flightnumber,

count(*) as Flights,

avg(boarded)

label="Average Boarded"

format=3.

from certadv.internationalflights

group by flightnumber

having avg(boarded) > 150;

quit;

The table Certadv.Internationalflights contains 201 rows, 7 unique values of FlightNumber, 115 unique values of Boarded, and 4 different flight numbers that have an average value of Boarded that is greater than 150. How many rows of output will the query generate?

Options :

A : 150

B : 7

C : 1

D : 4

Answer: D

Question 2

Which clause in the following program is incorrect?

proc sql;

select age,mean(weight) as avgweight

from certadv.employees certadv.health

where employees.id=health.id

group by age;

quit;

Options :

A : SELECT

B : GROUP BY

C : FROM

D : WHERE

Answer: C

Question 3

Which of the following examples correctly defines a macro named Print that defines and resolves parameters named vars and total?

Options :

A :

B :

C :

D :

Answer: D

Question 4

What is the value of the column Position? Position=prxmatch('/Dutch/','Sawyer Dutch Kenai');

Options :

A : 8

B :

2

C : 7

D : 12

Answer: A

Question 5

The keyword ALL cannot be used with which of the following set operators?

Options :

A : OUTER UNION

B : UNION

C : EXCEPT

D : INTERSECT

Answer: A

Higher Test Marks with Free Online A00-232 Exam Practice

Buying Options: