When you use the COALESCE() function with a single argument, the generated SQL query is passed down to the RDBMS without the argument.

For example, the SQL generated query that is passed to the database is shown in the NOTE below:

35         proc sql;
36                  create table class_age as
37                  select
38                     
39                     coalesce(age) as age_var
40                     
41                 from lib1.class;
42         quit;

NOTE: Implicit SQL:  select COALESCE() as age_var from CLASS TXT_1

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Base SAS 9.4_M3 is available at:

A fix for this issue for Base SAS 9.4_M2 is available at: