Help Determining time within a few cases
Locked
Help Determining time within a few cases
 
|
I’m needing some help. Every time a juvenile is seen doing a good deed, his bracelet is scanned and entered in a database ( a few cases below) I’m trying to omit the tickets that were within a 5 minute time frame. Any suggestions on how to write a syntax for this. I have 701584 cases involving 694 juveniles (IDNO)
Stella Vasquez Research & Development (602) 542-2272 **The information contained in this communication is privileged and confidential and is intended solely for the individual[s] and/or entities named herein. This information is not to be disseminated. If you have received this message in error, please reply to the sender and notify the sender of the error and then permanently delete the message and sent item. Thank you.** ===================== 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 |
Re: Help Determining time within a few cases
Administrator
|
Look at the LAG and DATEDIFF functions in the FM!
That will provide sufficient information.
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?" |
|
|
In reply to this post by Stella Vasquez
Stella, There are likely several ways to do this, but one that comes to mind is to calculate the time difference then select the ones that are not 0-5 min from the last. *** Set the value to 0 (will be 0 for all first IDNo). Compute TimeDiff=0. *** Calculate time differences if IDNo is the same. If (IDNo=lag(IDNo)) TimeDiff=DATEDIF(IssuedDateTime, lag(IssuedDateTime), "minutes"). Execute. *** Add any other edits/checks you may need. Compute Keep=( timediff=0 or timediff>5). Sel if Keep=1. Melissa From: SPSSX(r) Discussion [mailto:[hidden email]]
On Behalf Of Stella Vasquez I’m needing some help. Every time a juvenile is seen doing a good deed, his bracelet is scanned and entered in a database ( a few cases below) I’m trying to omit the tickets that were within a 5 minute time frame. Any suggestions on how to write a syntax for this. I have 701584 cases involving 694 juveniles (IDNO)
Stella Vasquez Research & Development (602) 542-2272 **The information contained in this communication is privileged and confidential and is intended solely for the individual[s] and/or entities named herein. This
information is not to be disseminated. If you have received this message in error, please reply to the sender and notify the sender of the error and then permanently delete the message and sent item. Thank you.** ===================== 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
This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations. ===================== 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 |
| Free forum by Nabble | Edit this page |