I first summarize the analysis of some papers that I want to imitate. The regression looks like:
Y2(subjects) = Y2(friends) + Y1(subjects) + Y1(friends) + Z(subjects)
subjects refers to focal people and
friends refers to those subjects connect to. Some one may be a subject in a relationship and a friend in another. For this question, just skip the validity of this model.
The idea is to use the outcome variable of friends at time 2,
Y2(friends), to explain outcome variable of subjects at that time (
Y2(subjects)), controlling for outcomes of both subjects and friends at time 1. Other covariates of subjects may be included, but it's not the main consideration.
Following this model, I think the data should be in the wide format, which looks like:
SubjID FrID Y1Subj Y1Fr Y2Subj Y2Fr Z
The authors apply the generalized estimating equation in their analysis. However, I don't know how to perform GEE with the wide data format (let's say
PROC GENMOD in
SAS), if that's the case. Can you tell if I'm missing some thing (e.g., reconstruction of data in some way so that GEE can be used)?