Handling Errors in Row Insertions
Overview
When you add rows to a table that
has integrity constraints, PROC SQL evaluates the new data to ensure
that it meets the conditions that are determined by the integrity
constraints. If the new (or modified) data complies with the integrity
constraints, the rows are added. However, if you add data that does
not comply with the integrity constraints, the rows are not added.
To find out whether rows of data have been successfully added, you
need to check the SAS log.
Note: PROC SQL also evaluates changes
that are made to existing data by using the UPDATE and DELETE statements.
These statements are discussed later in this chapter.
Example
In a previous section of this chapter, the following PROC SQL ...
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.