Displaying data - SAS Support Communities

Fluorite | Level 6

Fluorite | Level 6

Displaying data

Posted 03-05-2021 05:30 AM (1006 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 (952 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 (930 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 (917 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