Calculation for Crude Rate

[prjadhav00]

Can anyone help me to find out the crude rate of those with at least 1 visit to a Primary Care Provider.

BENE_ID                         CLM_ID                  CLM_DT_FR    CLM_DT_TR

01484346DF13FDE8    887343384983726    08/11/2008    08/11/2008
01BB2E5E0A4EF55C    887123387171534    04/07/2008    04/07/2008
04AF3732C0837C61    887623386271415    05/24/2008    05/24/2008
04AF3732C0837C61    887853385459077    07/13/2008    07/14/2008
07227E2794EF8235    887483386113586    01/09/2008    01/09/2008
083F026C518FAAA1    887293386207388    10/20/2008    10/20/2008
0AFEF13156E38135    887053386936590    05/01/2008    05/01/2008
121DF90519C430ED    887263388966616    11/04/2008    11/06/2008
134845E26F9FD9BC    887283386254310    03/21/2008    03/21/2008
1D6714DB9467D669    887873388476246    05/26/2008    05/26/2008
1EAFF13090701F02    887643388511650    05/27/2008    05/27/2008
1F85978A5149E736    887063386540235    10/14/2008    10/15/2008
2730EDBB92473DE0    887423388450325    08/08/2008    08/08/2008
2908221F6E995376    887793387485959    07/26/2008    07/26/2008
2B4A3D3FE3451395    887013384971228    09/14/2008    09/14/2008
2B79429BAC37A24B    887283389068141    12/12/2008    12/12/2008
2BCF033D913036CD    887213386025006    10/25/2008    10/25/2008
2E220DB6F9DF1BDC    887883389084603    08/07/2008    08/08/2008
2EFD718FA88E6B50    887383388646171    08/17/2008    08/17/2008
31890A0A9423B3B8    887943385363218    03/16/2008    03/16/2008
33A8CC5DA4F3F809    887183388843848    04/12/2008    04/12/2008
353EA1EBC5B2BDA7    887853387852580    10/19/2008    10/19/2008
3588BBCBA2149362    887903384892390    01/29/2008    01/29/2008
359C146C8FCE2317    887973385019933    08/03/2008    08/03/2008
39692D88760E643F    887743385661271    05/31/2008    05/31/2008
3CC3E27E4E3C7702    887153389410018    10/24/2008    10/24/2008

Thanks in advance.

[PGStats]

Please describe your data for us and define crude rate.

[prjadhav00]

Thnks for getting back to me.

This is the table for the 1 visit to a Primary Care Provider. I already identified the 1 visit PCP.

BENE_ID = patients id

CLM_ID = claims

CLM_DT_FR= claims date from

CLM_DATE_TR= claims date through

I need to find out what is the crude rate between BENE_ID and CLM_DT_FR. I am not able to write a appropriate PROC SQL code to find out the crude rate.

[ballardw]

---

@prjadhav00 wrote:

Can anyone help me to find out the crude rate of those with at least 1 visit to a Primary Care Provider.

---

"Those" what? I suspect something like "those patients" or "those clients". Then we would need to know which of your variables identifies your patient or client or which ever the "those" refers to.

Next, how do we tell from the example data that the patient/client has a visit to a "Primary Care Provider"?

And likely for a rate we also have to have the patients/clients that did not have a visit to a primary care provider. Is that in this data?

And lastly, is there a time frame involved such as a specific calendar year or quarter or within  a specific range of dates? And if so, which of the date variables shown would be used to determine the dates?

[Reeza]

What should the expected value be from the data you've shown?

Can you show us the calculation in Excel and/or explain the logic in detail?

People are clearly willing to help, so please spend some time detailing the process so we can help you out.

---

@prjadhav00 wrote:

Can anyone help me to find out the crude rate of those with at least 1 visit to a Primary Care Provider.

BENE_ID                         CLM_ID                  CLM_DT_FR    CLM_DT_TR

01484346DF13FDE8    887343384983726    08/11/2008    08/11/2008
01BB2E5E0A4EF55C    887123387171534    04/07/2008    04/07/2008
04AF3732C0837C61    887623386271415    05/24/2008    05/24/2008
04AF3732C0837C61    887853385459077    07/13/2008    07/14/2008
07227E2794EF8235    887483386113586    01/09/2008    01/09/2008
083F026C518FAAA1    887293386207388    10/20/2008    10/20/2008
0AFEF13156E38135    887053386936590    05/01/2008    05/01/2008
121DF90519C430ED    887263388966616    11/04/2008    11/06/2008
134845E26F9FD9BC    887283386254310    03/21/2008    03/21/2008
1D6714DB9467D669    887873388476246    05/26/2008    05/26/2008
1EAFF13090701F02    887643388511650    05/27/2008    05/27/2008
1F85978A5149E736    887063386540235    10/14/2008    10/15/2008
2730EDBB92473DE0    887423388450325    08/08/2008    08/08/2008
2908221F6E995376    887793387485959    07/26/2008    07/26/2008
2B4A3D3FE3451395    887013384971228    09/14/2008    09/14/2008
2B79429BAC37A24B    887283389068141    12/12/2008    12/12/2008
2BCF033D913036CD    887213386025006    10/25/2008    10/25/2008
2E220DB6F9DF1BDC    887883389084603    08/07/2008    08/08/2008
2EFD718FA88E6B50    887383388646171    08/17/2008    08/17/2008
31890A0A9423B3B8    887943385363218    03/16/2008    03/16/2008
33A8CC5DA4F3F809    887183388843848    04/12/2008    04/12/2008
353EA1EBC5B2BDA7    887853387852580    10/19/2008    10/19/2008
3588BBCBA2149362    887903384892390    01/29/2008    01/29/2008
359C146C8FCE2317    887973385019933    08/03/2008    08/03/2008
39692D88760E643F    887743385661271    05/31/2008    05/31/2008
3CC3E27E4E3C7702    887153389410018    10/24/2008    10/24/2008

Thanks in advance.

---