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

I am using an array to create a variable I need - variable A. When I do this, I need to keep certain variables B C D E F G, so I can have them in my final data file. All of these are character vars except G (numeric var) However, when I create this file with the array - these extra variables are repeating to fill in blanks - Since new variable A repeats for each ID. The missing in this file are okay. All I need is for the data from these extra variables to be in the first  row of the ID, not all of them. Could I add something to the array to make this happen? Or is there any other way I can do this after the data want is created? Thank you. Data want (keep= ID A B C D E F G); set have; array _pres {*} pres: ; do A=1 to dim(_pres); if _pres{A}>0 then output; end; run; What I am getting:   ID A         B             C          D                  E                  F            G 1  2    descript1       .           descript3      descript4          .          1 1  9    descript1        .          descript3      descript4          .          1 1  12  descript1       .           descript3      descript4         .           1 2  10    .                descript2     .             descript4    descript5    . 2   5    .                 descript2     .             descritp4    descript5    . 3   11  .                      .              descript3      .             .               . 3   20 .                      .              descript3      .             .                . 3   33 .                      .               descript3     .            .                 .   what I need:   ID A         B             C          D                  E                     F                 G 1  2    descript1       .           descript3      descript4          .                   1 1  9    .                    .                      .             .                    .                   . 1  12 .                      .                    .              .                    .                    . 2  10     .                descript2        .             descript4    descript5          . 2   5     .                      .                     .             .                         .            . 3   11   .                      .              descript3      .             .               .         . 3   20   .                   .                    .                .              .             .          . 3   33   .                    .                    .               .             .              .          .     ... View more

I am using a double transpose (main data file A)  to create two date variables. However, I have a lot of missing dates, as they are only given if the actual variable that is linked to the dates was entered. Main data file was sorted ahead of time using the same variables in the by statements below. The two dates are not correlated.  Here is my code. What am I doing wrong that the call missing is not working? Thank you. proc transpose data=A out=out1; var pdte1 - pdte53;   by ID a b c; proc transpose data=A out=out2; var date1 - date73;   by ID a b c ; Run; Data want; merge out1(Rename = (COL1 = Pdate)) ** how do I keep only the non missing dates? out2 (Rename = (COL1 = Ddate)) ; ** how do I keep only the non missing dates? *by ID a b c ; output; call missing(of _All_);  * this is not working and it is a problem; Run;   What I am getting (each ID ends up with 73 entries): ID     Pdate           Ddate       1    .                           .                               1   1/1/2001                .                            1   .                    2/2/2002 2   10/11/2011         9/11/2005 2    .                              . 3    .                              . 3   .                               . 3  5/5/2003                 6/6/2009 4      .                                . 5      .                        5/7/2006 5      .                               . 5   6/62003                     .   I needed the file to look like this: ID         Pdate                        Ddate         1    1/1/2001                  2/2/2002                         2    10/11/2011             9/11/2005 3    5/5/2003                   6/6/2009 5     6/62003                    5/7/2006 ... View more

I have 60 variables (selected = 1, not selected = 0 VAR1 to VAR60) that I wanted to collapse into one variable with 60 keys (MAINVAR). However, each one of my ids, could have more than 1 selected. If I did a simple if then, it overwrites. What is the most effective way of doing this? It would then become a stacked file. Each id that has more than one variable selected would have multiple entries. To make it a little bit more complex, for each selected there is a corresponding date var and also corresponding timing variable (past present selected not selected). However, I could do the same thing for the timing and the date variables, once I know how to do this (I think). Example of what the datafile looks like now (leaving dates and timing out): ID   VAR1 VAR2 VAR3 VAR4 VAR5 VAR6   etc… A     1          0         1         1         0        0 B     0          1         0         0         0        0 C     1          1         1         1         0        0 D     0          0         0         1          1       1   Example of how it would be from the example above:   ID  MAINVAR (keys 1-60) A      1 A      3 A      4 B      2 C      1 C      2 C      3 C      4 D      4 D      5 D      6   Thank you! ... View more