I have a data set containing many participants. Each participant has multiple events. For each participant and each event, I want a list of the variable value. This might be best described by demonstration: For example, PID EVENT VAR 1392 1 . 1392 1 13 1392 2 12 1392 2 12 2456 1 3 2456 1 . 2456 2 . 2456 2 . I want to end up with a list like this: PID EVENT VAR 1392 1 13 1392 2 12 2456 1 3 2456 2 . Is there a particular method for doing this? Participants have more than one EVENT. And within each EVENT, VAR is the same (but some observations are .) In some cases, VAR is . for the entire event. In other cases, VAR is . for only a few cases within an EVENT.
... View more