I am getting few null values in the report.
I want to display them as zero('0') when it is null.
I am using
BSTRF1/A40 MISSING ON= IF BSTRF EQ MISSING THEN '0' ELSE BSTRF;
It is still displaying as null

This message has been edited. Last edited by: Kerry,

Hi,

You may try to set the NODATA to zero

 SET NODATA = 0 

Best Regards,

Jimmy Pang

Missing values are a pain.


This may work.
BSTRF1/A40 MISSING OFF= IF BSTRF IS MISSING THEN '0' ELSE BSTRF;

As mentioned by Jimmy, SET NODATA will work, but will apply to all fields.

If this is from a hold file, then you could also add HOLD AS ... MISSING OFF