topic Re: PROC SQL query for hospital utilization in SAS Health and Life Sciences

PROC SQL query for hospital utilization

prjadhav00 — Tue, 15 Jan 2019 19:09:38 GMT

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.

Re: PROC SQL query for hospital utilization

PeterClemmensen — Tue, 15 Jan 2019 19:35:45 GMT

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 🙂

Re: PROC SQL query for hospital utilization

prjadhav00 — Tue, 15 Jan 2019 19:55:02 GMT

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’

Re: PROC SQL query for hospital utilization

ballardw — Tue, 15 Jan 2019 21:28:05 GMT

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

Re: PROC SQL query for hospital utilization

Reeza — Wed, 16 Jan 2019 04:43:09 GMT

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.