Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Replace missing values with 0 in cross tab

Reply
New Contributor
Posts: 4

Replace missing values with 0 in cross tab

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


Missing Values.jpg
Super User
Posts: 5,365

Re: Replace missing values with 0 in cross tab

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.

New Contributor
Posts: 4

Re: Replace missing values with 0 in cross tab

And where to I set this options in VA?

Occasional Contributor
Posts: 7

Re: Replace missing values with 0 in cross tab

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. 

 

Ask a Question
Discussion stats
  • 3 replies
  • 408 views
  • 0 likes
  • 3 in conversation