Hello all, trying to resolve an issue with a simple data wizard manipulation and wondering if I could get some feedback.
Basically I am trying to perform the following operation: For all times points corresponding with each subject involved in the study, I would like to replace the concentration values where time is not equal to 0 with the corresponding time point that is associated with time=0 for the same subject.
I've tried using an If + substitute statement, but I'm not sure how to substitute the value with a new one which corresponds to a different value in another cell, especially when it changes for every subject.
Is there any way to have a custom transformation which would perform this operation?
Thanks in advance,
Joseph