Question 21 : If you specify a CREATE TABLE statement in your PROC SQL step, |

Question 21 : If you specify a CREATE TABLE statement in your PROC SQL step,

1. the results of the query are displayed, and a new table is created.
2. a new table is created, but it does not contain any summarization that was specified in the PROC SQL step.

3. a new table is created, but no report is displayed.

4. results are grouped by the value of the summarized column.

Correct Answer : 3

Exp : Creating a Table without Rows
[1] The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to tables that are supported by SAS. Use this form when you want to create a new table with columns that are not present in existing tables. It is also useful if you are running SQL statements from an SQL application in another SQL-based database.

[2] The second form uses a LIKE clause to create a table that has the same column names and column attributes as another table. To drop any columns in the new table, you can specify the DROP= data set option in the CREATE TABLE statement. The specified columns are dropped when the table is created. Indexes are not copied to the new table.

Both of these forms create a table without rows. You can use an INSERT statement to add rows. Use an ALTER TABLE statement to modify column attributes or to add or drop columns.

Creating a Table from a Query Expression
[3] The third form of the CREATE TABLE statement stores the results of any query-expression in a table and does not display the output. It is a convenient way to create temporary tables that are subsets or supersets of other tables.

When you use this form, a table is physically created as the statement is executed. The newly created table does not reflect subsequent changes in the underlying tables (in the query-expression). If you want to continually access the most current data, then create a view from the query expression instead of a table

The CREATE TABLE statement enables you to store your results in a SAS table instead of displaying the query results as a report.

490 SAS Base Certificarion Practice Questions for A00-211 | 356+ SAS Advanced Certification Practice Questions for A00-212