filter dates

[Shirley Scholtz]

Dear all,

I am trying to filter out  old “Monthly tracking dates” and keep the latest dates only. For example, for ID # 885 I only need to know his/her employment status on 2/26/15, #925 employment status on 3/11/2015, #937 on 2/27/15 and so forth. Can anybody help?

 

Thank you in advance,

Shirley

 

Record ID	Date of Enrollment		Monthly Tracking Date		8. Employment status during this reporting period...
885	07/14/2014		01/30/2015		Unemployed/Not Looking
885	07/14/2014		02/26/2015		Unemployed/Not Looking
885	07/14/2014		12/03/2014		Unemployed/Actively Looking for Employment
925	10/03/2014		01/13/2015		Did odds or occasional jobs
925	10/03/2014		02/20/2015		Employed full-time
925	10/03/2014		03/11/2015		Employed full-time
925	10/03/2014		11/10/2014
925	10/03/2014		12/04/2014		Did odds or occasional jobs
926	10/03/2014		01/01/2015		Unemployed/Actively Looking for Employment
926	10/03/2014		01/30/2015		Unemployed/Actively Looking for Employment
926	10/03/2014		02/26/2015		Unemployed/Actively Looking for Employment
926	10/03/2014		12/03/2014
927	10/03/2014		02/25/2015
927	10/03/2014		11/30/2014		Unemployed/Not Looking
927	10/03/2014		12/22/2014
935	10/03/2014		01/28/2015		Unemployed/Actively Looking for Employment
935	10/03/2014		02/24/2015
935	10/03/2014		11/30/2014		Unemployed/Not Looking
935	10/03/2014		12/22/2014
937	10/03/2014		01/01/2015
937	10/03/2014		01/30/2015		Employed part-time
937	10/03/2014		02/27/2015		Employed part-time
937	10/03/2014		12/03/2014		Unemployed/Actively Looking for Employment

 

===================== 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

[David Marso]

Sort the file ascending on ID, descending on M_T_D then use FIRST function of MATCH FILES to flag them.

[Shirley Scholtz]

Thank you, thank you David. Computer was down after I sent out the request.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Marso
Sent: Monday, March 23, 2015 6:35 PM
To: [hidden email]
Subject: Re: filter dates

Sort the file ascending on ID, descending on M_T_D then use FIRST function of MATCH FILES to flag them.




-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/filter-dates-tp5729027p5729029.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