Does this work?
reshape long sr gr, i(dyad) j(person)
bys dy: replace hr1 = hr2[_n-1] if _n >1
bys dy: replace hr2 = hr1[_n-1] if _n >1
Scott
On Mon, Feb 1, 2010 at 4:57 PM, Alan Acock <[email protected]> wrote:
> Kenney, Kashy, & Cook. Dyadic Data Analysis Has a wide dataset that looks like this:
>
> dyad hr1 hr2 sr1 sr2 gr1 gr2
> 1 1.2 .6 6 7 1 1
> 2 4.3 2.3 5 9 -1 -1
> 3 .4 .6 3 4 1 1
> 4 .3 .5 6 8 1 1
> 5 3.2 1 2 6 -1 -1
> 6 1.1 .8 3 8 1 1
> 7 2 1.5 5 7 1 1
> 8 .4 1.6 7 4 -1 -1
> 9 .3 .5 3 3 1 1
> 10 3.2 2 5 8 1 1
> 11 .8 2.1 8 5 -1 -1
> 12 2.3 2.5 5 7 -1 -1
> 13 1 2 4 6 1 1
> 14 2.5 1.5 6 7 1 1
> 15 2 .5 5 6 1 1
> 16 1.8 2.6 7 4 -1 -1
> 17 4.3 2 2 4 -1 -1
> 18 1 2 4 4 -1 -1
> 19 2.5 2.5 6 5 -1 -1
> 20 1 .5 3 4 -1 -1
>
> Where the dyads are interchangeable (same sex roomates). hr1 is time roommate arbitrarily labeled 1 works on housekeeping, hr2 is same for roommate labeled 2, sr1 is roommate's 1' satisfaction, sr2 is the partner's satisfaction, gr1 and gr2 are their genders. He wants it in a sort of long format,
>
> dyad person gr sr hr1 hr2
> 1 1 1 6 1.2 .6
> 1 2 1 7 .6 1.2
> 2 1 -1 5 4.3 2.3
> 2 2 -1 9 2.3 4.3
>
> Dyad, person, and gr and sr are in long format, but hr1 and hr2 are not. Also, in row 1 we have hr1 then hr2 as in the wide dataset, but
> in row two we have hr2 for the first person in the hr1 column and hr1 for the first person in the hr2 column.
>
> He then runs a SAS command
> proc mixed covtest;
> class dyadid;
> model sr = hr1 hr2 / solution
> ddfm=satterth;
> repeated / type = cs subject = dyadid;
>
> I can run
> reshape long sr gr, i(dyad) j(person)
> but this doesn't do the hr1 the way they need them. The results show how much a person's time (actor) doing chores influences their own satisfaction and how much a partner's time doing chores influences the actor's satisfaction.
>
> How can I reshape the data to duplicate their result.
>
> Alan Acock
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
