[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
AW: st: from value to varnames |

Date |
Tue, 19 May 2009 08:55:05 +0200 |

<> What is the difference btw your dataset and the one I made up on the fly? Because with mine, Phil`s solution leads to the correct result: ************* clear* input str10 field str5 cat order namea A 1 nameb B 2 namec F 5 named T 12 end compress list, noobs qui{ gen value = cat + string(order) keep field value sxpose, clear force firstnames } l, noo ************* HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Richard Goldstein Gesendet: Dienstag, 19. Mai 2009 03:19 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: from value to varnames nope -- Nick's -sxpose- gives me variables with varnames _var1, etc -- which is of no use; sorry for not mentioning that I had already tried it Rich Phil Schumm wrote: > On May 18, 2009, at 3:40 PM, Richard Goldstein wrote: >> 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" > > > If you're interested in an off-the-shelf routine, then Nick's -sxpose- > will do the trick: > > gen value = cat + string(order) > keep field value > sxpose, clear force firstnames > > -- Phil * * 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/

**References**:**st: from value to varnames***From:*Richard Goldstein <richgold@ix.netcom.com>

**Re: st: from value to varnames***From:*Phil Schumm <pschumm@uchicago.edu>

**Re: st: from value to varnames***From:*Richard Goldstein <richgold@ix.netcom.com>

- Prev by Date:
**Re: st: how to remove symbles or some part from a string?** - Next by Date:
**st: AW: F-statistic using Newey** - Previous by thread:
**Re: st: from value to varnames** - Next by thread:
**Re: st: from value to varnames** - Index(es):

© Copyright 1996–2014 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |