Transform Data with SPSS Macros saves an amazing amount of time!

transform data

Transform data

In order to correctly perform most multivariate techniques, your data needs to be normally distributed.

Having to transform (log, square root, etc.)  used to be a daily thing for me. It would take some doing to create new variables for the dozens or so that I’d need to transform.  Using macros I’ve written in SPSS makes it a breeze!  I’ve built SPSS macros that will convert a list of variables (and add a pre-fix to their names) for Logs, Natural logs, Square roots, etc.  I also built one that performs all of them (just to get a bit crazy)

Transform Data with SPSS Macros saves an amazing amount of time!


Here are the SPSS macros that I wrote

Trust me you’ll never want to transform data without them again!

Setting output for SPSS Variable names, Labels, or both

SPSS variable

Typically I want to have the SPSS variable labels show up in my SPSS output however there are times when having the variable names is beneficial (especially for writing more syntax).  Other times (rare) I actually want to have both.  The syntax for changing is straight forward

video demonstrating using the syntax on the SPSS Variable Names

setting output for Variable names, Labels, or both

Drastically reduce work needed for Factor Analysis with SPSS Macro

SPSS macroSPSS Macros drastically reduce the time needed to run factor analysis and creating summary variables.  In the video below I demonstrate how you can greatly increase the speed at which you analyze your data as well as creating the new variables with summary factor scores.

By running Factor analysis twice (but changing the output) you can make it much easier to create summary variables once you’re happy with your solution!

Video demonstrating SPSS Macro running Factor Analysis

Factor Analysis with Macros

Here is the SPSS macro for Factor analysis:

And here is the other SPSS macro which eases creating of a new factor.  It takes a little getting used to but is well worth the effort if you’re doing a lot of factor analysis.

Learning Macros | Raynald’s SPSS Tools

This page is a simple introduction to macros. There are several fully (line- by-line) commented examples . Overview of several macro-related …

Programming with SPSS Syntax and Macros –

Instead, a SPSS macro could generate the SPSS Syntax for each interactive graph within a loop, substituting a new rating scale variable name per iteration.

Great use of GIS data to decide your next business location

GIS Data

Years ago I helped a company that worked in the financial industry review where their current locations are and where FDIC Banks were located.  The GIS data was available for free from the FDIC.  If you spend some time you can merged the files together and look at it longitudinally.   The below map was particularly helpful in deciding where a new branch/office should be located.  I also imported the locations of competitors however I cannot share this data as it is too revealing.

I used Microsoft’s MapPoint to create the below map.  It is no longer with us however this would be easy to repeat with Google Maps.

GIS data

Here’s a great book to get ideas on conveying data visually