Overview
Introduction
By using PROC SQL, you
can create, modify, and drop (delete) tables quickly and efficiently.
Many PROC SQL statements are quite versatile, enabling you to perform
the same action in several ways. For example, there are three methods
of creating a table by using the CREATE TABLE statement:
-
creating an empty table (a table without rows) by defining columns
-
creating an empty table that has the same columns and attributes as another table
-
creating a table from a query result.
The following PROC SQL
step uses the CREATE TABLE statement to create an empty table by defining
columns, and uses the DESCRIBE TABLE statement to display information
about the table's structure in the SAS log:
proc sql; create table ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.