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.