Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Data Analytics Corp." <walt@dataanalyticscorp.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: AW: st: string variable question |
Date | Mon, 29 Mar 2010 11:00:31 -0400 |
Thanks for all the help. Walt Eric Booth wrote:
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 questionUse -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 26elements. I want to create a third variable, brand, as part of a do program that has 26 brand names. I triedgen 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/
-- ________________________ 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/