Focal Point
[SOLVED] Assigning a value to missing data

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5137018236

August 13, 2013, 04:59 PM
Nathaniel
[SOLVED] Assigning a value to missing data
How can I give a value to any instance where there is missing data. NODATA seems to only change the display without assigning an actual value. I have not had any luck finding anything in the forum that has yet to work for me.

Thanks for any advise.

This message has been edited. Last edited by: <Kathryn Henning>,


7.7.03/8.1.04
Windows, All Outputs
August 13, 2013, 06:46 PM
Waz
Try HNODATA, it should hold the value in a hold file.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 14, 2013, 10:49 AM
Nathaniel
I could not get HNODATA to work, but while I was looking in the documentation for that I found HOLDMISS and then was able to do a DEFINE using IS MISSING to set a value to the null instances.

Thanks for pointing me in the right direction! So glad to finally have this working. Smiler


7.7.03/8.1.04
Windows, All Outputs
August 14, 2013, 01:34 PM
Nathaniel
*update

We found that we can DEFINE the field as itself with MISSING ON. Once we have done that we are able to COMPUTE and use IS MISSING to create a value for any null instances.


7.7.03/8.1.04
Windows, All Outputs