Date:         Wed, 12 May 2010 11:34:18 -0700
Reply-To:     Bruce Weaver <bruce.weaver@hotmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Bruce Weaver <bruce.weaver@hotmail.com>
Subject:      Re: Overlapping Periods
In-Reply-To:  <B7635ACC498A8A40A2715399FB88A4F35CAE1C3522@p01789.prainc.internal>
Content-Type: text/plain; charset=us-ascii

Asil Ozdogru wrote:
>
> Hello,
>
> I would like to get the earliest in and latest out dates among a set of
> overlapping periods using syntax.
> An example is provided below.
>
> Could anyone help me with that?
>
> Thanks,
>
> Asil
>
> EXAMPLE:
>
> --- snip tables, because formatting was lost ---
>
>
>


Dates are numeric variables, so you can use the MIN and MAX functions of
AGGREGATE to pull out the earliest INDATE and latest OUTDATE.  If you want
the same variable names as in the original data, you'll have to set the
OVERWRITE option to yes.



-----
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/
"When all else fails, RTFM."

NOTE:  My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.
--
View this message in context: http://old.nabble.com/Missing-dates--tp17760957p28539564.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD