An empirical test of dynamic group conflict theory

In order to test these hypotheses, we will perform an aggregate data analysis at country level. Specifically, we will calculate the attitude change between 2002 and 2007 for every country and link these changes to relevant context indicators of change in economic conditions and minority group size.

Exercise 4.1: Constructing an aggregate data set

Before we can test the hypotheses formulated above, an aggregate dataset needs to be constructed. The aggregate dataset should contain 17 records (one for each country), providing information about attitude change as well as about relevant context variables. We will construct such a dataset in two steps.

Step 1: Construct a variable containing information on attitude change between 2002 and 2007.

Create a dataset containing the country means on the REJECT scale for ESS round 1. This aggregate should contain 17 observations, one for each country (hint: make use of the AGGREGATE statement). Then, create a second aggregate dataset containing the country means for ESS round 3. Merge these two datasets into one file by means of the ‘MATCH FILES’ statement. Finally, compute a new variable, ‘REJECT_CHANGE’, which is the difference between the 2006/7 and the 2002/3 average. Save the newly created dataset.

SPSS Syntax

*Weight data, create temporary dataset, aggregate, match files, compute change and save output. *Please do not forget to change the path 'C:\'.

WEIGHT by dweight.

temporary.
select if essround=1.
aggregate outfile = r1_means.sav
/BREAK = cntry
/meanreject1 = MEAN(reject).

temporary.
select if essround=3.
aggregate outfile = r3_means.sav
/BREAK = cntry
/meanreject3 = MEAN(reject).

MATCH FILES
/ FILE = r1_means.sav
/ FILE = r3_means.sav
/ BY cntry.
EXECUTE.

compute reject_change = meanreject3-meanreject1.
EXECUTE.

SAVE outfile = 'C:\ESS_country.sav'.

Step 2: Merge the information on attitude change with context data

Next, relevant context data have to be added. Via this link, you can download a small dataset (context.sav) containing information on changes in the level of actual competition:

While flowcap measures changes in immigrant group size, gdp_growth and unemp_change reflect changes in economic conditions. Note that some missing values are included.

Merge ‘context.sav’ with the dataset containing the information on attitude change.

SPSS Syntax

*Merge ‘context_sav’ with the dataset containing the information on attitude change. *Please do not forget to change the path 'C:\'.

MATCH FILES
/ FILE 'C:\ESS_country.sav'
/ FILE = 'C:\context.sav'
/ BY cntry.
EXECUTE.

SAVE OUTFILE = 'C:\ESS_country.sav'.

Go to next page >>