Using SAS enterprise guide 7.1 32 bit. My department receives a monthly membership listing. January's data might not show a term date for a member, but February will. People will often change subscriptions, so a member can have multiple effective and expired dates in a year on various products. Below is the bare minimum data. EFFDAT is Effective date. EXPDAT is a term/expired date. 279999 means there is no term date. All subscriptions begin on the first of the month and end the last day of the month. So 201804 means an effective date of 4/1/2018. For 201804 initially there was no term date, but then they termed 201905 (or 5/30/2015) and went to a new product. They started a new product 201906. Initially there was no term date on 201906 effective date but then they termed 201910 and started a new product 201911 with no term date. I have a dozen fields I want to append to the records when I get to the desired result. Below is one sample member record with the desired result below. I do not want to change dates to a date format. I already have a methodology to count months of membership using the date formats used. I am a novice and write basic queries. I think this will need some elementary code. No idea where that goes in my query, but I can probably ask a coworker. I have summarized my data to the data below, but I need another level of summary as shown in desired results. Thanks- I hope this is easy. Data MEMBNO EFFDAT EXPDAT 23000 201804 279999 23000 201804 201905 23000 201906 279999 23000 201906 201910 23000 201911 279999 Desired result MEMBNO EFFDAT EXPDAT 23000 201804 201905 23000 201906 201910 23000 201911 279999
... View more