BookmarkSubscribeRSS Feed
justusjillella
Fluorite | Level 6

Hi, 

 

Can someone tell how to make missing values as 0 in SAS VA cross tab. Please note that  there is no missing values in the source dataset for that column

2 REPLIES 2
JosvanderVelden
SAS Super FREQ
Have you tried using a format?
The format may replace the . by 0 for those columns?
NOTE: I have not tested if this works for a cross-tab.

Best regards, Jos
BrunoMueller
SAS Super FREQ

Maybe you look at a crossing, where there is not data so it is displayed as missing.

Which version of VA are you using? Newer versions of VA display the "no data" condition differently, see image below:

Bruno_SAS_0-1603103904502.png

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 2 replies
  • 306 views
  • 0 likes
  • 3 in conversation