Hi All,   My data looks like this   ID      '28-Feb-14'n  ...'28-Feb-16'n  Policy_Start 101     90.20           .....  30.89           21JAN2014 102     76.90          ....... 45.67           13MAR2015 103     66.66           ...... 67.45            20JUN2015   i need to add up all the columns which are less than this formula New_Column=(sum(all_columns_which are less than policy_start+365 )<(policy_start+365)) please kindly note all the columns names are with date. So how i refer only those columns to sum up .   Please revert asap.   Thanks, Vamsi.     ... View more

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

  My data looks like below    Cust_id_lag and policy_lag are the columns on which i applied lag for the first two columns of the below dataset. Ploicy_NO Cust_iD Smo_Flag Cust_ID_lag Policy_lag 1011 36543 Y . . 1011 36543 N 36542 1011 1011 45654 N 36543 1011 2011 77567 Y 45654 1011 2011 77567 N 77567 2011   My output should be    I need a new flag accordingly as New_smo_flag  My conditon should be if policy_no=Policy_lag   and Cust_iD=Cust_ID_lag   then New_Smo_Flag=lag(Smo_Flag); Ploicy_NO Cust_iD Smo_Flag   Cust_ID_lag  Policy_lag   New_Smo_Flag 1011 36543 Y     .         .     Y 1011 36543 N 36542 1011 Y 1011 45654 N 36543 1011 N 2011 77567 Y 45654 1011 Y 2011 77567 N 77567 2011 Y   Please need the code for this urgently. asap. Drop comments if need more information ... View more

if my data looks like this    cust_id        flag 101               N 101               Y 101               N 101               N 102               N    102               Y 102               N   i need my output as below   cust_id        flag 101               N 101               Y 101               Y 101               Y 102               N    102               Y 102               Y   Please help me on this asap.   Thanks in advance.   ... View more