st: from value to varnames

[Richard Goldstein <richgold@ix.netcom.com>]

Hi,

I have a data set with 3 variables: field, cat, order; there are 258 
observations

I want the 258 observations in field to be 258 variables where the name 
of the value in field becomes the new variable name; I want to keep the 
associated values of the other two fields

For example, say that the first observation has the following values:

field		cat 	order
namea		A	1

I want a new set of variables such that I have a variable called "namea" 
and I still have cat (of "A") and order (of "1") -- but remember that I 
should now have 258 variables--cat and order can be joined as the value 
for each variable; thus, for the example above, the first variable 
(namea) would now have the value "A1"

I hope that this is sufficiently clear (note that there is no pattern in 
the values of field (the new varnames)

thanks,

Rich
*
*   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/