Changing dataset

[viollete]

Hello,

I have data about mother and her newborns (twins or triples)

Data is like this:

Data      ID      birth_weight1 birth_weight2 birth_weight3 Birth_status1 birth_status2 birth_status3   gest

0607       1         3000                2500                                    1                      1                             39

0708       2         1900                1600               700                 1                      1              2              37

And I want to get this:

Data      ID      birth_weight1 birth_weight2 birth_weight3 Birth_status1 birth_status2 birth_status3   gest

0607       1         3000                                                         1                                                       39

0607       1         2500                                                          1                                                      39

0708       2         1900                                                          1                                                      37

0708       2         1600                                                          1                                                      37

0708       2         700                                                            2                                                      37

[data_null__]

data multibirth;
   input Data :$4 ID  birth_weight1-birth_weight3 Birth_status1-birth_status3  gest;
   cards;
0607 1  3000  2500    .   1   1  .  39
0708 2  1900  1600  700   1   1  2  37
;;;;
   run;
data multibirth2(keep=data id gest n weight status);
   set multibirth;
   array w

Birth_weight:;

   array s

Birth_status:;

   n = n(of w

);
  

do i = 1 to n;
      weight = w;
      status = s;
      output;
      end;
   run;