topic Re: Replace missing values with 0 in cross tab in SAS Visual Analytics

Replace missing values with 0 in cross tab

xefere — Fri, 13 Jan 2017 00:05:11 GMT

How do I replace the "." with 0 in a crosstab?

Astounding — Fri, 13 Jan 2017 02:15:56 GMT

You can control the appearance of missing values for numerics:

options missing='0';

That will get you "0" instead of "." although the values might not line up the way you hope.

xefere — Sun, 15 Jan 2017 19:37:20 GMT

And where to I set this options in VA?

mccl4488 — Thu, 24 Aug 2017 21:52:02 GMT

You can create a calculated item from the numeric and replace the missing values with 0.. something like

IF ('Customer Engagement'n missing) RETURN 0

ELSE 'Customer Engagement'n

and name it as Customer_Engagement2 or something - then use that variable in the crosstab.