Changing dataset

Reply
Contributor
Posts: 60

Changing dataset

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

Respected Advisor
Posts: 3,775

Re: Changing dataset

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;
    Ask a Question
    Discussion stats
    • 1 reply
    • 113 views
    • 0 likes
    • 2 in conversation