Even 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.
DEFINE !ISubgp (Var !TOKENS (1) /Cut !TOKENS (1) )
AUTORECODE VARIABLES=!Var /INTO SubGroup /DESCENDING /BLANK=MISSING /PRINT.
AGGREGATE /OUTFILE=* MODE=ADDVARIABLES OVERWRITEVARS=YES /BREAK=subgroup /Sub_CT=N .
Select if Sub_CT >=!Cut.
if missing(Subgroup) Sub_CT=$Sysmis.
!ISubgp Var=Var_toInvert Cut=20 .
The below video demonstrates the usage of the SPSS macro.
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:
How to use ClipShare:
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!
Video Leveraging the DOM plus looping over pages
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.
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
DEFINE !Describer (Buy2 !TOKENS (1) / Title !Tokens (1) / ord !Tokens (1) /Varys !CMDEND)
Desc !Varys /sort (!ORD) /stats Mean.
script "B:\SPSS\Scripts\S1\Swap Mean.SBS".
Script "B:\SPSS\Scripts\Change N to Count.SBS".
Script "B:\SPSS\Scripts\Parse\Move Row.sbs"("Other").
Script "B:\SPSS\Scripts\Parse\Move Row.sbs"("None of the above").
script 'B:\SPSS\Scripts\Parse\Change Title.sbs' (!Title).
Script "B:\SPSS\Scripts\S1\Size labels to avoid line-wrapping.sbs".
/*!Describer Buy2=XXX Ord=a Title="Title" Varys= Var1 Var2.
Video tutorials demonstrating the usage of the SPSS Macro
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 …
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 …