Not tested (assumes data is sorted in the correct order):
COMPUTE useit = ratio GT lag(ratio) AND LAG(ratio) GT LAG(ratio,2).
--jim
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of
jimjohn
Sent: Thursday, September 04, 2008 4:09 PM
To:
[hidden email]
Subject: Re: Select Cases where variable increases twice in a row
thx viann. I just have the two columns: One is the ratio, which is
numeric
and then the other is a string corresponding to the month (e.x. 200609
is
for Sep, 2006).
ViAnn Beadle wrote:
>
> Describe the organization of your data. Is each case a time point?
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf
Of
> jimjohn
> Sent: Thursday, September 04, 2008 9:11 AM
> To:
[hidden email]
> Subject: Select Cases where variable increases twice in a row
>
> i have one variable that is a monthly ratio. I want to select only the
> cases
> where this ratio has increased for 2 or more months in a row. does
anyone
> know how to do this in spss? thanks!
> --
> View this message in context:
>
http://www.nabble.com/Select-Cases-where-variable-increases-twice-in-a-row-t
> p19311692p19311692.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
>
[hidden email] (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
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
>
[hidden email] (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
>
>
--
View this message in context:
http://www.nabble.com/Select-Cases-where-variable-increases-twice-in-a-row-tp19311692p19320017.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
Locked
