|
If you sort by PATIENT and DOS then you can flag any patient that has
repeated a DOS. Hopefully, that patient can only see the same provider only
once per day. See the *untested* code below.
proc sort data = in out = sorted ;
by patient dos ;
run ;
data flagged ;
set sorted ;
by patient dos ;
if first.dos and last.dos then flag = 0 ;
else flag = 1 ;
run ;
The flag value of 1 should contain the patients you are looking for.
On Thu, 11 Aug 2005 14:23:26 -0400, Khan, Muhammad Z. <MKhan@OXHP.COM>
wrote:
>Dear users,
> I have a SAS dataset with about 25 provider with date of service
and their patient information. I'm trying to find out who billed for the
same member and same date of service. For example, provider 99999 and
provider 888888 could see the same member at the same dos, I woul like to
see that, in one case provider 66666 and provider 99999 could see the same
patient at the same date that should be included also, I think there could
be many combinations to this problem. Any help with this would be
appreciated. Please reply to my email address as can't access the digest
itself.
>
>Thanks
>
>Muhammad
>
>table layout
>
>provider patient dos
>999999 123456 01jan2000
>888888 456789 30jan2002
>.....
| 
