Gap month Logic

raveena — Mon, 09 Jul 2012 17:55:04 GMT

Hi all,

Membno GRPNUM EFFDAT EXPDAT GAP GAP Month Reqd

123 PI 20120601 99999999 0 N/A

ABC LI 20120201 20120201 0 N/A

ABC H1NAS 20120201 20120331

ABC PAMAS 20120401 99999999

DEF LI 20120101 20120229 2

DEF H1NAS 20120401 20120430 20120301

DEF PAMAS 20120601 99999999 20120501

GHI LI 20120201 20120229 1

GHI H1NAS 20120301 20120331

GHI PAMAS 20120401 20120430

GHI PAMAS 20120601 20120630 20120501

JKL LI 20120401 20120430 0

JKL H1NAS 20120501 20120531

JKL PAMAS 20120601 9999999

MNO LI 20120101 20120331 0

MNO H1NAS 20120401 20120430

SO the member ABC is not enrolled for the month of Jan and we don’t want this Memb to be included

SO the member DEF we need him for he has a GAP in enrollment for the month of March and May. So total GAP = 2

For the Member GHI, we need him as he has a GAP in enrollment for the month of May, so GAP = 1

For the Member JKL, we don’t need him as he has NO GAP even though he is not enrolled for Jan thru March

For the Member MNO, we don’t need him as his enrollment ended in April and he is no longer enrolled

We need ONLY those Members who have a GAP in their enrollment period

Please help me with the above logic.

Thanks in Advance

topic Gap month Logic in SAS Procedures