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
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
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.