We're still not getting each other's points.
Say this is how I envision your data:
Code: Select all
ID RegA RegB SomeVariable?
1 1 1 ?
2 1 1 ?
3 1 2 ?
4 1 2 ?
5 2 3 ?
6 2 3 ?
7 2 4 ?
8 2 4 ?
10 2 4 ?
Each row is a subject, and each of them will have a variable which you called region A and region B that represent in which regions they were and they are currently living.
My questions are:
1) Why are there two nationals? Wouldn't they all be one nation? (Not familiar with how England divides its land). But I am guessing that Regions are smaller units withing "Nation", which operates like a province?
2) You kept saying "Score" of region, "Score" of nation... what is that score? Is it some kind of variables that is different for each individual?
3) Continued from 2, when you list the formula like "(district A/national A) as %", I am not sure what "district A" and "national A" represent. If I know all these, the syntax should be easy.
I guess it'd be best if you can just refer to your own data set and type up like 10 cases with numbers and region A and region B and all other stuff and tell me how you'd like new variable to look like. Otherwise I will let other users help you.