Therefore, it is not necessary for the SAS System to call the DBMS when it creates a view descriptor. When you use the DBLOAD procedure to create a table, the procedure issues dynamic SQL statements ...

The DESCRIBE TABLE statement writes a CREATE TABLE statement to the SAS log for the table specified in the DESCRIBE TABLE statement, regardless of how the table was originally created (for example, ...

Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.