topic Handling missing values in SAS Viya in SAS Visual Analytics

Handling missing values in SAS Viya

pavaniprudhvi — Tue, 06 Oct 2020 16:58:59 GMT

I am currently using SAS Viya for learners and have been facing challenges to replace null values with mean value. I tried one of the suggestions given in the below link:

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

But I received an error stating "calculations must be one liner and have arithmetic operations"

My data contains more than 30% of null values and I definitely need to preprocess it for the analysis.

Thanks in advance

Re: Handling missing values in SAS Viya

JosvanderVelden — Tue, 06 Oct 2020 17:23:31 GMT

Are you using pipelines (SAS VDMML)?

Re: Handling missing values in SAS Viya

pavaniprudhvi — Tue, 06 Oct 2020 23:08:17 GMT

Yes

Re: Handling missing values in SAS Viya

JosvanderVelden — Mon, 19 Oct 2020 08:59:54 GMT

Does this help: https://blogs.sas.com/content/sgf/2020/01/16/missing-data-quickly-impute-values-using-sas-viya/ ?