Calculating Turnover (Syntax)

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Thu Sep 14, 2017 6:29 pm

Calculating Turnover (Syntax)

Postby slitermt » Thu Sep 14, 2017 6:50 pm


I have an Excel template that I use to calculate turnover in a very specific way, but I would like to convert this to SPSS syntax. The problem is, there are nested IF statements, and I don't know where to start with the syntax.

The file will always have Hire Date, Term Date, and File Effective Date. They are used to calculate:

Days to Term (Term Date - Hire Date)
Possible Tenure (File Effective Date - Hire Date)
Term 30, 60, 90, etc. (Did someone leave the company after 30, 60, 90, etc. days? This is where there are nested statements. Did a person term within 30 days? Did they have a chance to reach 30 days? etc) This should be clearer in the screenshot.

Does anyone have any idea of how to duplicate this formula with syntax? I would be greatly appreciative,
You do not have the required permissions to view the files attached to this post.

Who is online

Users browsing this forum: No registered users and 3 guests