The macro %aml_get_observation_count generates an error similar to the following when counting table observations:

NOTE: AML: The data set SEG_KC.FSK_LOV has 150 observations.
ERROR: A character operand was found in the %EVAL function or %IF condition
       where a numeric operand is required. The condition was: &num_obs eq -1
ERROR: The macro LOV_REPORT will stop executing.

The macro is used by the following SAS^® Anti-Money Laundering programs: lov_report.sas; riskranking.sas; save_near_neighbor_profile.sas; send_alert_reminder.sas; send_case_reminder.sas; and update_alert_history.sas.

The problem occurs because the macro %aml_get_observation_count executes a PROC SQL, which is invalid with macro variable assignment.

Here is an example:

To fix this problem, associate the macro variable to the global variable aml_obs_count that is created by %aml_get_observation_count, as follows:

Operating System and Release Information

A fix for this issue for SAS Anti-Money Laundering 5.1_M1 is available at:

A fix for this issue for SAS Anti-Money Laundering 5.1 is available at: