SAS Advanced Programming Exam review with certified solutions 2025. Terms in this set (174) Which of the clauses in the PROC SQL program below is written incorrectly? proc sql; select style sq feet bedrooms from choice. Houses where sq feet ge 800; a.

SAS Advanced
Programming Exam
review with certified
solutions 2025.


Terms in this set (174)

,Which of the clauses in the a
PROC SQL program
below is written
incorrectly? proc sql;
select style sq feet
bedrooms from choice.
Houses where sq feet
ge 800;


a. SELECT
b. FROM
c. WERE
d. both a and c



a
How many statements does
the program below
contain? proc sql; select
grapes, oranges, grapes +
oranges as sum sales from
sales. Produce order by
sum sales;


a. two
b. three
c. four
d. five

,Complete the following PROC b
SQL query to select the
columns Address and
Sq Feet from the table
List. Size and to select
Price from the table
List. Price. (Only the
Address column appears in
both tables.) proc sql;
_______________ from
list. size, list. price;


a. select address, sq
feet, price
b. select size. address,
sq feet, price
c. select price. address,
sq feet, price
d. either b or c



b
Which of the clauses below
correctly sorts rows by the
values of the columns Price
and Sq Feet?


a. order price, sq feet
b. order by price, sq feet
c. sort by price sq feet
d. sort price sq feet

, Which clause below c
specifies that the two
tables Produce and
Hardware be queried?
Both tables are located in a
library to which the libref
Sales has been assigned.


a. select
sales.producesales.hardwa
re
b. from
sales.producesales.hardwa
re
c. from
sales.produce,sales.hardw
are
d. where
sale.produce,sales.hardwa
re

Complete the SELECT clause b
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,
______________


a. Profit=price-cost
b. price-cost as Profit
c. profit=price-cost
d. Profit as price-cost