Displaying 1 result from an estimated 1 matches for "tripendtaz".
2012 Apr 03
1
Compare by row and insert previous row value (Or non Time Series Lag)
I have the following sample dataset (CSV input here:http://goo.gl/YR8LP.
CSV output here: http://goo.gl/EFCC8) which I want to transform as follows.
For each person in a household I want to create two new variables OrigTAZ
and DestTAZ. It should take the value in TripendTAZ and put that in
DestTAZ. For OrigTAZ it should put value of TripendTAZ from the previous
row. For the first trip of every person in a household (Tripid = 1) the
OrigTAZ = hometaz. For each person in a household, from the second trip
OrigTAZ = TripendTAZ_(n-1) (the value of TripendTAZ from the previ...