SAS_VA - replace missing values to zero

[Pato485]

How can i replace missing values in SAS VA to zero? Need to change it in source or can i do it by counting new formula? or? I need to change missing to 0, look at the graph.

Thank for help. 

[ed_sas_member]

Hi @Pato485 

Does the following thread answer your question?

https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-missing-values-with-0-in-cross-tab/td-p/...

It seems that you can create a calculated item from the numeric and replace the missing values with 0, like

IF (your variable missing) RETURN 0 

                                                              ELSE 'your variable'n

and name it as your variable2, then use that variable in your outputs.

[Pato485]

But problem is, that in my source, i dont have missing... i have just production values, where production was... So one person can have all values set, and some person doesnt... There is no missing. I just want to set, if variable is missing in the graph, put there value 0. Can i? Date is set as date, production as number.