SPSS script to Create readily accepted CSV files to online tools

SPSS ScriptsWhile SPSS has a built in capability of exporting to CSV, it doesn’t export in a format that most online tools accept.  I wrote an SPSS script which accepts one parameter (the path & name of the file) then it exports the file into a better CSV format that tools do accept.

Demonstrates the use of a parsing script to create CSV files that are ready to be uploaded to survey tools

Video Demonstrating SPSS Script to Export to CSV

Creating CSV files from SPSS


SPSS Syntax writer / Recoder using an Excel template

SPSS syntax

SPSS syntax

Writing (and re-writing) SPSS syntax can be mundane and time consuming.  Sometimes my data set has hundreds of variables which would take me quite some time to rename and relabel.  I created an Excel template which generates the necessary syntax and greatly helped automate the process.

The Excel file is available for download from here and the video below helps you see how easy it can be to use.  There is also a concatenation tab which allows you to add specific words as a prefix for your variables.

SPSS Syntax Writer

Demystifying the Ternary Operator in AutoHotkey: Short-hand If-Else logic

TernAutoHotkey has pretty straight-forward If-Then-Else logic however it can take quite a few lines of code to do some simple evaluations.   Ternary Operators are a great way to write short / concise code in one line!  🙂

The basic form is that you first evaluate a condition.  If the value resolves to being true, the first parameter is returned.  If it is False, the second parameter is returned.

(Condition)?(True) : (False)

Ternary Operator video walk-through

Ternary Operator in AutoHotkey


Use an API for Sales Prospecting- Automate finding sales leads

Sales ProspectingAPI for Sales Prospecting

I have a lot of friends that work in sales and spend an awful lot of time (manually) trying to find new sales leads.  There are a lot of sources out there (LinkedIn, Hoovers, InfoUSA, etc. ) which allow you to use a web browser for searching through their database.  Others open up access to their data by way of an webservice API.

The Clearbit prospect API allows you to find people and bring back demographics as well as email address.  The video demonstrates two examples where I of the Propector and Autocomplete Clearbit APIs.

Prospector and Autocomplete API