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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.