Hi,   I simply would like to set a new Var "Counter" thats count to 12 (in the example below to 3) by the ID. I mean within the same ID, it can be hundred of them, I would like to count the rows by 12 (equivalent to months), each time gets to 12 then reset to 1 again until 12, to the end of the rows until ID changes. So this counter repeat itself in the same way for each new ID. I imagine is simply, my problem is I am only learning!!! Thank you a lot for your help. Bernardita   ID Counter A 1 A 2 A 3 A 1 A 2 A 3 A 1 A 2 A 3 A 1 B 1 B 2 B 3 B 1 B 2 B 3 B 1 B 2 B 3 B 1 B 2 C 1 C 2 C 3 C 1 C 2 C 3 C 1 C 2 C 3 C 1 C 2 ... View more

Hello Community,   I have been trying for ages to set up a small code to do the following:   ID MyValue Rate_1 Rate_2 Result_1 Want_1 Want_2 A 203,000 0.84 0.989 0.83076 0.8308 168,644 A 203,000 1 0.989 0.989 0.8216 166,789 A 203,000 1 0.989 0.989 0.8126 164,955 A 203,000 1 0.989 0.989 0.8036 163,140 B 203,000 0.82 0.9 0.738 0.5931 120,397 B 203,000 1 0.9 0.9 0.5338 108,358 B 203,000 1 0.9 0.9 0.4804 97,522 B 203,000 1 0.9 0.9 0.4324 87,770 C 203,000 0.77 0.989 0.76153 0.3293 66,839 C 203,000 1 0.989 0.989 0.3256 66,104 C 203,000 1 0.989 0.989 0.3221 65,377 C 203,000 1 0.989 0.989 0.3185 64,658   My big file  has values like in Column ID, MyValue, Rate_1, Rate_2. I need to obtain the colums Want_1 & Want_2; which is: Result_1 = Rate_1 * Rate_2 (easy to do),   (Want_1,Row_1) = (Result_1,Row_1) (Want_1,Row_2) =(Want_1,Row_1) * (Result_1,Row_2) (Want_1,Row_3) =(Want_1,Row_2) * (Result_1,Row_3) and so on...   Indeed is the Calculation of Want_1, which is a consecutive multiplaction of current row of Result_1 with previous row value outcome of Want_1. Want_2 is simple the multiplication of Want_1 with MyValue, row by row. I know it can be done totally different a code, but this is way i can interpreate to exaplina my problem.   I iwll be so greatfull if someone help me to set up a code in SAS, which I need to apply to a large set of data. Thank you very much   Bernardita       ... View more

Hello, Please can some one help me to sort out my problem. I would like to Convert a Matrix Data into simply one Column. I have attched an excel example to ilustrate better. Thank you a lot. Bernardita ... View more