Question 1

If a substring is not found in a string, the FIND function returns which value?

Options :

A : 0

B : 2

C : 1

D : Not found.

Answer: A

Question 2

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

Question 3

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 4

Which of the following is false?

Options :

A : By default, the INTO clause in PROC SQL does not remove leading and training blanks before assigning macro variable values.

B : The SYMPUTX routine can be used to create a macro variable during execution of the DATA step.

C : In the DATA step, the SYMPUTX routine automatically converts numeric values to character strings before assigning values to macro variables.

D : The SYMPUTX routine can be used to create a macro variable during execution of a PROC SQL query.

Answer: D

Question 5

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

Free A00-232 Mock Exam – Practice Online Confidently

Buying Options: