topic determining surgeon volume in Statistical Procedures

determining surgeon volume

yubaraj — Mon, 09 Aug 2021 21:03:47 GMT

Hi I want to get surgeon volume within previous 365 days of the operation on a person.

My objective is to test the hypothesis that if a surgeon performed greater number of operation in the last 1 year then their operation is more likely to succeed.

All I have is records per each service users. The recipient ID can duplicate because if someone has a operation in first leg then they also can have operation in second leg. I am interested in first operation

data WORK.docs_have(label='Surgery Data');
    input  rcpt_id:32. service_date:date9. physician_id:32.;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 
 1123 13OCT2010 3354 
 1267 18JAN2011 3354 
 1123 15AUG2011 3354
 1145 30NOV2009 2234 
 1323 24JAN2010 2234 
 1122 29JAN2010 2234 
 1122 13SEP2010 2234 

 ;;;;


 data WORK.docs_want(label='Surgery Data_want');
    input  rcpt_id:32. service_date:date9. physician_id:32. surg_vol:12;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 0
 1123 13OCT2010 3354 0
 1267 18JAN2011 3354 1
 1123 15AUG2011 3354 2
 1145 30NOV2009 2234 0
 1323 24JAN2010 2234 1
 1122 29JAN2010 2234 2
 
 
 

 ;;;;

The variables are

recipient ID (rcpt_id) service date (service_date) and provider ID (physician_id),

Re: determining surgeon volume

ballardw — Mon, 09 Aug 2021 22:25:34 GMT

@yubaraj wrote:

Hi I want to get surgeon volume within previous 365 days of the operation on a person.

My objective is to test the hypothesis that if a surgeon performed greater number of operation in the last 1 year then their operation is more likely to succeed.

All I have is records per each service users. The recipient ID can duplicate because if someone has a operation in first leg then they also can have operation in second leg. I am interested in first operation
data WORK.docs_have(label='Surgery Data');
    input  rcpt_id:32. service_date:date9. physician_id:32.;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 
 1123 13OCT2010 3354 
 1267 18JAN2011 3354 
 1123 15AUG2011 3354
 1145 30NOV2009 2234 
 1323 24JAN2010 2234 
 1122 29JAN2010 2234 
 1122 13SEP2010 2234 

 ;;;;


 data WORK.docs_want(label='Surgery Data_want');
    input  rcpt_id:32. service_date:date9. physician_id:32. surg_vol:12;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 0
 1123 13OCT2010 3354 0
 1267 18JAN2011 3354 1
 1123 15AUG2011 3354 2
 1145 30NOV2009 2234 0
 1323 24JAN2010 2234 1
 1122 29JAN2010 2234 2
 
 
 

 ;;;;
The variables are

recipient ID (rcpt_id) service date (service_date) and provider ID (physician_id),

How about walking us through just how the first values of 0, 1 and 2 are derived. Step by step. Because I don't see any thing obvious about why this gets zero

 1356 22NOV2008 3354 0

And this gets 2

 1123 15AUG2011 3354 2

Re: determining surgeon volume

yubaraj — Mon, 09 Aug 2021 22:45:22 GMT

1356 22NOV2008 3354 0

For surgeon_id 3354 surgery on patient 1356 (rcpt_id) was first so there is no previous surgery by that surgeon before 365 days of this surgery.

1123 13OCT2010 3354 0
This is 0 because the previous surgery by that surgeon was not in last 365 days.

1123 15AUG2011 3354

Sorry, this observation should have deleted on the 'want' database. since this was second surgery on subject 1123.

so basically, I am interested in first surgery for each subject, and number of first surgeries done in last 365 days by each surgeon.

Re: determining surgeon volume

Reeza — Mon, 09 Aug 2021 22:55:36 GMT

Here's one way, but the results don't match.

The TEMP data set is very close but you have a person 1123 who has been listed twice which you don't want for ID 1122. What's the logic between those two differing criteria? I'm guessing you likely have a different field you need to include in this logic as well.

This code handles them the same.

data WORK.docs_have(label='Surgery Data');

    input  rcpt_id:32. service_date:date9. physician_id:32.;
    ID = _n_;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 
 1123 13OCT2010 3354 
 1267 18JAN2011 3354 
 1123 15AUG2011 3354
 1145 30NOV2009 2234 
 1323 24JAN2010 2234 
 1122 29JAN2010 2234 
 1122 13SEP2010 2234 

 ;;;;
 
proc sql;
create table temp as
select *, 
   (select count(distinct t2.rcpt_Id) 
   from docs_have as t2 
   where t1.physician_id = t2.physician_id 
   and t1.ID ne t2.ID and 
   t2.service_date between t1.service_date - 365 and t1.service_date) as num_procs
from docs_have as t1
order by rcpt_id, ID
;
quit;

data want;
set temp;
by rcpt_id;
if first.rcpt_id;
run;

@yubaraj wrote:

Hi I want to get surgeon volume within previous 365 days of the operation on a person.

My objective is to test the hypothesis that if a surgeon performed greater number of operation in the last 1 year then their operation is more likely to succeed.

All I have is records per each service users. The recipient ID can duplicate because if someone has a operation in first leg then they also can have operation in second leg. I am interested in first operation
data WORK.docs_have(label='Surgery Data');
    input  rcpt_id:32. service_date:date9. physician_id:32.;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 
 1123 13OCT2010 3354 
 1267 18JAN2011 3354 
 1123 15AUG2011 3354
 1145 30NOV2009 2234 
 1323 24JAN2010 2234 
 1122 29JAN2010 2234 
 1122 13SEP2010 2234 

 ;;;;


 data WORK.docs_want(label='Surgery Data_want');
    input  rcpt_id:32. service_date:date9. physician_id:32. surg_vol:12;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 0
 1123 13OCT2010 3354 0
 1267 18JAN2011 3354 1
 1123 15AUG2011 3354 2
 1145 30NOV2009 2234 0
 1323 24JAN2010 2234 1
 1122 29JAN2010 2234 2
 
 
 

 ;;;;
The variables are

recipient ID (rcpt_id) service date (service_date) and provider ID (physician_id),

 data WORK.docs_want(label='Surgery Data_want');
    input  rcpt_id:32. service_date:date9. physician_id:32. surg_vol:12;
   format service_date date9.;
 datalines;
 1356 22NOV2008 3354 0
 1123 13OCT2010 3354 0
 1267 18JAN2011 3354 1
 1123 15AUG2011 3354 2
 1145 30NOV2009 2234 0
 1323 24JAN2010 2234 1
 1122 29JAN2010 2234 2

Re: determining surgeon volume

yubaraj — Wed, 11 Aug 2021 17:49:54 GMT

Actually, I was interested in first surgery on a subject. So, when I selected first observation before running your code, it worked.
Thanks

Re: determining surgeon volume

Reeza — Wed, 11 Aug 2021 17:53:51 GMT

If you do that BEFORE running the code rather than after you may miss surgery counts though. Is that what you want to do, exclude surgeries if a surgeon worked on the same patient multiple times?

Re: determining surgeon volume

yubaraj — Wed, 11 Aug 2021 17:56:55 GMT

Yes, I am interested in first surgeries on a patient.