topic SAS_VA - replace missing values to zero in New SAS User

SAS_VA - replace missing values to zero

Pato485 — Mon, 24 Feb 2020 08:42:11 GMT

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.

Re: SAS_VA - replace missing values to zero

ed_sas_member — Mon, 24 Feb 2020 10:29:16 GMT

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/324440

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.

Re: SAS_VA - replace missing values to zero

Pato485 — Mon, 24 Feb 2020 10:33:59 GMT

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.