topic Re: How do i get only beneficiaries who have specific proc code A3789 billed more than 4 units per m in New SAS User

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

Velidi — Sun, 14 Jun 2020 02:02:03 GMT

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.

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

Reeza — Sun, 14 Jun 2020 02:10:42 GMT

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.

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

PGStats — Sun, 14 Jun 2020 02:16:20 GMT

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;

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

Reeza — Sun, 14 Jun 2020 02:27:28 GMT

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

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

PGStats — Sun, 14 Jun 2020 02:32:02 GMT

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

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

Velidi — Sun, 14 Jun 2020 03:16:01 GMT

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

Velidi — Sun, 14 Jun 2020 03:57:17 GMT

This is sample data set

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

Reeza — Sun, 14 Jun 2020 16:58:21 GMT

@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-data-AKA-generate/ta-p/258712