PROC SQL also supports the ANSI SQL function COALESCE. COALESCE accepts multiple column names of the same data type. The COALESCE function returns the first argument whose value is not a SAS missing ...

The procedure rejects SQL SELECT statements. The UPDATE statement causes ... from a SAS data set into a DB2 table as rows in the table. To use the INSERT function, name the SAS data set that contains ...