Hi,

I got a really easy exercise actually.

I want to calculate with the NEXT Value

TABLE FILE CAR
PRINT
BODY
COMPUTE LASTBODY/A20 = LAST BODY;
END

LAST Works great, NEXT doesn't.

In the end I want to calculate
COMPUTE LOG/D12.9 = LOG(VALUE1)/LOG(NEXT VALUE1)

Hopefully someone can help.
Thanks!!

This message has been edited. Last edited by: FP Mod Chuck,

NEXT value is not something available because the "next" value does not exist in the matrix (not yet read) so it cannot be referenced when the LAST (previous one) does.
So you need to take it the other way.

Can it not be : COMPUTE LOG/D12.9 = LOG(LAST VALUE1)/LOG(VALUE1);

Not knowing your data structure and the objective of using a "NEXT" value is difficult to provide you with a proper solution.

jenni, I know your example does not have a BY phrase, but when using LAST, this implies a specific sort order, so, have you tried reversing the sort? For example if you data is sorted by date, sort by highest date instead. When sorted this way, by definition, the most recent record does not have a next value, but now the "Next" value for row 2 is the "LAST" value.

LAST ... NEXT... It all depends on your point of view: BY...
          Good one John!