Ok, I think I may not have expressed myself clearly.
I'd try to make a better example for my problem...
Suppose you have these two tables of event and population:
data TEST;
length CITY DISTRICT EVENT $5 QTY 8;
input CITY DISTRICT EVENT QTY;
datalines;
City1 Dist1 Even1 2
City1 Dist1 Even2 4
City1 Dist1 Even3 6
City1 Dist1 Even4 4
City1 Dist2 Even1 1
City1 Dist1 Even1 2
City1 Dist1 Even1 4
City2 Dist1 Even4 15
City2 Dist1 Even1 7
City2 Dist2 Even1 9
;;
run;
data POPULATION;
length CITY DISTRICT $5 POP 8;
input CITY DISTRICT POP;
datalines;
City1 Dist1 100
City1 Dist2 123
City2 Dist1 45
City2 Dist2 96
;;
run;
Now on VA I have a cross table with a City > District hierarchy and a filter on events.
What I need is this:
No event filter active:
City Qty Pop Rate
City1 23 223 23/223x10000
City2 31 141 31/141x10000
No event filter active but hierarchy open:
City District Qty Pop Rate
City1 Dist1 22 100 22/100x10000
City1 Dist2 1 123 1/123x10000
City2 Dist1 22 45 22/45x10000
City2 Dist2 9 96 9/96x10000
But if I activate a filter on an event, let's say event1, I need these output:
City Qty Pop Rate
City1 9 223 9/223x10000
City2 16 141 16/141x10000
City District Qty Pop Rate
City1 Dist1 8 100 8/100x10000
City1 Dist2 1 123 1/123x10000
City2 Dist1 7 45 7/45x10000
City2 Dist2 9 96 9/96x10000
So, basically, the Qty depends on the event variable, while the population depends only from City and District variabiles.
