SPSS Syntax writer / Recoder using an Excel template

SPSS syntax

SPSS syntax

Writing (and re-writing) SPSS syntax can be mundane and time consuming.  Sometimes my data set has hundreds of variables which would take me quite some time to rename and relabel.  I created an Excel template which generates the necessary syntax and greatly helped automate the process.

The Excel file is available for download from here and the video below helps you see how easy it can be to use.  There is also a concatenation tab which allows you to add specific words as a prefix for your variables.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.