topic Calculation for Crude Rate in SAS Health and Life Sciences

Calculation for Crude Rate

prjadhav00 — Fri, 18 Jan 2019 04:12:21 GMT

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.

Re: Calculation for Crude Rate

PGStats — Fri, 18 Jan 2019 05:24:07 GMT

Please describe your data for us and define crude rate.

Re: Calculation for Crude Rate

ballardw — Fri, 18 Jan 2019 15:22:21 GMT

@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?

Re: Calculation for Crude Rate

prjadhav00 — Fri, 18 Jan 2019 15:31:23 GMT

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.

Re: Calculation for Crude Rate

Reeza — Fri, 18 Jan 2019 16:22:49 GMT

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.