BookmarkSubscribeRSS Feed
viollete
Calcite | Level 5

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

1 REPLY 1
data_null__
Jade | Level 19
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;

    sas-innovate-2024.png

    Available on demand!

    Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

     

    Register now!

    How to Concatenate Values

    Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

    Find more tutorials on the SAS Users YouTube channel.

    Click image to register for webinarClick image to register for webinar

    Classroom Training Available!

    Select SAS Training centers are offering in-person courses. View upcoming courses for:

    View all other training opportunities.

    Discussion stats
    • 1 reply
    • 303 views
    • 0 likes
    • 2 in conversation