I have been working recently on importing data into SPSS from the first part of my April survey on World of Warcraft motivations. This has been a fairly straightforward process for the most part. The exception is the last question about the respondent’s guild type and purpose. The question was presented as the following:
In a short sentence (140 characters), describe the primary purpose of the guild in which you spend most of your time, or enter “no guild”.
Example: I’m in a social guild that believes in random acts of kindness. We love to dance but we also raid end-game content with other casual guilds.
I am not happy with how the coding for the type and purpose is going. When I created the SPSS codebook for that part of the survey, I initially broke it down into two parts: a type and a primary purpose. The type represented a breakdown primarily between “social” and “hardcore”. The purpose could be a key activity or a purpose. The divisions were chosen based on an an initial review of the received responses (see Table 1).