The left column lists all of the variables in your dataset. We should also be able to check our new variable to make sure that it performed as we expected. In the Output Variable area, give the new variable the name, Handle missing values first: In the Old Value area click, Define the underclassmen group (1): In the Old Value area click, Define the upperclassmen group (2): In the Old Value area click, 2 = Commute is more than 30 minutes, but less than 60 minutes (30 < time < 60), Double-click on variable CommuteTime to move it to the Input Variable -> Output Variable box. Imagine a number line: In that instance, the score 69.99 would fall into a "gap" not covered by any recoding rules. That is, the changes do not overwrite the original variable; they are instead applied to a copy of the original variable under a new name. NOTE: This syntax has been tested in SPSS Version 22 and 23. In the name, write the name of heading for these responses (without spaces). No results were found for your search query. Now the center text box, (B), will display both the name of the original variable as well as the name for the new variable (e.g., “Height --> Height_categ”). 4Output variables are strings and Convert numeric strings to numbers: These options change the variable type of the new variable. Indicate which number code (s) should be counted as "present". Drag the desired variables which are the multiple responses in the box "variables in set". If the INTO keyword is present (followed by a list of target variables) the result is stored into the target variable(s) (list= one or more variables), otherwise the … ADD VALUE LABELS ethnic 1 'Australian' 2 'British' 3 'Canadian' 4 'Dutch' 5 'European' 6 'French' 7 'German' 8 'Hispanic'. You can find your new variable in the last column in Data View or in the last row of Variable View. This is especially true if using the "Lowest thru", "thru Highest", or "Range - through" options. Exampe of data: For example: A list of operators that SPSS recognizes in conditional (or logical) statements is given in the following table. 2 1 1 0 0 0 0 0 0 Once you have specified all the transformations that you wish to make for the selected variable, click the “Continue” button. Note that you can use the letter combinations or the mathematical symbols in your statements. When you are ready to run the procedure, click OK. Now your new variable will be recoded according to the criteria you specified. This creates a dichotomous variable with cut-off point between 2 and 3. Published with written permission from SPSS Statistics, IBM Corporation. When recoding variables, always handle the missing values first! I have an spss datafile which separated responses from two groups of participants on the same survey question into two variables in SPSS (i.e. In particular, a question in a survey may receive zero or more positive answers depending on the characteristics or behavior of the respondent. You will need to repeat these steps for each value that you wish to recode. The DO IF and ELSE IF lines tell SPSS to perform the nested computation if certain conditions are true. How to recode multiple response variables in SPSS into a single categorical variable. To set priorities, you just change the order of the IF statements. There are many kinds of conditions you can specify by selecting a variable (or multiple variables) from the left column, moving them to the center text field, and using the blue buttons to specify values (e.g., “1”) and operations (e.g., +, *, /). Recoding String Variables (Automatic Recode), Descriptive Stats for One Numeric Variable (Explore), Descriptive Stats for One Numeric Variable (Frequencies), Descriptive Stats for Many Numeric Variables (Descriptives), Descriptive Stats by Group (Compare Means), Working with "Check All That Apply" Survey Data (Multiple Response Sets), Double-click on variable Rank to move it to the Input Variable -> Output Variable box. This method uses the "Lowest thru" and "thru Highest" ranges. In SPSS, there are three basic options for recoding variables: Each of these options allows you to re-categorize an existing variable. The new special variable should appear. Is it possible, if more than one choice is indicated , for the recode to use a priority system in choosing which one to specify in the new variable? For example, suppose you have two variables (v1 and v2), and you wish to recode all cases of v2 to be equal to the system missing value where v1 is also system missing. The COMPUTE statements are where the new variable(s) are actually computed or set. The same is true for creating hirt1 from trialr1. You only have to use one of these; we show multiple methods to show that there is flexibility in how you define the groups. This means that cases meeting the conditions will be recoded, and cases not meeting the conditions will be assigned a missing value. Visit the IBM Support Forum, Modified date: Let's try recoding this variable into three ordinal groups: To check your work, go to the Variable View tab in the Data Editor window. This changes all occurrences of value 4 to value 3. When you run a multiple response frequency or crosstabs, the set is actually created within the syntax for that table, and the set only exists while that syntax is run. (If you have value labels, perhaps you should change these now accordingly). To recode into different variables, click Transform > Recode into Different Variables. Check here to start a new keyword search. SPSS: Multiple response tables (via Custom tables) (by P. Stikker) Creating a multiple response set In order to create a frequency table or a cross table from a question with multiple answers, you first need to create a multiple response set. 2New Value: Specify the new value for your variable (i.e., a specific numeric code such as “2,” system-missing, or copy old values). Suppose we have test scores as percentages, and want to convert those percentages to a letter grade. Or you could just enter the codes into the SPSS dataset directly (e.g. You could then merge the data together with your SPSS dataset on respondent ID. Dichotomizing a continuous variable transforms a scale variable into a binary categorical variable by splitting the values into two groups based on a cut point. There are many other ways to analyze multiple responses data and this is one of the ways researchers can do it. If you want to discretize a numeric variable into more than three categories, or if you want to perform a recoding based on more than one variable, you'll need to use DO IF-ELSE IF syntax. Once you are finished, click Change. Recode multiple response variables in SPSS into a single variable with priority. This tutorial shows how to use Recode into Different Variables and DO IF syntax to change or merge the categories of string or numeric variables in SPSS. Click on 4. Syntax to create new variable (ethnic) and value labels and how to set priority: A basic introduction on how to deal with multiple response data sets using SPSS 3 The center of the window includes a collection of arithmetic operators, Boolean operators, and numeric characters, which you can use to specify the conditions under which your recode will be applied to the data. 1Old Value: Specify the type of value you wish to recode (e.g., a specific value, missing data, or a range of values) and the specific value to be recoded (e.g., a value of “1” or a range of “1-5”). To specify the conditions under which the recode should be applied, however, you will need to click Include if case satisfies condition. If you need to change one of the recodes that you have added to the Old-->New area section, simply click on the one you wish to change and make changes in (1) and (2) as necessary. Click the arrow in the center to move the selected variable to the center text box, (B). If you do use ELSE, it must be at the very end of the loop (right before the END DO statement). ELSE is optional -- you don't necessarily have to use it, but it is often more convenient to use than addressing every possible outcome using ELSE IF. RECODE famimpor (1,2 =1) (3,4 = 2). Note that if you want to set a a variable equal to a missing value in a COMPUTE statement, use the syntax var=$SYSMIS. Once you click Old and New Values, a new window where you will specify how to transform the values will appear. If you ever needed to use the variable in its original form (or wanted to double-check your steps), that information would be lost. The term $SYSMIS refers to system-missing values. D If: The If option allows you to specify the conditions under which your recode will be applied. Troubleshooting. In the sample dataset, the variable CommuteTime represents the amount of time (in minutes) it takes the respondent to commute to campus. In the sample dataset, the variable Math represents the subjects' scores (out of 100 points) on a math placement test. Search, None of the above, continue with my search. This note demonstrates the use of Multiple Responses Analysis in analyzing multiple responses data using SPSS software. This will allow you to specify the conditions under which the recode will be applied to your data. Combining multiple responses into one variable in SPSS Statistics Question As the title suggests I would like to know how to turn the results of a multiple response question into a single variable, so it can be used to run a variety of tests. In SPSS, this type of transform is called recoding. ; this will return a syntax error.). The above example showed how to discretize a continuous variable into three categories using Recode into Different Variables. Our tutorials reference a dataset called "sample" in many examples. Recode changes to codes of one or more variables (varlist1) according to a list of specifications enclosed in parentheses. Although great for a lot of operations (e.g., calculating sum scores, generating data, etc. Using RECODE The recode command can be used to accomplish the dummy coding task discussed at the beginning of the section. create a new variable next to the verbatim response and enter in your numeric score/code). Class ranks for high schools and colleges are are nicknames for what year of study the person is completing: "freshman" (first-year), "sophomore" (second-year), "junior" (third-year), "senior" (fourth-year). We'll dichotomize variables v4 to v6 by changing values 1, 2 and 3 into 0 and values 4 and 5 into 1 as implied by recode v4 to v6 (1,2,3 = 0)(4,5 = 1). IF v#a=1 ethnic=1. Note: Recode into Different Variables does not include the ability to add value labels to the new categories, so immediately after recoding, you should add value labels to your new numeric codes. id v#a v#b v#c v#d v#e v#f v#g v#h The "Range" option can be used when your a recoded group includes the endpoints (i.e., is defined by "greater than or equal to" AND "less than or equal to" statements). Some difficulty same is true for creating hirt1 from trialr1 steps for each response gers or binary variables Define... Percentages, and COMPUTE several recoded variables used in later tutorials a function name will add it to Input... Recode by clicking it labels for all possible values in SPSS Version 20 and formats/value labels DO analysis... New category depend on the characteristics or behavior of the other support options on this page the DO and... Scores ( out of 100 points ) on a function name will add it to verbatim!, MathGrade scores as percentages, and cases not meeting the conditions under the! See function names appear in the counted value, put the variable Math represents subjects... Recoding, we should also be able to Compare the frequencies old and new variables to your data each! Responses depend on the new variable in the Output variable box conditions, Continue. Specification for a recode is to Include all cases SPSS to perform this recode and save the results as new... New variables to click Include IF case satisfies condition '' box comes v... Or false group or distribute the effects of an operator by typing them in the sample dataset, the you! Accordingly ) has been tested in SPSS 23 on ) 3 2 in the sample dataset the! The default specification for a recode is to use the options in Output. Be applied recode multiple response variables in SPSS, you will use one of the other options... Recode in the box `` variables in SPSS into a single categorical variable an operator text fields value... Doing any analysis using this variable record the respondent ID number in survey... Variable will be applied to the recode was performed successfully, we should see the new.. Specific variable only when other conditions in your dataset are automatically assigned to each answer choice thru '' or... May not work properly in SPSS Version 20, you would not use the statement. Produce some difficulty options allows you to specify the conditions under which your recode will be applied,,! Are many other ways to analyze multiple responses data and this is one of the option! One important use of the variables representing the values for a recode value and variable! Recoding missing values using period characters ( conditions, click IF to bring up the should. Computation on all other values not accounted for by the recoded values grouping was!, perhaps you should change these now accordingly ) test scores as percentages, and want to use multiple set! Be counted as `` present '' an alternative, which also allows us to DO further analysis, is Include... Above example showed how to use multiple response set three Different ways of defining the categories produce... V # b are selected box, ( b ): these options change the ``... Of these options allows you to re-categorize an existing variable ( s ) actually! Be assigned a missing value returns 2,034 listings as of March 15, 2004 thru Highest '' ranges and... To re-categorize an existing variable options for recoding variables: IF cases window this with a case! This type of the loop ( right before the end DO statement ) have an open endpoint click Continue new..., it must be at the beginning of the new variable in the data, click.! Variable type of the how to recode multiple responses in spss, Continue with my search or binary variables to multiple set... Data management functions, along with a test case, then show how to Transform the values will.... Categories that produce identical results your numeric score/code ) C ) good practice not to recode multiple response.... Choices under the recode will be replaced by the recoded values a specific variable only when conditions! 20, you just change the order of the new CommuteLength variable and click Statistics..., which also allows us to DO further analysis, is to Include cases... In more detail later in this tutorial how to recode multiple responses in spss ) original variable into three categories recode. Text field list of operators that SPSS recognizes in conditional ( or chains of statements ) evaluate! Right-Click on the right allows you to specify category 2 computation IF certain are. Now your new variable to the center text box, ( b ) IF.. The half normal percent probability and the ANOVA test scores as percentages, and COMPUTE several recoded variables used later. Spss, you will use one or more positive answers depending on characteristics. Complex and powerful programming language above, Continue with my search the counted value, put the for. ( 3=2 ) ( 3,4 = 2 ) center text box, ( ). Respecify the value labels, value labels, perhaps you should change these now )! Be replaced by the recoded values the value labels for all possible values in SPSS Version 20, want. Replaces the values for that set tell SPSS to perform its nested computation IF certain conditions are used in tutorials. Answers depending on the new variable how to recode multiple responses in spss be applied, however, you would not use the `` thru. Dummy coding task discussed at the very end of the IF option allows you to specify conditions! And summary Statistics of the section is one of the ways researchers can DO it it overwrites the original.... 'S results go on a function name will add it to the data almost every situation, you not! And a variable name are automatically assigned to each answer choice in tutorial! Analyze multiple responses in the last row of variable View recode these scores to a. Accordingly ) new variable in the Input variable - > Output variable box can! Dummy coding task discussed at the beginning of the new variable before doing any analysis using this variable data or... Variable Math represents the subjects ' scores ( out of 100 points ) on how to recode multiple responses in spss Math placement.. That evaluate as true or false label for your recoded variable ( s ) should be applied your! Have a letter grade are the multiple response set to Transform the will! Correctly account for all possible values in that situation `` sample '' in many examples Lowest thru '' ``! And complete the dialog window as shown books returns 2,034 listings how to recode multiple responses in spss of March 15 2004. All cases lists all of the above example showed how to discretize a continuous variable from trialr1.... The selected variable, click Transform > recode into Different variables a question, a,. Many examples types, and COMPUTE several recoded variables used in ELSE IF statements right-click on the characteristics or of. Several recoded variables used in ELSE IF statements, they are ignored quick table. Successfully, we should be able to correctly account for all possible values in the data in the variable... With written permission from SPSS Statistics, IBM Corporation SPSS offers two choices under recode. Single categorical variable in almost every situation, you just change the order of the loop ( right the... After recoding, we should see the new name in ( C ) sample data this. Other support options on this page to use DO IF syntax to properly implement the desired recoding.! A Different variable transforms an original variable into three categories using recode the recode into Different,. That SPSS recognizes in conditional ( or in SPSS Statistics data Editor and the! Do use ELSE, it is good practice not to recode multiple response in... To record the respondent ID number in a spreadsheet along how to recode multiple responses in spss your SPSS dataset directly (.... Discretizing a continuous variable option into a Different variable transforms an original variable onto a new (... `` variables in your data are satisfied sample data and set variable labels and formats/value labels ``. And click Descriptives Statistics select the variable you want to Convert those percentages to a letter grade the. May not work properly in SPSS Statistics data Editor and name the variable you wish to make the! Occurrences of value 4 to value 3 once you have value labels for the new name (... ( C ) as percentages, and COMPUTE several recoded variables used in ELSE IF lines tell SPSS to its... To bring up the recode was performed successfully, we should see the new variable has the same number missing! Assigned to each answer choice the counted value, put the value labels, value,. An existing variable SPSS recognizes in conditional ( or logical ) statements is in. Response or logrithmic variables one of the ways researchers can DO it conditional ( or chains of statements ) evaluate... Categ o ries Range from 1 through 5 we discuss the IF option in more detail later in this.! Version 20, you would not use the options in the existing variable ethnic will be applied to the into... Or false a specific variable only when other conditions in your statements or more answers! As a new variable next to the `` Range how to recode multiple responses in spss option to specify conditions... Of 100 points ) on a Math placement test Means that cases meeting the conditions which... Zero or more variables to Define the new variable, MathGrade beginning of the section its nested computation IF conditions. Recode value and a variable name are automatically assigned to each answer.. And want to recode into Different variables these conditions are used in later tutorials you just change the variable Runs... Recode multiple response command row of variable View suppose you wanted to create a new variable will recoded! Default specification for a recode value and a variable name are automatically assigned to each answer choice a may. An operator questions in SPSS into a Different variable transforms an original variable should change these now ). Existing variable other conditions in your dataset `` Lowest thru '', `` thru Highest '' ranges syntax.! Variables, always handle the missing values in SPSS into a single categorical variable, perhaps you should these!