Sounds like you the September that's in the future. Assuming SAS Dates, since you haven't specified, something like the following: *claimDate=input(claim_date, yearmon7.); *if claim_date is a character variable can be converted using the input function; if month(claimDate)<=9 then RenewalDate=mdy(9,1, year(claimDate)); else RenewalDate=mdy(9,1, year(claimDate)+1); Format renewalDate monyy7.;
... View more