How to Collapse Ordinal Data in SPSS

Updated April 17, 2017

Ordinal data is a level of measurement with an implied ranking but no distinction to the magnitude between levels. Collapsing ordinal data can increase the interpretability of your results and analyses. You may also want to collapse or combine categories with a low sample size with an adjacent value. Typically, you want to have a strong justification for collapsing your data and should include the rationale in your write-ups. Statistical Package for the Social Sciences (SPSS) is statistical software that permits simple and advanced analyses, such as collapsing data.

Establish the new categories and values for your collapsed data and their connection with your original ordinal data values.

Open your SPSS software.

Select "Transform" from the main menu, scroll down and select either "Recode into Same Variables" or "Recode into Different Variables." Choosing "Recode into Same Variables" overwrites your current ordinal data, whereas "Recode into Different Variables" creates a new variable for your collapsed data.

Select the variable name of the ordinal data you want to collapse. Drag to the "Input Variable -> Output Variable:" box or use the arrow button.

Click "Old and New Values."

Enter the originally coded ordinal data values and their new values individually. Enter the original ordinal data code value or select a range of values under "Old Value." Also, enter the "New Value." Click "ADD." Repeat process until all new codes are added. Click "Continue" when you finish.

Enter the new variable name and label, a short description of the variable, if you selected "Recode Into Different Variable" under "Output Variable." Click "Change."

Select "OK" and SPSS will recode and collapse your ordinal data as specified. .


Check the new values of your collapsed ordinal data for accuracy

Cite this Article A tool to create a citation to reference this article Cite this Article


About the Author

Katina Coleman is a research psychologist who has been writing since 2004. She has published and reviewed articles in various academic journals and consults on research projects related to health and education. Her research interests center on patient-doctor communication and cancer health disparities. Coleman holds a Ph.D. in psychology from Wayne State University.