topic outputing a frequency sum of 0 in a list table in SAS Visual Analytics

outputing a frequency sum of 0 in a list table

r0oki3 — Wed, 28 Nov 2018 14:41:27 GMT

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.

Re: outputing a frequency sum of 0 in a list table

RW9 — Wed, 28 Nov 2018 15:19:31 GMT

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.

Re: outputing a frequency sum of 0 in a list table

r0oki3 — Wed, 28 Nov 2018 15:22:31 GMT

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

Re: outputing a frequency sum of 0 in a list table

r0oki3 — Mon, 03 Dec 2018 12:54:07 GMT

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

Re: outputing a frequency sum of 0 in a list table

SASKiwi — Mon, 03 Dec 2018 20:10:58 GMT

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