cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
caaich
‎05-16-2017
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-27-2016 10:34 AM
‎05-27-2016 10:34 AM
Thank you, this worked perfectly and took just under 4 hours to run!  ... View more

Re: Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-24-2016 05:15 PM
‎05-24-2016 05:15 PM
That is not the start of a cycle because the 26JAN2014 for person 3 has a reason of 9. It should only count as a cycle if it started with 1/3, had one or more 4/5's, and ended in a 1/3 with no other reason types within the cycle. Anytime there is a different reason type the prior 1/3 and 4/5's are no longer eligible to be part of a cycle. ... View more

Re: Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-24-2016 04:59 PM
‎05-24-2016 04:59 PM
No, but a cycle start shouldn't be indicated if that person doesn't also have an end within this data. So if they didn't have a 1 or 3 also followed by a 4 or 5 also followed by a 1 or 3 then for this purpose they should not have a cycle start. Hopefully that makes more sense? ... View more

Re: Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-24-2016 03:41 PM
‎05-24-2016 03:41 PM
Thanks for the try! This code is also identifying cycles that have other reasons in between (like 1 followed by a 9 or a 3 followed by a 1) and it is not requiring a cycle end before identifying another start. ... View more

Re: Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-24-2016 10:56 AM
‎05-24-2016 10:56 AM
This version is very close to working! There is one pattern that is not being accounted for with this code. When a person has multiple 01/03 it is assigning two cycle starts and one end after the second cycle start instead of one start and one end. I pasted an example of what I am referring to below. The current cycle start/end is what the code is doing and the correct cycle start/end is what should be captured. The end of one cycle may not be the begining of another cycle. Any ideas on how to modify the code to address these situations? Also any other ideas to make it faster would be great, it did take a while to run. Thanks again!! LocationID PersonID Date Reason Current cycle start Current cycle end Correct cycle start Correct cycle end 1 1 1/11/2014 01         1 1 1/12/2014 09         1 1 1/13/2014 01         1 1 1/14/2014 06         1 1 1/15/2014 03 1   1   1 1 1/16/2014 04         1 1 1/17/2014 03 1     1 1 1 1/18/2014 04         1 1 1/19/2014 04         1 1 1/20/2014 03   1     ... View more

Re: Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-22-2016 12:15 PM
‎05-22-2016 12:15 PM
Thank you!! This code does work on my mini dataset but I know that my larger dataset has patterns that the small dataset doesn't capture. I am going to run this code on the large dataset (@20 million obs) tomorrow morning and I will update then.  ... View more

Flagging the start of a pattern across observations within a group

by Calcite | Level 5 in SAS Data Management
‎05-21-2016 09:41 AM
‎05-21-2016 09:41 AM
Hi everyone,   I am hoping someone can help me! I am working with data that have multiple observations per person, each with a different reason for the observation. The pattern must start with a reason of 1 or 3, have one or more observations with a 4 or 5, and end with an observation of a 1 or 3. The number of observations within a pattern can vary and this pattern may occur multiple times for one person. I have the end of the pattern I am looking for flagged but I now need to flag the start of the pattern I am looking for as well as populate that observation with the number of 4/5's that follow prior to the pattern ending 1 or 3 observation. I have put together some fake numbers in an effort to help explain what I am looking for. I am using SAS 9.4.   LocationID PersonID Date Reason Cycle_end(have) Cycle_start(need) Count(need) 1 1 1/2/2014 01   1 3 1 1 1/3/2014 04       1 1 1/4/2014 05       1 1 1/5/2014 04       1 1 1/6/2014 01 1     1 1 1/7/2014 03   1 3 1 1 1/8/2014 04       1 1 1/9/2014 05       1 1 1/10/2014 04       1 1 1/11/2014 01 1     1 1 1/12/2014 09       1 2 1/13/2014 01       1 2 1/14/2014 09       1 2 1/15/2014 01   1 2 1 2 1/16/2014 04       1 2 1/17/2014 04       1 2 1/18/2014 01 1     1 2 1/19/2014 01   1 2 1 2 1/20/2014 04       1 2 1/21/2014 05       1 2 1/22/2014 03 1     2 3 1/23/2014 01       2 3 1/24/2014 04       2 3 1/25/2014 04       2 3 1/26/2014 09       2 3 1/27/2014 01   1 2 2 3 1/28/2014 04       2 3 1/29/2014 05       2 3 1/30/2014 03 1     2 4 1/31/2014 01       2 4 2/1/2014 04       2 4 2/2/2014 04       3 5 2/3/2014 04       3 5 2/4/2014 04       3 5 2/5/2014 01   1 3 3 5 2/6/2014 04       3 5 2/7/2014 04       3 5 2/8/2014 04       3 5 2/9/2014 03 1     3 6 2/10/2014 06       3 6 2/11/2014 08       Thanks for any help!!  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-16-2017 01:05 PM
Quick links