PROC SQL query for hospital utilization

[prjadhav00]

Hello,

I am currently work on hospital utilization data where I can accross to the following questions:

"Amongst beneficiaries who have CHF, provide the crude rate of those with at least 1 visit to a Primary Care Provider

Office visits are defined using CPT codes: ‘99201’-‘99205’ & ‘99211’-‘99215’"

Could any one suggest me any PROC SQL query to get an appropriate output. 

Thanks in advance.

[PeterClemmensen]

Can you provide us with some example data and what you want your desired result to look like? Makes it so much easier to provide a usable code answer 🙂

[prjadhav00]

Thanks for getting back to me.

suppose, the sample table:

CHF_BEN_ID CHF_DIG_CODES(character) CPT_CODES
1 39891
99201
2 40211
99205
3 40291
99211
4 40411
99215
5 40413
99205
6 40491
99201
7
39891 99215

from this I have to find crude rate of those with at least 1 visit to a
Primary Care Provider Office visits are defined using CPT codes:
‘99201’-‘99205’ & ‘99211’-‘99215’

[ballardw]

Is the problem selecting data or calculating the rate or both?

[Reeza]

I don't think we can answer this based on what you've provided. To find the crude rate you'd have to know the total population and then calculate how many people had an entry for that period of interest. In my experience these may not be in the same database, especially the denominator.