Running VARSTOCASES is often necessary for generating nice charts in SPSS. One of the many examples is a stacked bar chart for comparing multiple variables. Sadly, we lose our variable labels when running VARSTOCASES and we really do need those. The solution is a simple tool that generates our VARSTOCASES for us and applies the variable labels of the input variables as value […]
SPSS offers three ways for analyzing subsets of cases. After running SPLIT FILE, output tables and charts will show results for subsets of cases separately. Second, you can temporarily FILTER out cases you’d like to exclude from analysis as shown in the screenshot. Third, you can permanently remove cases from your data with SELECT IF. Analyzing Subsets of Cases SPSS FILTER […]
SPSS VARSTOCASES is short for “variables to cases”. It restructures data by stacking variables on top of each other as illustrated by the figure above. You can try this simple example for yourself by downloading and opening sav_data018 and running the syntax below on it. SPSS VARSTOCASES Example 1 *Very basic VARSTOCASES example. varstocases /make v from […]
In SPSS, SELECT IF deletes cases (rows of data) that don’t satisfy some condition(s). Like so, SELECT IF basically means “don’t delete if …” A minimal example isSELECT IF(GENDER = 1). SPSS SELECT IF – Some Examples Say we collected data on our employees and the resulting data file is employees.sav. Our client is only interested in female […]
SPSS FILTER temporarily excludes a selection of cases from all data analyses.For excluding cases from data editing, use DO IF or IF instead. SPSS Filtering Basics Example 1 – Exclude Cases with Many Missing Values Example 2 – Filter on 2 Variables Example 3 – Filter without Filter Variable Tip – Commands with Built-In Filters Warning – Data Editing with […]
