@SaSoDude wrote:
@Tom May I ask you, what this is about?
order=id-3+0.5;
The dataset two will be ordered by the id - but why did you add the calculation behind it?
Because I was too lazy to type in the ORDER values myself. So I just wrote a formula that could make some ORDER values worked by using the values of ID that you had already typed. Since you wanted 5 to follow 2 I subtracted 3 and then added a half. The goal was just to make a variable that would work to insure the values from TWO were inserted where wanted them.
Note I could have not added the 0.5 and it still would have worked. The SET statement will process the datasets in the order they appear. So the ORDER=2 observations from ONE would be processed before the ORDER=2 observations from TWO .
... View more