Hi,
I am trying to find if a date in a variable falls under Month1,Month2, Month3,Month4....Month6 category using a do loop between startdt and incremented startdate i.e., Startdate+30.
By running the below logic, I get a value for the first record as Month2 and a value for rest of the Months too which is not correct. How can i fix this logic?
dataset--
start vardt enddt
01Jan2017 11Mar2017 01Jan2018
01Jan2017 02May2017 01Jan2018
01Jan2017 11Apr2017 01Jan2018
data test2; set test1;
mindt=startdt; maxdt=enddt;
array Months(6);
Mnth=30; start=mindt;
do i = 1 to Months;
mnth=mnth+30;
stopdt=maxdt; if startdt <= vardt<=startdt+mnth then Months(i)=1;
end; start=start+mnth;
drop i; run;
Thank you in advance.
... View more