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.     ... View more

I guess what you mean is what age will a person attain during a year.  If so, then you simply want the age as of DEC 31 of that year.  So for 2008, use the date literal for dec 31, 2008:   proc sql; create table Cohort as Select *, floor(YRDIF(BENE_BIRTH_DT,'31dec2008'd,"AGE")) as memberAge ...   Note I embedded the YRDIF function in the FLOOR function, assuming you want age as integers. ... View more

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. ... View more

@prjadhav00 wrote:   Not able to get a right output. any suggestion or comments are highly appriciated. Example input and example of the "right output" are likely needed. ... View more

I guess what you mean is what age will a person attain during a year.  If so, then you simply want the age as of DEC 31 of that year.  So for 2008, use the date literal for dec 31, 2008:   proc sql; create table Cohort as Select *, floor(YRDIF(BENE_BIRTH_DT,'31dec2008'd,"AGE")) as memberAge ...   Note I embedded the YRDIF function in the FLOOR function, assuming you want age as integers. ... View more

@prjadhav00 wrote: Hello Reeza, Thanks for your suggestions. I tried the query that you provided but it's not giving me the specific DGNS_CD which I am looking for. Could you provide me with any other query related to this? Post the code you tried. I only posted a partial snippet so it depends on how you completed the query. Please include the log as well.  ... View more