Hello SPSS Experts,
I would like to ask how to create a variable based on the values of other two variables. As shown below, the first three columns such as student ID (ID), school year of enrollment (SY) and semester of enrollment (Semester) are available in my SPSS database. I want to create the fourth column called date of enrollment (DOE), a date variable. The dates should be created based on the values of SY and Semester. Semester=1 is referenced as June 1 while Semester=2 is referenced as November 1. For example, if a student enrolled during the school year 2004-2005 and
semester=1, then DOE = 06/1/2004.
ID SY Semester DOE
1 2004-2005 1 06/1/2004
2 2004-2005 2 10/1/2004
3 2005-2006 1
4 2005-2006 2
5 2006-2007 1
6 2006-2007 2
Your help is highly solicited. Thank you.
Eins