Exploring, modeling, 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?

Attachment
Respected Advisor
Posts: 4,646

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?

Post a Question
Discussion Stats
  • 2 replies
  • 148 views
  • 0 likes
  • 2 in conversation