BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
r0oki3
Obsidian | Level 7

I have a list table that contains one category and multiple measures which are updated based on the filters that are selected using the drop down. In certain filter criteria, the category has a measure value of 0 across all measures and that row is not being displayed. How do I make it to display 0 or . when all the measures are 0?

 

Like below all the years are not showing up for a particular set of filters.

category     frequency   measure2

2010           10

2012           12

2013             2

2016           15

 

I want to show 2011,2014,2015 as 0 across multiple measures.

1 ACCEPTED SOLUTION

Accepted Solutions
r0oki3
Obsidian | Level 7

I contacted SAS Support, explained the situation. No way to do it as of now. It may be implemented in the future versions.

View solution in original post

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Simplest method is just to create a template dataset and merge back:

proc sort data=have out=temp nodupkey;
  by category;
run;

... do freq

data want;
  merge freq_output temp;
  by category;
  if freq=. then freq=0;
run;

  

Note that is psuedo code, post test data in the form of a datastep in future please, and also show your code.

r0oki3
Obsidian | Level 7

I am not trying to write code. The table that I am showing is a list object in SAS Visual Analytics. 

r0oki3
Obsidian | Level 7

I contacted SAS Support, explained the situation. No way to do it as of now. It may be implemented in the future versions.

SASKiwi
Opal | Level 21

@r0oki3 - Can you mark your post as answered then?

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