01-16-2017 08:01 AM - edited 01-16-2017 08:03 AM
I'm using SAS EG 5.1 on Windows 7.
I have the following sample input.
I wish to order this input in such a way that whenever different observations match on ID and on Time, the final state of a given observation matches the initial state of the next observation.
The output should look like this:
I'm at a loss on how to do this. Any help?
Here's the code that generates the input table.
Data Test; Infile datalines delimiter=','; Input ID Initial_Stafe $ Final_State $ Time; Datalines; 123,AA,BB,201701020923 123,BB,CC,201701020930 156,AA,AA,201701020910 163,AC,BC,201701031010 163,DD,CC,201701031010 163,BC,DD,201701031010 163,CC,BB,201701031010 170,BB,.,201701040930 ;
01-16-2017 09:28 AM
Assuming that state has logical (and unbreakable) path.
Also assuming that state is global, the order is the same independent of id, or...?
If so, create a lookup table with a your state and a numerical order by variable, merge/join to get this order by variable, and then resort.
01-16-2017 09:44 AM
01-16-2017 11:12 AM