I have a problem that my feable datastep-skills simply can't seem to overcome. I have data that looks like: Iden     change1     change2     change3     change4     change5     ....     change44 1               a                x               x               z 2               a                x               x               x               x                         x 3               b                x               x 4               c                x               x               y 5               d                z               z               z               x                         x  6                                 a               x               x               x                                  . . 1786 What i would like to do, is to identify all the IDEN's that have "a" or "b" in change1, and then "z", "y" or "empty" three weeks later. That is in change4. In the above example, that would pull out IDEN 1,3,4 and 5. Then calculate the percentage of the ones who had either "a" or "b" in change1, and then "z", "y" or "empty" three weeks later, out of everyone who had "a" or "b" in change1. Exactly this, is what i would like to do in change1-change44. So the of the IDEN's in change2, who has "a" or "b", has "z", "y" or "empty" in change5. And that i would like to do all the way to change40. I hope that it's understandable.. /T ... View more

Hi, i have a problem that i can't seem to solve with the level of datasteppin' im at. My data looks like this: Iden     Var1     Constant     Count 1          a             x               1          1          a             x               2            1          b                              3 1          c             z               4 1          b                              5   2          a             x               1 2                                          2 3                                          1 3          b             y                2 3          b             y                3 3          a             x                4 then i use arrays to make it look like this: Iden     Var1_1     Var1_2     Var1_3     Var1_4     Var1_5     Constant 1               a              a              b            c              b               2               a                                                                          x 3                               b              b            a                             x Now my problem is that my constant variable is sometimes present, and sometimes it's empty I would like it to look like this: Iden     Var1     Constant     Count 1          a             x               1          1          a             x               2            1          b             x                3 1          c             z               4 1          b             z                5   2          a             x               1 2                         x                 2 3                                          1 3          b             y                2 3          b             y                3 3          a             x                4 In other words, when constant is empty, SAS takes the lateest value. But without overwriteing it, if the next Var1 has a Constant value. Is this understandable? Hope you can help! -------------------------------------------- Arrays code: data rotate; set c; by ship_to_party; retain numabb1-numabb42; array Anumabb(1:42) numabb1-numabb42; if first.ship_to_party then do; do i = 1 to 42;           Anumabb = .; end; end; Anumabb(week) = numabb; if last.ship_to_party then output; drop i; run;quit; data rotate_1; set rotate; array Anumabb(42) numabb1-numabb42; do i = 1 to 42; if Anumabb = ' ' then Anumabb = 0; end; drop i; run;quit; ... View more

Hi. I have a question that my knowledge of datasteps and arrays can't really handle. I have some data of the form: Iden     Var1     Var2     Var3     Var4 1            x          y          2                              3                                    y 4                         x          z What i hope to make clear is that i have different variables, named anumabb2 to anumabb34, that contain non-numeric text. What i wan't to delete is the row with iden 2, because all that exact one has all empty variable slots. I hope it makes sense, and i'm thinking it has a simple solution that im too high on coffee to find for myself! Thanks TM ... View more