Hi team, Please kindly help me on this logic. this is my sample code. data test_data; set Final_Data_IPAS_PR_Claims; '28FEB2014'n= min(base_pre,max(0,((19782-'Policy Start Date'n+1)/(Policy_Term*365)*base_pre))); '31MAR2014'n= min(base_pre,max(0,((19813-'Policy Start Date'n+1)/(Policy_Term*365)*base_pre))); '30APR2014'n= min(base_pre,max(0,((19843-'Policy Start Date'n+1)/(Policy_Term*365)*base_pre))); '31MAY2014'n= min(base_pre,max(0,((19874-'Policy Start Date'n+1)/(Policy_Term*365)*base_pre))); '30JUN2014'n= min(base_pre,max(0,((19904-'Policy Start Date'n+1)/(Policy_Term*365)*base_pre))); . . . run; I am doing this manally, with many steps i need some array and loop combination to get it right. I need some logic to create the month end date as column names from 30APR2014 to SEP2016 and the numeric value of the particular coulumn should be used in the condition. Logic is same across all the columns created. Just i need to change the numeric value highlighted in the formula according to the column date. (Means the numeric value of the month end date should be used there)..
... View more