By default, every case in your data counts as a single case. However, you can have each case count as more or less than one case as well. This is called weighting.
For instance, the first case in your data may count as 2 cases and the second one as .5 cases. These numbers, the case weights, are contained in a weight variable. Running
WEIGHT BY [...] tells SPSS to treat the values of some weight variable as the active case weights. Note that the status bar informs you whether weighting is in effect or not.
SPSS Weight - Basic Use
SPLIT FILE and
WEIGHT has three main commands.
WEIGHT BY [...].switches a weight variable on. If a weight variable is already in effect, it can be used for setting a different variable as the active case weights.
SHOW WEIGHT.shows which variable is currently used as the weight variable.
WEIGHT OFF.switches the case weights off. After doing so, every case counts as a single case again.
SPSS Weight - Caveats
- In contrast to
FILTER, the active weight variable is saved with the data. So when you start SPSS and open a data file, a weight variable may already be in effect.
- An active weight variable does not only affect the output that's generated. Some data modifications are also influenced by case weights (most notably
- Some users inspect which weight variable is in effect from the menu. When seeing current status: Weight cases (...), they agree with that and click . However, this turns the weight variable off.
Why Would you Weight Cases?
The main scenarios in which you'll want to weight your cases are the following:
- Your sample is not representative for the population you're investigating. For example, you may know that 50% of your target population consist of females but you have 80% females in your sample. In this case you can weight down these 80% of females to 50% of your sample by assigning case weights of .625 to them. Similarly, you can weight up the 20% male respondents to 50% of your sample as well by using weights of 2.5.
Note that these weights don't correspond to the numbers of observations actually made. In this scenario, weights typically have a mean of 1 so the weighted sample size is exactly equal to the unweighted sample size. We'll demonstrate this scenario with the example below.
- In some cases you only have aggregated data. A typical example is a contingency table ("crosstab") presented in a book or article. In this case, case weights will al be positive integers. In this case, weights correspond to the numbers of observations that were actually made.
- You may trick SPSS by using weights in some cases but this is beyond the scope of this tutorial.
SPSS Weight - Example
“We held a small survey on income. Unfortunately, 80% of our respondents are female while this is 50% of our target population. That is, our sample is not representative for our population because female respondents are overrepresented.”
Running the syntax below creates these data and computes mean incomes for male, female and all respondents.
data list free / case_weight gender income.
2.5, 0, 2200, 2.5, 0, 2000, 0.625, 1, 2700, 0.625, 1, 2300, 0.625, 1, 2400, 0.625, 1, 2700, 0.625, 1, 2400, 0.625, 1, 2300, 0.625, 1, 2500, 0.625, 1, 2200
value labels gender 0 'Male' 1 'Female'.
*2. Unweighted mean incomes.
means income by gender.
Biased Estimate for Unweighted CasesFemale respondents overrepresented and having higher incomes
Note in the screenshot above that female respondents have higher average incomes and are overrepresented as well. The result of this is that the estimated mean income for the entire target population (
€ 2370,-) is biased upwards. We can correct this by weighting our respondents as described earlier. The syntax below demonstrates how to do so.
weight by case_weight.
means income by gender.
*4. Switch off weight and do quick check on it.
Unbiased Estimate for Weighted CasesFemales and males equally represented when weight in effect
In the screenshot above, first take a look at the sample sizes. They're now equal for females and males, thus rendering the sample representative of the target population with regard to gender. Also note that the total sample size is still
10. This is because the average case weight is exactly one. Second, the estimated mean income for our target population is now
€ 2268,75-. This is because we correct for the aforementioned upwards bias by weighting.
THIS TUTORIAL HAS 13 COMMENTS:
By Cah Bekasi on October 18th, 2016
By Nyaklah on December 9th, 2016
Thank you for the compliment.
By hakim on June 22nd, 2017
I have liked this site and very much helping me with the analysis. I am getting the right full details on how to go about with the SPSS. Will give me more insight into syntaxes? I'm going to really appreciate your help. Thanks.
By Ruben Geert van den Berg on June 22nd, 2017
Everything that's public is on this website. Other than that, study the CSR.
Last: practice really does make perfect. Put in some effort and patience and I'm sure you'll get there!
By Jeetendra Mishra on August 10th, 2017
if( RID=1) weight=1.234567.
Is it correct syntax
What value will be punched in variable weight if syntax is correct.
As per spss syntax rule it terminates with period.