Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Eric Booth <ebooth@ppri.tamu.edu> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: AW: st: string variable question |
Date | Mon, 29 Mar 2010 09:29:28 -0500 |
> Assuming you've already got this dataset in memory: ** clear inp A1 A2 1 2 2 3 3 4 5 6 end ** You could use -input- : ** inp str25 brand "Cheerios" "Wheaties" "Frosted" "other" end ** ~ Eric __ Eric A. Booth Public Policy Research Institute Texas A&M University ebooth@ppri.tamu.edu Office: +979.845.6754 On Mar 29, 2010, at 9:23 AM, Data Analytics Corp. wrote: > Hi, > > Sorry, but I'm not making myself clear. Let me try again. Here's the data: > > A1 A2 > 1.35 -2.48 > 1.50 0.56 > 0.75 -1.2 > ... > > I want to add a third variable, brand, that has nothing to do with the specific numbers for A1 and A2, but rather with the rows. So, I want > > A1 A2 brand > 1.35 -2.48 Cheerios > 1.50 0.56 Wheaties > 0.75 -1.2 Frosted > ... > > A1 and A2 come from an MDS estimation by converting the e(Y) matrix to variables. I now need to add the brands for further processing. It seems I should be able to do something like > > gen str brand = "Cheerios" "Wheaties" "Frosted" etc > > But it doesn't work, unless I just mistyped something. Hope this helps clarify what I need. I really appreciate the help. > > Thanks, > > Walt > > > Martin Weiss wrote: >> <> >> Or, in one fell swoop: >> >> ************* >> clear* >> inp A1 A2 >> 1 2 >> 2 3 >> 3 4 >> 5 6 >> end >> >> gen brand=string(A1)+string(A2) >> list >> ************* >> >> >> >> HTH >> Martin >> >> >> -----Ursprüngliche Nachricht----- >> Von: owner-statalist@hsphsun2.harvard.edu >> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Eric Booth >> Gesendet: Montag, 29. März 2010 15:38 >> An: statalist@hsphsun2.harvard.edu >> Betreff: Re: st: string variable question >> >> >> Use -tostring- to combine the numeric vars, ex: >> >> ***** >> clear >> inp A1 A2 >> 1 2 >> 2 3 >> 3 4 >> 5 6 >> end >> >> tostring A1 A2, replace >> gen brand = A1 + A2 >> ***** >> >> ~ Eric >> __ >> Eric A. Booth >> Public Policy Research Institute >> Texas A&M University >> ebooth@ppri.tamu.edu >> Office: +979.845.6754 >> >> >> >> On Mar 29, 2010, at 8:32 AM, Data Analytics Corp. wrote: >> >> >>> Hi, >>> >>> I have two numeric variables in a Stata dataset: A1 and A2. Each has 26 >>> >> elements. I want to create a third variable, brand, as part of a do program >> that has 26 brand names. I tried >> >>> gen str brand = "A" "B" and so on to "Z" >>> >>> but that didn't work. How can I create a brand variable? >>> >>> Thanks, >>> >>> Walt >>> >>> >>> >>> -- >>> ________________________ >>> >>> Walter R. Paczkowski, Ph.D. >>> Data Analytics Corp. >>> 44 Hamilton Lane >>> Plainsboro, NJ 08536 >>> ________________________ >>> (V) 609-936-8999 >>> (F) 609-936-3733 >>> walt@dataanalyticscorp.com >>> www.dataanalyticscorp.com >>> >>> * >> >> >> >> > > > -- > ________________________ > > Walter R. Paczkowski, Ph.D. > Data Analytics Corp. > 44 Hamilton Lane > Plainsboro, NJ 08536 > ________________________ > (V) 609-936-8999 > (F) 609-936-3733 > walt@dataanalyticscorp.com > www.dataanalyticscorp.com > > * > * 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/