Nicholas,   Check this useful post: https://communities.sas.com/t5/New-SAS-User/Moving-Correlation-For-multiple-variables/td-p/559190   Best, K ... View more

One correction I needed a comma: Proc SQL; select b.this, a.this, case When b.rate <0.25 Then coalesce(somenum/b.rate,0) ... View more

The following will replicate the same behavior as IFERROR. Proc SQL; select b.this, a.this, case When b.rate <0.25 Then coalesce(somenum/b.rate.0)  For more information please see: Function documentation: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/sqlproc/p1gdr5t7sd3g3qn1d7fg23zuwzml.htm#! An example: https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473712.htm   Best, K ... View more