I am creating variables using variable X with a few if then statements. My purpose with this is to have variables A B C D instead of A1 A2 A3 etc  B1 B2 B3  etc. and while this works beautifully, I am losing data for the first record of each ID. I am not sure how to prevent this from happening. if X = 1 then do; A= oldA1; B = oldB1; C = oldC1; D = oldD1; end;  else if X = 2 then do; A= oldA2; B = oldB2; C = oldC2; D = oldD2; end; else if X = 3 then do; A= oldA3; B = oldB3; C = oldC3; D = oldD3; end;   this goes to 17. I am using only 3 to make the example easy.  First record is not necessarily X = 1 it can be any key. I could do this with proc transpose but I have a few groups of variables and when I tried with proc transpose it made it worse.  How to tell sas to not drop the first record? I can’t seem to find what that is. Example of the raw data I have:   ID    X   oldA1 oldB1 oldC1 oldD1     oldA2 oldB2 oldC2 oldD2           oldA3 oldB3 oldC3 oldD3 1     2        .         .         .          .          date        0          1       0 1     3      .           .         .          .             .            .          .         .            date           1      1         1 1     1      date     0        1         1            .            .          .        .                    .            .        .          . 1     3       .             .        .            .           .             .           .         .         date           0     0          0 2     3       .             .         .          .            .              .         .        .           date            0      0        1 2     1     date     1         1         1           .               .         .        .                 .               .       .         .   I needed:   ID   X         A           B   C  D 1       2    date         0    1  0 1       3    date         1   1    1 1       1    date         0   1    1 1       3     date       0    0   0 2       3    date        0     0    1 2        1    date       1    1    1 I am getting instead ID   X         A           B   C  D 1       3     date        1   1    1 1       1     date        0   1    1 1       3     date        0    0   0 2       1     date        1    1    1   Thanks!     ... View more

I need to make the keys from var  B   become the continuation of var  A    The original var  A   has  values from 1-22 and once I rename B into A  it would go up to 51 (as you can see in the code below).   My code works except it looks like I am losing only the first prep var so I might need only one statement somewhere to prevent it from dropping that first one?  Please see the data example after the code.   Data want; set have; if B   = 1 then prepvar = 23 ; else if B   = 2 then prepvar = 24 ; else if B   = 3 then prepvar = 25 ; else if B   = 4 then prepvar = 26 ; else if B   = 5 then prepvar = 27 ; else if B   = 6 then prepvar = 28 ; else if B   = 7 then prepvar = 29 ; else if B   = 8 then prepvar = 30 ; else if B   = 9 then prepvar = 31 ; else if B   = 10 then prepvar = 32 ; else if B   = 11 then prepvar = 33 ; else if B   = 12 then prepvar = 34 ; else if B   = 13 then prepvar = 35 ; else if B   = 14 then prepvar = 36 ; else if B   = 15 then prepvar = 37 ; else if B   = 16 then prepvar = 38 ; else if B   = 17 then prepvar = 39 ; else if B   = 18 then prepvar = 40 ; else if B   = 19 then prepvar = 41 ; else if B   = 20 then prepvar = 42 ; else if B   = 21 then prepvar = 43 ; else if B   = 22 then prepvar = 44 ; else if B   = 23 then prepvar = 45 ; else if B   = 24 then prepvar = 46 ; else if B   = 25 then prepvar = 47 ; else if B   = 26 then prepvar = 48 ; else if B   = 27 then prepvar = 49 ; else if B   = 28 then prepvar = 50 ; else if B   = 29 then prepvar = 51 ; if 1<=A<=22 then A = A;  *keeping the var as is for the original data that has values that go from 1-2; else A= prepvar;  * adding the new values from var B; Run;   Example of what I am getting. it looks like it is dropping the first prepvar value only. I am not sure why and how to prevent this from  happening. ID                            VAR A               VAR B   prepvar   Thanks, ... View more