See Updating PROC SQL and SAS/ACCESS Views ... See CASE expression for a description of CASE expressions. To add, drop, or modify a column's definition or attributes, use the ALTER TABLE statement, ...

It is also useful if you are running SQL statements from an SQL application in ... You can use an INSERT statement to add rows. Use an ALTER statement to modify column attributes or to add or drop ...