Summary Reading multiple sheet Excel workbooks into SPSS is easily done with this Custom Dialog. This tutorial demonstrates how to use it. Before You Start SPSS Read and Merge Excel Files Tool Make sure you have the SPSS Python Essentials installed. Download and install the xlrd module. If you’d like to generate some test data as done in […]
Introduction Merging data with ADD FILES can result in nonsensical data. This occurs when variables or values have different meanings over files. By comparing dictionaries over files, inconsistently coded variables are quickly detected. So What’s the Problem? When files are merged with ADD FILES, inconsistent dictionary information is discarded. This will happen, for example, if a variable v1 means “gender” […]
This handy tool will set the exact sizes for one or many charts in the active output window. SPSS Set Chart Sizes Tool – How to Use it This tool requires SPSS version 18 or higher. For SPSS versions 14 through 17, you can use the syntax version from SPSS Set Chart Sizes with Syntax Tool. Before proceeding, […]
SPSS doesn’t offer an easy way to set decimal places for output tables. This tutorial proposes a very simple tool for setting decimal places in basic output tables after they’ve been produced. It works best for simple tables such as DESCRIPTIVES, MEANS or CROSSTABS. Setting Decimal Places for Output Tables First, make sure that the SPSS Python Essentials are installed and […]
