There have been several elaborate solutions to this, but a very simple one may be enough -- using an official command only.
I gather that each row and column combination (var1, var2) occurs once only.
That being so, note that
tab var1 var2 [aw=var3], matcell(matrix)
yields a matrix. But see help on -limits-.
Nick
[email protected]
Allan Joseph Medwick
I have three variables (var1, var2, var3). I would like to create a
matrix where the values of var1 are the columns (ascending), the
values of var2 are the rows (also ascending), and the values of var3
are the elements in the matrix. I know there must be a user defined
procedure out there to do this, but I haven't been able to find it.
*
* 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/