MaxValue Function

Format

d = maxvalue(item_name ‖ value_set_name);

Description

The maxvalue function returns the maximum valid value for an item or value set. If a numeric item_name is provided, the function looks at the current value set for the item, or if no value set exists, looks at the item itself (returning a maximum value based on the item's number of digits). If a numeric value_set_name is provided, the function returns the maximum range or discrete value in the value set.

Return Value

The function returns the maximum valid value for an item or value set.

Example

PROC EDUCATION_CURRENT

if EDUCATION_CURRENT = 1 and AGE > maxvalue(EDUCATION_CURRENT_PRESCHOOL_VS) then
errmsg("Someone aged %d cannot be currently attending preschool.", AGE);
reenter;
endif;