I have a travel dataset as follows: travelerid  orig   dest    traveltime   time_spent_at_dest   orig_stop  dest_stop 1              A      B            5                      0                              Y            N 1              B      C            2                      2                              N            N          1              C      D            3                      1                              N             Y 1              D       E            2                      1                             Y              Y ...........   And I want to sum up the time spent between any two consecutive stopping stations (not counting the time spent at the current stopping station), for example, the output dataset should look like: travlerid  orig   dest    traveltime   1              A      D            12             1              D       E            2                      ...........   Can anyone help me with this question? Thanks! ... View more

Hi,   I have dataset as follows: Group Value a          1 a          2 a          3 b          1 b          2 b          3 ....   Is there a way to add group id to the dataset like follows: Group Value  group_id a          1         1 a          2         1 a          3         1 b          1         2 b          2         2 b          3         2 ....   I can use proc sql and join to do this, but is there any other simpler way?       ... View more