BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RPYee
Quartz | Level 8

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

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

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 🙂

 

image.png

//Fredrik

View solution in original post

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

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 🙂

 

image.png

//Fredrik

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 4080 views
  • 0 likes
  • 2 in conversation