Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Selecting part of a LARGE file


From   "Hoetker, Glenn" <[email protected]>
To   <[email protected]>
Subject   st: Selecting part of a LARGE file
Date   Fri, 6 Jun 2003 10:47:58 -0500

Hi all.

I have two files.  File A has about 5000 unique values of the variable
PATENT, which is 7 characters long.  File B has 16 million observations
and several million unique values for PATENT.  I want to do some
manipulation involving File B, but only for the observations that
correspond to the patent values found in File A.   I am currently using
merge on the two files to do this (actually mmerge as a wrapper for
ease), but wonder if there is an easier/faster way.

I attempted using vallist.ado in File A to generate a long local macro
(say, _useme) and then doing

	use FileB if index(patent, "'useme'")

I get 0 observations in this case (even though I know there are some
matches).  From the manual, it appears that index is limited to strings
of 80 characters, anyway.

Any better suggestions?  Thank you in advance.

Glenn

Glenn Hoetker
Assistant Professor of Strategy
College of Business Administration
University of Illinois at Urbana-Champaign
217-265-4081
[email protected]
"Success is going from failure to failure without a loss of enthusiasm."
Sir Winston Churchill 

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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