How to set Missing=0 or " "

[RPYee]

I've looked at several different solutions on how to replace the "." when values are missing with either a space or a 0.  I know I succeeded once before, but it's been a while and I have absolutely no idea where I did it.  The current focus is for the results of a query.  I will never understand the notion of using a dot when missing.  What's wrong with just leaving it blank??  Sigh

Can someone PLEASE draw me a map with a somewhat detailed list of steps in how to find it?  Tools > Options > LOST 😞

Thanks for your patience and help!

Rita Yee

Project Engineer

FedEx Express - Global Trade Services

PS, I am using Enterprise Guide interface and have no experience with coding

[FredrikE · Accepted solution]

You can add the option "missing=0" and it will only affect the presentation not the actual figures.

If you want to change the figure you can create calculated members using ifn(var=.,0,var).

You can set the option in Tools -> Options SAS-program. I have a swedish version, but I hope you can figure it out 🙂

//Fredrik