Date: Fri, 18 Feb 2005 11:29:59 -0700
Reply-To: Geoff Matthews <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Geoff Matthews <firstname.lastname@example.org>
Subject: Re: Recoding for the earliest date
Content-Type: text/plain; charset="us-ascii"
Worked wonderfully. Thank-you.
From: Johnson, Wendy RDECOM (PKI)
Sent: Friday, February 18, 2005 11:21 AM
To: Geoff Matthews; SPSSX-L@LISTSERV.UGA.EDU
Subject: RE: Recoding for the earliest date
I think this should work:
Compute firstdat = min(date1 TO date68).
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Friday, February 18, 2005 1:13 PM
Subject: Recoding for the earliest date
I have a dataset which contains 68 date variables. I need to find the
earliest one for each 5,000+ subjects. While it would have made sense
to have date1 earlier than date2, this is not the case.
I had consigned myself to writing:
COMPUTE firstdat = date1.
DO IF (firstdat >= date2).
(ELSE=COPY) INTO firstdat.
68 times, but there has got to be an easier way. Any suggestions?
Institutional Research Analyst
Western Governors University