The SELECT clause in
the program is written incorrectly. Columns that are listed in the
clause must be separated by commas, not just blanks.
Correct answer: a
There are two statements,
the PROC SQL statement and the SELECT statement. The SELECT statement
contains three clauses.
Correct answer: b
The SELECT clause lists
the columns from both tables to be queried. You must use a prefix
with the Address column because it appears in both tables. The prefix
specifies the table from which you want the column to be read.
Correct answer: b
The ORDER BY clause
specifies how the rows are to be sorted. You follow the keywords ORDER
BY by one or more column names or numbers, separated by commas.
Correct answer: c
In the FROM clause,
you list the names of the tables to be queried, separated by commas.
Correct answer: b
To create a new column
and assign a column alias to the column, you specify the following
in the SELECT clause, in the order shown here: an expression, (optionally)
the keyword AS, and a column alias. The case that you use when you
create the column name is the one that will be displayed in the output.
Correct answer: c
The GROUP BY clause
is used in queries that include one or more summary functions. If
you specify a GROUP BY clause in a query that does not contain a summary
function, your clause is changed to an ORDER BY clause.
Correct answer: c
The CREATE TABLE statement
enables you to store your results in a SAS table instead of displaying
the query results as a report.
Correct answer: d
If you are joining two
tables that contain a same-named column, then you must use a prefix
to specify the table(s) from which you want the column to be read.
Remember that if you join tables that don't contain columns that
have matching data values, you can produce a huge amount of output.
Be sure to specify a WHERE clause to select only the rows that you
want.
Correct answer: b
The table names that
are specified in the FROM clause must be separated by commas. Note
that you can specify columns in the WHERE clause that are not specified
in the SELECT clause.