SPSS VECTOR – Quick Tutorial

In SPSS, a VECTOR is a list of (new or existing) variables that can be referenced by their indices in this list.VECTOR is often combined with LOOP. Creating Dummy Variables with VECTOR and LOOP SPSS Vector – Basic Example Suppose we’d like to Creating Dummy Variables in SPSS for a variable holding values 1 through 4. We’ll call […]

Python Xlrd (Excel Read) Module

xlrd is a module that allows Python to read data from Excel files. This tutorial explains where to get it and how to install it. Downloading the Python Xlrd Module The Python xlrd (short for “Excel Read”) module can be found here. After downloading it, you can extract the contents (twice) with 7 Zip. Copy the path of the folder that […]

SPSS – Create Several Excel Files with Python

A teacher held a course evaluation. The data in SPSS format are in course_evaluation.sav, part of which is shown below. Students from different majors participated and now the education director wants separate Excel files for each major. A super easy way for creating these is by using SPSS with Python. We’ll walk you through. 1. Save SPSS Data as […]

SPSS – Batch Process Files with Python

Running syntax over several SPSS data files in one go is fairly easy. If we use SPSS with Python we don’t even have to type in the file names. The Python os (for operating system) module will do it for us. Try it for yourself by downloading spssfiles.zip. Unzip these files into d:\spssfiles as shown below and you’re good to go. Find All Files […]

Create Dictionary Dataset

An often requested feature is to export variable and value labels to Excel. This handy tool creates an SPSS Dataset containing these labels. It can either be be saved as an Excel sheet or further edited in SPSS. SPSS Create Dictionary Dataset Tool – How To Use Make sure you have the SPSS Python Essentials installed. Next, download and […]

SPSS Python Text Replacement Tutorial

A common task in Python is building strings from other strings, especially if we’re creating SPSS syntax. We could simply concatenate strings into larger strings but there’s a nicer way: string replacements with the % sign. Please note that the examples in this tutorial assume Python2.x* and may not run in Python3.x. Python String Replacement with %s *Replace […]

SPSS Python String Tutorial

The most important Python object we’ll deal with are strings. This tutorial presents a quick overview of Python string methods. However, let’s first learn some very basics. Python Strings – Basic Rules Strings may be enclosed by single or double quotes if they don’t contain any line breaks; Strings may always be enclosed by 3 single […]

Python – The 5 Things You Want to Know

SPSS users who want to speed up their work by using Python will encounter some surprises. This tutorial walks you through the 5 major pitfalls and shows how to avoid them. 1. Python is Fully Case Sensitive SPSS is mostly case insensitive; if we have a variable “gender”, we can address it in syntax as gender or GENDER or anything in between. […]

SPSS with Python IV – How to Use It?

So how does Python for SPSS actually work? First off, a distinction is often made between SPSS Python programmability and SPSS Python scripting. They work similarly in that some Python code is included in SPSS syntax; SPSS passes this Python code on to Python; Python may then look up information in SPSS such as variable names in the dataset or tables in the output window; […]

SPSS with Python III – How Does It Work?

So how does Python for SPSS actually work? First off, a distinction is often made between SPSS Python programmability and SPSS Python scripting. They work similarly in that some Python code is included in SPSS syntax; SPSS passes this Python code on to Python; Python may then look up information in SPSS such as variable names in the dataset or tables in the output window; […]