Sorry, I'm still a bit new to SAS. you almost got the fields named correctly too. The 5 years matter because someone can start before the first date that I want to know if its valid and expire after, I just don't know how to capture them, but while getting this small data set together i realized that I could just separate the 5 year licenses just pull those that were purchased between 11/19/2012-11/19/2019 and that would accomplish the same thing. I could also be explaining this poorly. but here is a sample of the data set. data have; input id $ (startDate expireDate) (:yymmdd10.); format startDate expireDate yymmddd10.; datalines; 123456 2017-11-19 2018-11-19 123565 2015-07-23 2020-07-23 995874 2017-11-16 2018-11-16 986632 2005-01-08 2099-01-08 ;
... View more
