StATS: Placing consecutive dates in a column of an SPSS file (January 26, 2005).

Someone gave me a data set with 549 rows of data. The first row corresponded to observations on 06/01/2003, the second to 06/02/2003, and so forth through 11/30/2004. She wanted to know how to get those particular dates in a column without having to type something into each individual cell.

Here's how I did it.

First, I defined a new column, date1, that has a date format. Then I used TRANSFORM | COMPUTE to calculate the following formula:

 This gives you dates starting on June 1, 2003 and moving up day by day in each row.

She also wanted a column designating the particular month. You can do this with the same TRANSFORM | COMPUTE command to compute a new variable, MONTH, using the formula

Since you have June in both 2003 and 2004, you probably also need to compute a YEAR variable using the formula

This is a very simple example of date calculations in SPSS. I have another page that talks about this:

and version 13 of SPSS has a very useful date and time wizard:

but the best resource for these types of things is on Raynald Levesque's web site:

This page was written by Steve Simon while working at Children's Mercy Hospital. Although I do not hold the copyright for this material, I am reproducing it here as a service, as it is no longer available on the Children's Mercy Hospital website. Need more information? I have a page with general help resources. You can also browse for pages similar to this one at Category: SPSS software.