SPSS macro to flip ordinal variable labels so they graph well in Excel

SPSS macroEven though I do nearly all my analysis in SPSS, I still prefer to use Excel to graph my data.  Unfortunately Excel inverts the legend when graphing. Creating a new variable, or re-coding the old one, is time consuming and errors can creep in. This SPSS macro to invert an ordinal variable with very little work.  Saves an amazing amount of time!

It also has a built-in way to filter out too small a sample size.


SPSS macro

The below video demonstrates the usage of the SPSS macro.

Inverting an Ordinal Variable that has value labels


Ever want to share the clipboard between computers? Now you can!

share the clipboard

Share the clipboard

I wrote a small program with AHK that allows you to share the clipboard with another computer (regardless of where it is).   Sometimes I’m using my laptop and copy & then want to paste on my desktop while other times I’m collaborating with my friend in Denmark.  Either case is simple for me.  All I have to do on one computer is copy it to the clipboard. The other computer can simply paste and the text (or file if you’re in Windows Explorer) will be pasted!

The only requirement is to have a folder that is shared between them. (Use services like Dropbox or Google Drive or a network drive if you are at work. It has been tested on Win XP, Win 7, Win 8 and Windows 10.

Overall Explanation / Review:

ClipShare Intro – Explanation

How to use ClipShare:

ClipShare-How to use


Web Scraping with AutoHotKey 103-Leveraging the Document Object Model

web scraping

Leveraging the Document Object Model

This third video on Web Scraping gets a little advanced and shows how you can leverage the DOM to make extracting data from a webpage much easier and reliable.

Leveraging the Document Object Model (DOM)will take some practice (especially if you’re not familiar with Object oriented coding) but it is well worth it because it greatly reduces the amount of clean-up you have to do after you extract your data.  I used to write some pretty crazy regular expressions to try and clean up my code.  Once I learned how to better navigate the DOM it negated the need for cleaning!

The HTML Document Object Model (DOM)-Tree of Objects

Document Object Model

Video Leveraging the DOM plus looping over pages

Webscraping with AHK 103-Isolating sections and taking advantange of DOM

The syntax for writing the writing the web scraping code can be found on my first post here.  There is also an AutoHotKey forum thread you might wish to review here.

Intro to SPSS Macro call; The lifesavers of redundant code

SPSS macro
Using SPSS Macros can save an incredible amount of time.  They have a somewhat-steep learning curve but are definitely worth it!  This is a short overview of the strength of using a macro to run the descriptives command.

Word of warning, make sure you re-define your macro before calling it.  This is an easy step to forget and you can waste a lot of time.

SPSS Macro Code

Video tutorials demonstrating the usage of the SPSS Macro

Intro to SPSS Macros

Additional SPSS macro links

A great resource to use and learn macros is Raynald Levesque’s site.  This page is his intro to macros page and this one walks through writing one.  He also has a great library of them located here.

Learning Macros | Raynald’s SPSS Tools

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

Quick Intro to SPSS progams | Glenn Thompson’s Homepage

Feb 13, 2010 Free Power Calculation Resources · automation program for  · Quick Intro to SPSS Working with SPSS …

Replacing missing data

https://www.youtube.com/watch?v=5CBm_F3zBOo A lot of online vendor tools provide a data value on a multi-select question however they leave the value missing if the respondent didn’t select it. Most of the analysis I want to do needs to have a zero (or some other value) present in order to calculate the …