Changing dataset

viollete — Wed, 13 Aug 2014 10:17:12 GMT

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

Re: Changing dataset

data_null__ — Wed, 13 Aug 2014 10:31:21 GMT

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;

topic Re: Changing dataset in SAS Programming

Changing dataset

Re: Changing dataset