The SELECT clause in the program is written incorrectly. Columns that are listed in the clause must be separated by commas, not just blanks.

There are two statements, the PROC SQL statement and the SELECT statement. The SELECT statement contains three clauses: the SELECT clause, the FROM clause, and the ORDER BY clause.

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.

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.

In the FROM clause, you list the names of the tables to be queried, separated by commas.

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, (optional) 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.

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.

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.