I have a concordance (for a large number of codes) that has a structure
something like this:
CATEGORY A CATEGORY B
1 10
20
30
40
-------------------------------
2 10
50
60
-------------------------------
I have values corresponding to each CATEGORY B code and want to aggregate
these into CATEGORY A codes. My problem is that when the code appears in
both CATEGORY A and CATEGORY B, as in the of CATEGORY B code "10", I wish
to add only 50% of "10" into CATEGORY A code "1" and 50% into CATEGORY B
code "2". Any ideas?
