Hello

I am trying to do the following compute statement.

DEFINE
INTERVAL/I4 WITH POLICYNUMBER=IF INTERVAL LT 400 THEN INTERVAL + 1 ELSE 1;
CONFNUMB/I4 WITH POLICYNUMBER= IF INTERVAL EQ 400 THEN CONFNUMB + 1;
END

TABLE FILE LACAPP1
---
--
COMPUTE NEGPOS/A1 = IF ( ( CONFNUMB / 3 ) * 3 ) EQ CONFNUMB THEN 'P' ELSE 'N';
------


What it does determines if the number is evenly divisible if so it puts a P if not and N.

This used to work but now for some reason it says every confirmation number is a P.

CONFNUMB is an integer also.

Any Help

Dan

Only thing I can figure is that the division inside the compute no longer cares that the referenced field is integer. It must be doing a floating point compute. YOu could do this, I would think:

COMPUTE CONFNUMX/I4 = CONFNUMB / 3;
COMPUTE NEGPOS/A1 = IF (CONFNUMX * 3 ) EQ CONFNUMB THEN 'P' ELSE 'N';

Thanks

That worked

Moyer,
You could also use the IMOD function:

COMPUTE NEGPOS/A1=IF IMOD(CONFNUMB,3,'I1') EQ 0 THEN 'P' ELSE 'N';