Hello.

To spare you the background, I'll jump straight into describing what I'm stuck on.

Im working with World Value Survey weave 1 trough 6, so everything is on individual level.

I need to calculate national averages of a few variables, to give nation-nested models something to compare to.

So there's one variable for the respondants nation, coded with seemingly random numers corresponding to a list of national names.

I need to calculate the nation average for a few indicators of trust and tolerance.

I'm currently Selecting Cases number by number, stoping to do a manual descriptive statistics and copying the new value into my new variable. Every iteration takes several minutes due to the steps involved.

Just on the fact on how labour-intensive this process is I must assume there is an automated way of doing it, but I cant find anything on the web and my teachers are at a loss.

Help me TalkStats-One, you're my only hope!

To spare you the background, I'll jump straight into describing what I'm stuck on.

Im working with World Value Survey weave 1 trough 6, so everything is on individual level.

I need to calculate national averages of a few variables, to give nation-nested models something to compare to.

So there's one variable for the respondants nation, coded with seemingly random numers corresponding to a list of national names.

I need to calculate the nation average for a few indicators of trust and tolerance.

I'm currently Selecting Cases number by number, stoping to do a manual descriptive statistics and copying the new value into my new variable. Every iteration takes several minutes due to the steps involved.

Just on the fact on how labour-intensive this process is I must assume there is an automated way of doing it, but I cant find anything on the web and my teachers are at a loss.

Help me TalkStats-One, you're my only hope!

Last edited by a moderator: