I have source data on patients that have had surgery within certain dates. From this source data, I wish to identify if the same patient has returned to the operating room within the dates I have selected in the date parameter.
I am able to readily exclude any patients with a count not greater than 1.
For patients that have a count of >1 I wish to see only those patients with the same exact account number. If the patient has a different account number, I do not wish to see the patient on my output.
I am sorting by name, account, date of surgery.
Here is an example of source data. In this example, I wish to see ONLY Jones on the output they have the same account number. I am not sure if it matters, but case number is always a unique number, it never repeats.
Name Account Date CaseNo
Doe, John 912 1/3/2014 101
Smith, Bob 965 1/6/2014 145
Smith, Bob 972 1/8/2014 162
Jones, Mike 989 1/10/2014 189
Jones, Mike 989 1/16/2014 194
I am using CR10. I am thinking this might relate to some formula that uses previous in the syntax. Any suggestions or approaches to doing this would be most appreciated.
I am able to readily exclude any patients with a count not greater than 1.
For patients that have a count of >1 I wish to see only those patients with the same exact account number. If the patient has a different account number, I do not wish to see the patient on my output.
I am sorting by name, account, date of surgery.
Here is an example of source data. In this example, I wish to see ONLY Jones on the output they have the same account number. I am not sure if it matters, but case number is always a unique number, it never repeats.
Name Account Date CaseNo
Doe, John 912 1/3/2014 101
Smith, Bob 965 1/6/2014 145
Smith, Bob 972 1/8/2014 162
Jones, Mike 989 1/10/2014 189
Jones, Mike 989 1/16/2014 194
I am using CR10. I am thinking this might relate to some formula that uses previous in the syntax. Any suggestions or approaches to doing this would be most appreciated.