Thank you very much for your prompt reply Hai. I greatly appreciate that. I am still trying to break your coding logic. Will get back to you if i have any questions and if that is fine with you. Thanks again. Saravanan ... View more

Hi, thank you for the reply.On the same logic, i have two more variations. I think you will be able to crack it in a minute. These are the variations. First variation is: data have; input Measure1    Measure2    Measure3    Measure4    Measure5    Measure6    Measure7    Measure8    Measure9    Total_Score    Target_Score Indicator1 Indicator2 Indicator3 Indicator4 Indicator5 Indicator6 Indicator7 Indicator9; cards; 12     15     20     25     30     35     37     40     45     259     350     .     .     1     .     .     .     .     .     . 6     9     12     25     30     32     35     37     40     226     350     .     .     .     .     1     .     .     .     . 12     15     18     20     25     26     28     30     32     206     300     .     .     .     1     .     .     .     .     .     ; run; for each of the measure there is indicator associated with it. for colum Measure the corresponding indicator is column Indicator1, for Measure2 the corresponding indicator is Indicator2. Now i have the same logic as above but with slight variation. If a particular measure has indicator attached to it, it should increment by 10 and the rest of the process is as above with other measures increasing by 1. in above data. for first record, Measure3 has Indicator3 as 1, so it shud increase by 10. In second record, measure5 has Indicator5 as 1, so it should increase by 10 with other measures increasing by 1. Variation 2: data have; input Measure1    Measure2    Measure3    Measure4    Measure5    Measure6    Measure7    Measure8    Measure9    Total_Score    Target_Score Indicator1 Indicator2 Indicator3 Indicator4 Indicator5 Indicator6 Indicator7 Indicator9 impute1 impute2 impute3 impute4 impute5 impute6 impute7 impute8 impute9; cards; 12     15     20     25     30     35     37     40     45     259     350     .     .     1     .     .     .     .     .     .     .     1     .     .     .     .     .     .     . 6     9     12     25     30     32     35     37     40     226     350     .     .     .     .     1     .     .     .     .     .     .     .     .     1     .     .     .     . 12     15     18     20     25     26     28     30     32     206     300     .     .     .     1     .     .     .     .     .     .     .     .     .     1     .     .     .     .   ; run; This is addition to above requirement. This has colums Impute1-Impute9 with it. Each of the Impute1-Impute9 is associated with Measure1-Measure9. If impute column is 1, then the particular measure should not increase. for example, in above record. Mesure3 has Indicator3 as 1, so it should increase by 10, Measure2 has Impute2 as 1, so it should not increase, but other measures should increase as before logic by 1. for second record, Measure5 has Indicator5 as 1 and Impute5 as 1, so impute5 takes precedence and it should not increase. The concept is whereever there is Indicator column has 1 the corresponding measure should increase by 10. Whereever there is Impute column has 1 the corresponding measure should not increase. Whereever the Impute Indicator column and Impute column is 1, the corresponding measure should not change. All other measure increases by 1 as above logic. Hope you can help me out. Thanks, Saravanan ... View more

Looks like this what exactly i want. Thank you very much. Anyway i will test it tomorrow in real data and let you know. Thanks a lot. Saravanan ... View more

Thank you for your reply. let me show it with what should happen in a record. for example, the record reads as below, Measure1    Measure2    Measure3    Measure4    Measure5    Measure6    Measure7    Measure8    Measure9    Total_Score    Target_Score 1    2    3    4    5    6    7    8    9    45    55 This is what should happen in step by step process, 1     2     3     4     5     6     7     8     9     45     55 2     2     3     4     5     6     7     8     9     46     55 3     2     3     4     5     6     7     8     9     47     55 3     3     3     4     5     6     7     8     9     48     55 4     3     3     4     5     6     7     8     9     49     55 4     4     3     4     5     6     7     8     9     50     55 4     4     4     4     5     6     7     8     9     51     55 5     4     4     4     5     6     7     8     9     52     55 5     5     4     4     5     6     7     8     9     53     55 5     5     5     4     5     6     7     8     9     54     55 5     5     5     5     5     6     7     8     9     55     55 now the total score(55) equals target score(55) so it should exit loop. Above is the simulation of one record. Hope this helps. Thanks, Saravanan ... View more

Hi Hai, Thanks for your reply. But i`m not looking for this. I`m looking for; first measure1 should increase by 1 until it equals measure2. If total score reaches target score before measure1 equals measure2 then it should exit loop. if total score is not equal to target score even after measure1 equals measure2 then, measure1 and measure2, both should increase one after another until both measure1 and measure2 equals measure3. if total score equals target score before either measure1 or measure2 reaches measure3 then exit loop. if total score is not equal to target score even after both measure1 and measure2 equals measure3, then measure1, measure2, measure3, all these three should increase one after another until it equals measure4. if total score equals target score before either of measure1 or measure2 or measure3 reaches measure4 then exit loop. like wise it should continue till measure9 if total score not equals target score. Hope i said it clearly this time. Thanks, Saravanan ... View more

Thank you Arthur. Much appreciated. I hope SAS comes up with functionality to create new variables during proc import. ... View more