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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.