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
I want to show 2011,2014,2015 as 0 across multiple measures.
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.
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.