The EXECUTE statement sends dynamic non-query, DBMS-specific SQL statements to the DBMS and processes those statements. In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly ...

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.

You can write create table statements in access, but at least in Access XP and before, you can't write one that will fully describe a table. Many of the access specific features are inaccessible.

The DESCRIBE VIEW statement writes a view definition to the SAS log. If you use a PROC SQL view in the DESCRIBE VIEW statement that is based on or derived from another view, you may want to use the ...