[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 |
RE: -merge- (?) problem (was: st: MIME-Version: 1.0) |

Date |
Tue, 30 Sep 2008 09:20:07 +0200 |

Although it is interesting to investigate these questions, the task you have in mind is more easily accomplished via -findit renvars-... HTH Martin -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ashim Kapoor Sent: Tuesday, September 30, 2008 7:58 AM To: statalist@hsphsun2.harvard.edu Subject: Re: -merge- (?) problem (was: st: MIME-Version: 1.0) Hello. Thank you for your reply. I wish to ask another ( related ) question. Suppose I have 2 local variables with the SAME no of "words". local name="One Two Three Four" local numname="one two three four" I want to do something like :- rename One one rename Two two rename Three three rename Four four. So I have 2 questions. How do I get the number of words in the local macro. And 2nd How do I access the 1/2/3/4 "word" of the macro. I have seen the word command for STRING variables, but can I do this for a local variable ? Thank you, Ashim. On Mon, Sep 29, 2008 at 9:03 PM, Eva Poen <eva.poen@gmail.com> wrote: > Ashim, > > Please try and use Stata lingo in your postings: observations (not > rows, or items) and variables (not columns). > > You can do it much easier. -help merge- will provide some good information. > > *** > use secondfile > sort symbol year > save, replace > > use firstfile > sort symbol > merge symbol using secondfile, uniqmaster > save mergefile > *** > > Now you will have ticker as a variable in you second file. Inspect the > _merge variable (see -help merge-) to make sure the outcome is what > you expected. > > Next: > *** > qui levelsof symbol, local(loop) > foreach x of local loop { > drop _all > use mergefile > keep if symbol == "`x'" > save `=ticker[1]' > } > *** > > HTH, > Eva > > 2008/9/29 Ashim Kapoor <ashimkapoor@gmail.com>: >> Hello Eva, >> >> Thank you for your time. Let me be more clear this time. >> >> In the first file I have 2 variables--> symbol and ticker. The tickers >> are file names I want to save various output files as. There is a one >> one correspondence between symbol and tickers. For example. >> >> symbol ticker >> 1. ABB abb >> 2. BHARTI bti >> 3. AIRTEL artl >> >> >> That is what the first file looks like. >> >> the second file has variables year / symbol / production / etc. >> >> It looks like >> >> symbol year production >> 1. ABB 1998 92 >> 2. ABB 1999 95 >> 3. BHARTI 1998 61 >> 4. BHARTI 1999 70 >> 5. AIRTEL 2000 80 >> 6. AIRTEL 2001 81 >> >> Now I want to save items 1 and 2. ie. items with symbol = ABB in a >> file named "abb.dta" >> I want to saves items 3 & 4 ie. items with symbol= BHARTI in a file >> named "bti.dta" >> and items with symbol = "AIRTEL" in a file named "artl.dta". >> >> So I guess this would be a 2 step procedure. >> >> Step 1 : store all symbols in ONE local macro and store all tickers in >> the 2nd local macro. >> >> Step 2 : Loop through the 2 equal sized loops, do a keep if symbol == >> ...... and save as the corresponding ticker . >> >> Can u tell me how to do this in stata ? >> >> Thank you, >> Ashim. >> >> On Mon, Sep 29, 2008 at 4:38 PM, Eva Poen <eva.poen@gmail.com> wrote: >>> Ashim, >>> >>> I'm sorry but I don't get it. You have two variables in your first >>> file, called symbol and ticker. What are they? Numeric, string? In >>> your second file you have symbol again (what about ticker?), and many >>> more variables, and you also have more observations (symbol does no >>> longer uniquely identify observations). >>> >>> Now you want to do some operation that looks suspciously like a >>> -merge-, but it's unclear to me. For each symbol from file 1, you want >>> to -use- file 2 and -keep- all observations with this symbol. >>> Following what you said earlier, you will now be left with approx. 100 >>> observations and many variables. Now you say you want to save this "as >>> ticker in the 1st file". What do you mean by that? You want to save >>> all 100 observations and many variables, in the first file? And what's >>> that to do with ticker? Ticker already exists in the first file. Do >>> you want to replace it, and with what information? Or do you want to >>> add ticker to the second file? >>> >>> You'll have to be more precise for someone to be able to help. >>> >>> Eva >>> >>> 2008/9/29 Ashim Kapoor <ashimkapoor@gmail.com>: >>>> Hello everyone, >>>> >>>> I have 2 files. >>>> >>>> The 1st file has 2 columns --> symbol and ticker. [ each symbol is >>>> only in one observation ] >>>> >>>> The 2nd file has many more columns --> symbol and many other vars. [ >>>> each symbol is in around 100 observations here ] >>>> >>>> I want to say foreach symbol in 1st file { >>>> >>>> use 2nd file >>>> >>>> keep if symbol ==above symbol >>>> >>>> save as ticker in the 1st file >>>> >>>> } >>>> >>>> >>>> Can someone tell me how to do this ? >>>> >>>> I guess to start with I would have to save the entire observations in >>>> symbol var in 1st file in ONE local macro and similarly for the >>>> ticker. Can someone tell me how to do this ? >>>> >>>> Thank you, >>>> >>>> Ashim. >>> * >>> * 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/ >> > * > * 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/ * * 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**:**-merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Eva Poen" <eva.poen@gmail.com>

**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Ashim Kapoor" <ashimkapoor@gmail.com>

**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Eva Poen" <eva.poen@gmail.com>

**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Ashim Kapoor" <ashimkapoor@gmail.com>

- Prev by Date:
**Re: st: comment out a number of lines together** - Next by Date:
**Re: st: Detect endogeneity in Probit** - Previous by thread:
**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)** - Next by thread:
**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)** - Index(es):

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