SUPPORT / SAMPLES & SAS NOTES
Problem Note 48626: The macro %aml_get_observation_count generates an error when counting table observations
 |  |  |  |  |
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:
%let num_obs = %aml_get_observation_count(table=seg_kc.fsk_lov);
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:
%aml_get_observation_count(table=seg_kc.fsk_lov);
%let num_obs = &aml_obs_count;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows Vista | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| HP-UX IPF | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Solaris for x64 | 5.1 | 5.2 | 9.3 TS1M2 | 9.3 TS1M2 | ||