BookmarkSubscribeRSS Feed
xefere
Calcite | Level 5

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


Missing Values.jpg
3 REPLIES 3
Astounding
PROC Star

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
Calcite | Level 5

And where to I set this options in VA?

mccl4488
Fluorite | Level 6

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. 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4229 views
  • 0 likes
  • 3 in conversation