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/
