Displaying data - SAS Support Communities

Fluorite | Level 6

Fluorite | Level 6

Displaying data

Posted 03-05-2021 05:30 AM (1131 views)

I have a table which has null in some of the cells, how do I make it display 0 in the axis instead of dash, blank or missing?

3 REPLIES 3

SAS Super FREQ

SAS Super FREQ

Re: Displaying data

Posted 03-05-2021 11:23 AM (1077 views) | In reply to cokello

Which version of SAS Visual Analytics are you using?

-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center

Fluorite | Level 6

Fluorite | Level 6

Re: Displaying data

Posted 03-05-2021 01:48 PM (1055 views) | In reply to Madelyn_SAS

I am using SAS Visual Analytics 8.5

SAS Super FREQ

SAS Super FREQ

Re: Displaying data

Posted 03-05-2021 02:17 PM (1042 views) | In reply to cokello

You could create an IF/THEN calculated item that returns 0 if a value missing. For example:

IF ( 'Salary'n Missing )
RETURN 0
ELSE 'Salary'n

-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!