[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Martin Weiss" <[email protected]> |

To |
<[email protected]> |

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: [email protected]
[mailto:[email protected]] On Behalf Of Ashim Kapoor
Sent: Tuesday, September 30, 2008 7:58 AM
To: [email protected]
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 <[email protected]> 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 <[email protected]>:
>> 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 <[email protected]> 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 <[email protected]>:
>>>> 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" <[email protected]>

**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Ashim Kapoor" <[email protected]>

**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Eva Poen" <[email protected]>

**Re: -merge- (?) problem (was: st: MIME-Version: 1.0)***From:*"Ashim Kapoor" <[email protected]>

- 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–2024 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |