maybe the way it comes over the list is not obvious but please have a look here:
http://www.hsph.harvard.edu/cgi-bin/lwgate/STATALIST/archives/statalist.0902/date/article-950.html
a, id1 > ad1, id1
a, id1 > ad2, id1
a, id1 > ad3, id1
a, id2 > ad3, id2
a, id2 > ad4, id2
etc...
the same principle w/ b
> <>
>
> Well, tell the list how this second matrix comes into being. How does it
> follow from the first one?
>
> HTH
> Martin
> _______________________
> ----- Original Message -----
> From: "John Bunge" <[email protected]>
> To: <[email protected]>
> Sent: Saturday, February 21, 2009 4:17 AM
> Subject: st: dummy table - follow up
>
>
> > Dear all,
> >
> >
> > now i would like to modify
> >
> > id a b d1 d2 d3 d4
> > 1 1 3 1 0 0 0
> > 1 2 15 0 1 0 0
> > 1 2 40 0 0 1 0
> > 2 1 35 0 0 1 0
> > 2 2 120 0 0 0 1
> > 3 3 10 0 1 0 0
> > 3 1 55 0 0 1 0
> > 3 1 130 0 0 0 1
> > 4 4 2 1 0 0 0
> > 4 1 38 0 0 1 0
> >
> >
> > to
> >
> > id d1x d2x d3x d4x ad1 ad2 ad3 ad4 bd1 bd2 bd3 bd4
> > 1 1 1 1 0 1 2 3 . 3 15 40 .
> > 2 0 0 1 1 . . 1 2 . . 35 120
> > 3 0 1 1 1 . 3 1 1 . 10 55 130
> > 4 1 0 1 0 4 . 1 . 2 . 38 .
> >
> >
> > Thanks to some comments over this list I know how to create d1x - d4x. The
> > additional stuff I am not sure how to do is ad1 - bd4.
> >
> >
> >
> >
> > ____________________________________________________________________
> > Psssst! Schon vom neuen WEB.DE MultiMessenger gehört?
> > Der kann`s mit allen: http://www.produkte.web.de/messenger/?did=3123
> >
> >
> > *
> > * 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/
>
____________________________________________________________________
Psssst! Schon vom neuen WEB.DE MultiMessenger gehört?
Der kann`s mit allen: http://www.produkte.web.de/messenger/?did=3123
*
* 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/