Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Richard Goldstein <richgold@ix.netcom.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: generating number list depending on another variable |
Date | Wed, 19 Mar 2014 11:03:45 -0400 |
you should not be using -egen- at all as far as I can see you have now contradicted yourself (is variable 1 numeric or string?) so maybe someone else can help you Rich On 3/19/14, 10:58 AM, Patricia Biedermann wrote: > Hello, > -decode seems not to work with string variables. So I used encode. > - When I generate variable2 with egen variable2=fill(1(1)100) I get > this result: > > Variable 1 Variable 2 > AL 1 > AL 2 > AL 3 > BS 4 > BS 5 > BS 6 > BS 7 > BS 8 > SF 9 > SF 10 > ZG 11 > etc etc. > > On Wed, Mar 19, 2014 at 3:52 PM, Richard Goldstein > <richgold@ix.netcom.com> wrote: >> then -decode- it is one option >> >> however, if it is already numeric doesn't it already meet what you want? >> if not, what is wrong with it? >> >> Rich >> >> On 3/19/14, 10:49 AM, Patricia Biedermann wrote: >>> Hi Richard, >>> Thanks for your reply. Variable 1 is already encoded....it's a long >>> variable now. >>> Pati >>> >>> >>> On Wed, Mar 19, 2014 at 3:43 PM, Richard Goldstein >>> <richgold@ix.netcom.com> wrote: >>>> it looks like variable 1 is a string variable so you want the -encode- >>>> command; when you read the help file, pay attention to the "label" option >>>> >>>> Rich >>>> >>>> On 3/19/14, 10:34 AM, Patricia Biedermann wrote: >>>>> Dear all, >>>>> >>>>> Following problem: >>>>> I have variable1 with different values (AL, BS, SF, ZK...etc.) and >>>>> want to create another variable with a list of numbers reaching from >>>>> e.g. 1-100; >>>>> For each value in variable1 there should be the same number in >>>>> variable2; it should look like that in the end: >>>>> >>>>> Variable 1 Variable 2 >>>>> AL 1 >>>>> AL 1 >>>>> AL 1 >>>>> BS 2 >>>>> BS 2 >>>>> BS 2 >>>>> BS 2 >>>>> BS 2 >>>>> SF 3 >>>>> SF 3 >>>>> ZG 4 >>>>> etc etc. >>>>> >>>>> I tried to use egen variable2=fill(1(1)100) also in combination with >>>>> foreach; somehow generates values from 1-100 independently from >>>>> Variable 1 >>>>> >>>>> Thank you! * * 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/