topic Re: Need to bring in codes with same date of service to show person is getting billed twice in same in SAS Programming

Need to bring in codes with same date of service to show person is getting billed twice in same day

anonymous_user — Fri, 11 Dec 2020 14:10:37 GMT

Hi,

I am really stuck on this and I have figured this out manually before via pivots and whatnot but I'm blanking out on this now.

What is the way to do this in SAS? Here is an example of my data:

ID Procedure Code Date of Service

567 93880 1/1/2020

567 93306 1/1/2020

567 93880 3/1/2020

567 93306 3/1/2020

689 93880 2/1/2020

689 93306 2/1/2020

I would only want to bring in those where the ID uses BOTH codes and happened on the same day so that I can then total the dollars associated with those people.

Please help if you have any ideas. Thank you

Re: Need to bring in codes with same date of service to show person is getting billed twice in same

andreas_lds — Fri, 11 Dec 2020 18:10:11 GMT

Please post what you expect as result from the data you have posted.

And some more questions:

- is date_of_service a sas-date?

- how many different values are stored in procedure_code? just two?

Re: Need to bring in codes with same date of service to show person is getting billed twice in same

Tom — Fri, 11 Dec 2020 18:52:59 GMT

Try this in PROC SQL.

create table want as 
  select * from have
  group by ID, date_of_service
  having max(case when (procedure='93880') then 1 else 0) = 1
     and max(case when (procedure='93306') then 1 else 0) = 1
;