Analysing postcodes and zip codes
The best way of analysing postcodes and zip codes is to use a derived variable.
There are some considerations to take into account when analysing postcodes or zip codes in Snap Desktop.
- Snap Desktop is case sensitive, which means the data can be entered into the postcode or zip code question in a variety of ways and you need to account for every possible variation in order to capture all the data.
- If the postcodes or zip codes include letter combinations that could be found in another postcode or zip code, for example, S7 and BS7, you should put the more complex codes before the simpler ones, that is, BS7 should be inserted before S7.
- If the postcodes or zip codes include number combinations that could be found in another postcode or zip code, for example, SW1 and SW11, you should put a space after the shorter code.
- Additionally, it is always best to enter each postcode or zip code in inverted commas, for example, “BS8”.
To create the derived single variable, please follow the steps below to categorize the postcodes and zip codes by area.
- Open the Variables window and click to add a new variable.
- Select Derived from the Type dropdown and Single from the Response dropdown. A single response is used as each respondent only falls into one of the new codes.
- When created, a derived variable is automatically named, starting from V1. You can change this name to one that describes the variable. Enter the new derived variable name in Name.
- In the Code list grid, click in the Label column next to code 1 and type in the first postcode or zip code area you want to categorise, in this case BS4.
- In the Values column for code 1 type in the values to search the data. For example, when searching for any cases where BS4 has been entered the values would be Q11=”BS4″ or Q11=”bs4″ or Q11=”Bs4″ or Q11=”bS4”, with each variation of BS4 being accounted for. Note: Using the word OR, or a comma (,) in the values has the same effect.
- Repeat steps 4 and 5 for each postcode or zip code you want to search for.
- Click Count Responses to see the count for each postcode or zip code area in the derived variable.
- Click Save to save the derived variable.
You can now use the derived variable, in the same way as any other variable, in your analysis or in a filter.
If there is a topic you would like a worksheet on, email to firstname.lastname@example.org.