How to set Missing=0 or " "

RPYee — Thu, 01 Feb 2018 02:54:22 GMT

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

Re: How to set Missing=0 or " "

FredrikE — Thu, 01 Feb 2018 08:05:14 GMT

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

topic Re: How to set Missing=0 or " " in SAS Enterprise Guide

How to set Missing=0 or " "

Re: How to set Missing=0 or " "