Jung,

I think that what you want to do is DISPLAY missing values as zeroes, rather than actually change their values. To do that, use OPTIONS MISSING='0' (or whatever character you prefer).

Hope this helps.

Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com

jung1975@BELLSOUTH.NET Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 12/20/2004 11:31 AM Please respond to jung1975

To: SAS-L@LISTSERV.UGA.EDU cc: Subject: NULL/Missing value in SAS

Is there anyway I can populate numeric/money fields with Zero if they are null/missing instead of putting the spaces in SAS?

Is there any SAS code example that I can use to convert spaces( null value) to Zero in numeric/money field?