Coalesce SAS Function

Code: coalesce(argument1,….argumentn)

If you have two columns with the same details but in one column there are missing values and in other, there are non-missing values at some places and vice-versa, then coalesce function returns the value of the first nonmissing argument. This can also be taken from another table column by simple joins.

For example, in the table below, I extracted the data which has missing account ID.

But the other table has account ID information as well and this other table has missing account ID too. So can we combine account ID such that we have full list of Account ID with non missing information?

Yes, this is possible.

with this code:

proc sql;
select FirstName, LastName, Income,
coalesce(c.AccountID,t.AccountID) as AccountID format=10.,
DateTime, MerchantID, Amount
from sq.smallcustomer as c full join
sq.smalltransaction as t
on c.AccountID = t.AccountID;
quit;

Until next time, if you want to learn SAS by an expert and become a Quant developer, reach out to us at [email protected]

Keep Learning and Take Care <3