hi sorry for delay was stuck with other project. PFA the log file for one execution. Moreover I want to clarify something in actual data in place of Tier A, Tier B and Tier C its Tier 1, Tier 2 and Control and the threshold week 50 is coded as week=1968. I have edited the distorted CSV file after the code execution...I found a issue that as per the code which you have given: below logicis working well: if WEEK le 50 then newvar=10;
else newvar=20; But, for all observations in the next logic: if upcase(TIER)="TIER A" then newvar=newvar+1;
else if upcase(TIER)="TIER B" then newvar=newvar+2;
else newvar=newvar+3; the commad is directly moving to else statement resulting all the values of new variable as either 13 or 23 even for the place where it should be 11, 12, 21, 22
... View more