Date: Tue, 1 Mar 2005 13:46:27 +1100
Reply-To: Thara Vardhan <Thara.Vardhan@djj.nsw.gov.au>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Thara Vardhan <Thara.Vardhan@djj.nsw.gov.au>
Subject: eliminate records where the person was re-admitted on the same
day that they were discharged
Content-Type: text/plain; charset=US-ASCII
I tried the syntax that you have sent me but when i run the syntax i
have no records left in my data file. What have i done wrong?
What i am aiming to achieve is get a data file which will eliminate all
such records. I have checked my data file and i do have records where
the person has been re-admitted the same day that they were discharged.
I would really appreciate it if you could help me solve this problem.
The simplest syntax is as follows:
SELECT IF (personid=lag(personid) and admdate NE LAG(disdate)).
This selects all records where the two records belong to the same
the second admission date is not equal to the discharge rate in the
I recommend you save the working file (after this SELECT IF) under a
name. Otherwise you will lose the deleted records forever, not a very
idea in general.
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]
> On Behalf Of Thara Vardhan
> Sent: Monday, February 28, 2005 9:45 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: eliminate records where the person was re-admitted
> on the same day that they were discharged
> Dear List members
> can you please help me with a syntax for the following problem
> I want to eliminate records where the person was re-admitted
> on the same day that they were discharged. I want to write
> the syntax that will delete record b.
> for example my data contains records like these
> Personid admdate disdate
> 17152 27-MAY-2003 18-JUL-2003
> 17152 18-JUL-2003 26-SEP-2003
> Looking forward to your reply.
> Thara Vardhan
> Senior Project Officer
> Research, Planning & Evaluation Branch
> Tel: (02) 9219-9515
> This message is intended for the addressee named and may
> contain confidential information. If you are not the
> intended recipient, please delete it and notify the sender.
> Views expressed in this message are those of the individual
Senior Project Officer
Research, Planning & Evaluation Branch
Tel: (02) 9219-9515
This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Department of Juvenile Justice.