Free Online SAS Institute A00-232 Practice Test

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

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?

Complete the SELECT clause below to create a new column named Profit by subtracting the values of the column Cost from those of the column Price. select fruit,cost,price, ________________

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