when we transpose have data set  and we do combine lookup and have DS but it is not possible based on only id variable as you said many to many .. are there any other variables possible.. i merged it using merge statement.. check the whole code i written till now.. data have;                                                                                                                                          input ID (IN1 OUT1 IN2 OUT2 IN3 OUT3) (datetime16.);                                                                                                Format IN1 OUT1 IN2 OUT2 IN3 OUT3 datetime16.;                                                                                                      datalines;                                                                                                                                          101 06AUG2013:13:55 06AUG2013:17:14 16AUG2013:17:02 17AUG2013:07:00 29AUG2013:12:28    .                                                        102 14AUG2013:11:40 27AUG2013:12:03                                                                                                                 ;                                                                                                                                                                                                                                                                                                       data lookup;                                                                                                                                        input ID DEPT$ (IN OUT) (datetime16.);                                                                                                              format in out datetime16.;                                                                                                                          datalines;                                                                                                                                          101 SO  06AUG13:06:51  06AUG13:14:02                                                                                                                101 SC  06AUG13:14:02  09AUG13:19:18                                                                                                                101 ST  09AUG13:19:18  12AUG13:03:14                                                                                                                101 SM  12AUG13:03:14  13AUG13:12:17                                                                                                                101 ST  13AUG13:12:17  16AUG13:16:54                                                                                                                101 SC  16AUG13:16:54  19AUG13:11:04                                                                                                                101 PN  19AUG13:11:04  22AUG13:07:37                                                                                                                101 PE  22AUG13:07:37  09SEP13:15:20                                                                                                                102 SM  14AUG13:12:08  28AUG13:13:48                                                                                                                ;                                                                                                                                                                                                                                                                                                       data have_trans(drop=i IN1 OUT1 IN2 OUT2 IN3 OUT3);                                                                                                 array in {3} in1 in2 in3;                                                                                                                           array out {3} out1 out2 out3;                                                                                                                       do until (last.id);                                                                                                                                 set have;                                                                                                                                           by id notsorted;                                                                                                                                    format in_ out_ datetime16.;                                                                                                                        do i = 1 to 3;                                                                                                                                         In_=in(i);                                                                                                                                          out_=out(i);                                                                                                                                     output;                                                                                                                                             end;                                                                                                                                                end;                                                                                                                                                run;                                                                                                                                                                                                                                                                                                    data both;                                                                                                                                          merge have_trans lookup;                                                                                                                            by id ;                                                                                                                                             run; i think merge like this is wrong but i done for checking. ... View more

Hi Robertrao, data have_trans(drop=i IN1 OUT1 IN2 OUT2 IN3 OUT3);                                                                                                 array in {3} in1 in2 in3;                                                                                                                           array out {3} out1 out2 out3;                                                                                                                       do until (last.id);                                                                                                                                 set have;                                                                                                                                           by id notsorted;                                                                                                                                    format in_ out_ datetime16.;                                                                                                                        do i = 1 to 3;                                                                                                                                         In_=in(i);                                                                                                                                          out_=out(i);                                                                                                                                     output;                                                                                                                                             end;                                                                                                                                                end;                                                                                                                                                run; this step might help you to get have dataset as lookup dataset. ... View more

Hi Robertrao, In which format have data is present ? If it is excel use data step to import it and double transpose it.. If it is in notepad you can use double trailing method of input to get the data into a single column or variable .. Please give the format of Have data.. based on i can help to write the code for it.. -- Durga ... View more