Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | anne broe <annebroe@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Fwd: how to use the label of oldvar to name newvar |
Date | Sun, 14 Apr 2013 20:07:04 +0100 |
I have tried to egen, group option with the label, and that ends up with the same problem as when I just use the encode option. My data looks like this atc "aaabbc01" "aaabcc02" "aaabbc04" "bbbcdd01" etc (40 different total) When I use encode atc, gen(n_atc) it becomes n_atc 1 with value label "aaabbc01" 2 with value label "aaabcc02" 3 with value label "aaabbc04" etc Then I have used gen atc_`xx' = 1 if n_atc==`xx' //xx being the values of n_atc (1-40) But instead of atc_xx I would like my 40 new variables to be named after the original string values e.g. the first var will then be named "aaabbc01" hope you can help me :) 2013/4/14 Nick Cox <njcoxstata@gmail.com>: > Alternatively, you may just be missing out on -egen, group()- with the > -label()- option. > Nick > njcoxstata@gmail.com > > > On 14 April 2013 14:34, Nick Cox <njcoxstata@gmail.com> wrote: >> When you say "the label" are you referring to value labels or variable labels? >> >> Can you give an equivalent example with a dataset we can all access e.g. >> >> sysuse auto >> Nick >> njcoxstata@gmail.com >> >> >> On 14 April 2013 14:29, anne broe <annebroe@gmail.com> wrote: >>> Dear all >>> >>> I am encoding a string var atc to a numeric var n_atc to enable the >>> use of forvalues. >>> In each loop i generate a newvar called atc_`xx' if atc== `xx' and >>> collapse (sum) of this variable. >>> My problem however that instead of atc_`xx' I would like the variable >>> to be named after the original string var atc which equals the label >>> of n_atc. >>> >>> Is there anyway you can use the `xx' to identify to variable and then >>> name it after the label? >>> >>> Hope someone can help me >>> Thanks >>> Anne >>> * >>> * For searches and help try: >>> * http://www.stata.com/help.cgi?search >>> * http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/