Date:         Tue, 22 Nov 2005 14:03:58 -0600
Reply-To:     "Marks, Jim" <Jim.Marks@lodgenet.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Marks, Jim" <Jim.Marks@lodgenet.com>
Subject:      Re: select case
Content-Type: text/plain; charset="US-ASCII"

Not tested:
 
COMPUTE sel_v1 EQ LAG(v2) =1 OR LAG(v2,2) = 1.
SORT CASES BY v1 (D).
IF LAG(v2) =1 OR LAG(v2,2) = 1 sel_v1 = 1.
EXECUTE.
 
--jim

  _____  

From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Fenghua Peng
Sent: Tuesday, November 22, 2005 1:53 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: select case



 

 

Hello,

 

I have a file below. V1=case number. I want to select the 2 cases after
V2=1 and 2 cases before V2=1. For the following file, I will choose case
1,2,4,5 and case 9,10,12,13. How could I do? Thank you so much for your
help.

 

V1  V2

1   

2   

3    1

4    

5   

6   

7   

8

9

10

11  1

12

13

14

15

 

Pansy