outputing a frequency sum of 0 in a list table

[r0oki3]

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.

[RW9]

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]

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

[r0oki3 · Accepted solution]

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

[SASKiwi]

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