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: 
tlianee
‎12-30-2020
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How do I flag a "new" situation within the same id?

by Calcite | Level 5 in SAS Programming
‎12-30-2020 02:43 AM
‎12-30-2020 02:43 AM
@PhilC the datetimes are only examples. I have not had success with getting lag to work as the same department can be on the first line in the next id. @ballardw it is what happens to the line if the call that should trigger a flag. Since the next line in ID1 has another deperatment the first line get a flag as this call is transfered. ID 2 all the lines are within the same department and should therefore not get a flag, which is the same with observation 2 and 3 in ID 3 where these are within the same department but the fourth should get a flag as the next line is a diffenrent department. This also means that the last observation per ID never can have a flag. @gamotte Thanks...I'll look into your solution. ... View more

How do I flag a "new" situation within the same id?

by Calcite | Level 5 in SAS Programming
‎12-29-2020 08:56 AM
‎12-29-2020 08:56 AM
I have a dataset where I want to "flag" every time a call is forwarded. It can be forwarded back and forth between the same departments, but have to count every time it occurs. A call can also be forwarded within the same department but then it shall not be flaged. When a call is received it gets an id that is "locked" until the call has ended. I have tried to give the example below. The first four columns is what I already have.   id datetime department count flag 1 01-01-2020 10:00 aaa 1 1 1 02-01-2020 10:00 bbb 2 1 1 03-01-2020 10:00 ccc 3 1 1 04-01-2020 10:00 aaa 4 0 1 05-01-2020 10:00 aaa 5 1 1 06-01-2020 10:00 ccc 6 0 2 01-01-2020 10:00 bbb 1 0 2 02-01-2020 10:00 bbb 2 0 2 03-01-2020 10:00 bbb 3 0 2 04-01-2020 10:00 bbb 4 0 2 05-01-2020 10:00 bbb 5 0 3 01-01-2020 10:00 aaa 1 1 3 02-01-2020 10:00 ddd 2 0 3 03-01-2020 10:00 ddd 3 0 3 04-01-2020 10:00 ddd 4 1 3 05-01-2020 10:00 aaa 5 0 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-30-2020 06:03 AM
Quick links