How do i get only beneficiaries who have specific proc code A3789 billed more than 4 units per month

[Velidi]

Where
CPT_4_Procedure_Code in (‘A3789’)
And Line_item_units >4

I used above code but there are many claim lines for each beneficiary with diff dates.
I want to convert claim line from date -thru date to month so that i can know how many benes have more than 4 units for month for that code.

[Reeza]

Please post some example data that illustrates your data structure and the expected output. Then we can assist with code. If you cannot provide the real data, please make fake data that's similar. It doesn't have to be the full data set but it should replicate the data structure.

[Velidi]

This is sample data set

[Reeza]

@Velidi sorry, no data or attachments came through. You cannot attach anything via email.

Ideally, you can provide it as a data step following the instructions here:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

[PGStats]

If your WHERE condition is part of a SQL query, it could be as simple as

...

Where
CPT_4_Procedure_Code in (‘A3789’)

group by intnx("month", date, 0)

having sum(Line_item_units) > 4;

[Reeza]

Would that handle if there were repeated entries as well as crossing of month intervals?

[PGStats]

@Reeza that code handles the simplest case where the data is clean and the monthly intervals correspond to calendar months.