I have a column that i have used a CNT.DST on, but now i would like to subtract 1 from that column unless it's value is already 1.

I can accomplish this using a hold file, but i would like to do this in the original procedure.
Hopefully it's a simple feature i'm overlooking.

EXAMPLE:

TABLE FILE CAR
SUM
CNT.DST.MODEL AS 'COUNT,DISTINCT,MODEL'
BY CAR
ON TABLE NOTOTAL
END

I need a column with CNT.DST.MODEL minus 1 if it's greater than 1.

Thanks ahead.

This message has been edited. Last edited by: Joe Beydoun,

Is this what you want?

TABLE FILE CAR
SUM
COMPUTE MDL/I8 = CNT.DST.MODEL;
COMPUTE MLD/I8 = IF MDL GT 1 THEN MDL - 1 ELSE MDL;
BY CAR
ON TABLE NOTOTAL
END

Thanks a ton Prarie, I did the same earlier but as a decimal and it blew up, didn't realize it had to be integer.

You can also use column notation

 TABLE FILE CAR
SUM 
   CNT.DST.MODEL
COMPUTE MLD/I8 = IF C2 GT 1 THEN C2 - 1 ELSE C2;
BY CAR
ON TABLE NOTOTAL
END 

Sweet stuff JG, do you know of a good document with focus code? Some of this simple stuff i'm discovering could have save me a ton of time.

This should be a bookmark in everyone's web browser: WebFOCUS Documentation - v7.6