[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: Selecting part of a LARGE file
I'm not sure what the problem is -- I deal with this issue all the time.
merge patent using fileb, nokeep
*optionally check the merging and drop non-matching obs from filea
keep if _merge==3
Maybe the problem is that you aren't using the -nokeep- option for the
merge. With this approach, I find Stata to be quite fast at just selecting
the observations of interest and there aren't any substantial memory
problems because you never have to hold the full combined dataset in memory.
I'm sure this would be much faster than any ridiculously long use if....
construct (and your approach using index will certainly run out of room
after just a few dozen patent strings are appended togther).
----- Original Message -----
From: "Hoetker, Glenn" <firstname.lastname@example.org>
Sent: Friday, June 06, 2003 11:47 AM
Subject: st: Selecting part of a LARGE file
> 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 Hoetker
> Assistant Professor of Strategy
> College of Business Administration
> University of Illinois at Urbana-Champaign
> "Success is going from failure to failure without a loss of enthusiasm."
> Sir Winston Churchill
* For searches and help try: