Inserting Rows of Data into a Table
Overview
After you have created an empty
table, you will want to insert rows of data. You might also want to
insert additional rows of data into tables that already contain data.
You can use the INSERT statement in three different ways to insert
rows of data into existing tables, either empty or populated.
Note: You can also use the INSERT statement to insert rows
of data in a single table that underlies a PROC SQL view. To learn
more about PROC SQL views, see
Creating and Managing Views Using PROC SQL.
Method of Inserting
Row
|
Example
|
---|---|
insert values by column
name by using the SET clause
|
proc sql; insert into work.discount set destination='LHR', begindate='01MAR2000'd, enddate='05MAR2000'd, ... |
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.