I'm struggling to come up with a solution for finding if each observation in variable 1 matches ANY of the specified observations in v2.I'm trying to narrow the data to focus on passengers that have arrived on-time at least one time in the data. That way I can look at those passengers' data, even for points when they weren't on time.
I'm trying to pass a numlist to anymatch of the names of the ID's of the passengers that have arrived on time at least one time but I'm getting an error.
"values() invalid -- invalid numlist"
This is my code:
g on_time= passengers if timely==1; // limiting to timely arrivals.
levelsof on_time;
g on_time_levels= r(levels); //unique numlist of passengers with timely arrivals (unsure of this)
g on_time_ever=.;
forvalues i =1/6939 {;
egen tempvariable = anymatch(passengers) if _n==`i',values(on_time_levels);
replace on_time_ever=tempvariable if _n==`i';
drop tempvariable;
};
I am unsure if the levels var I generated is really a numlist. How else can I get a numlist from this variable so I can pass it to anymatch? Or am I just going about this completely wrong?
Thanks!
Related Posts with Using anymatch in a forvalue loop to detect if each value in v1 matches ANY value in v2
Weighting regressionsHi, My regression involves forming skill groups from time series data and conducting a panel analys…
Quadratic expression of Kuznets curveGood morning, I am trying to run a regression for a waste Kuznets curve (panel data). I used the qu…
Confidence Intervals upper bound above 1 (100%) for survey data prevalenceI have a problem with generated confidence intervals for prevalence using survey data. We are invest…
Unable to start SEM Builder - Stata/MP 15.1Dear all, in my Stata/MP 15.1 version I am unable to start the SEM Builder. After clicking on "SEM …
The independence of irrelevant alternatives assumpition test of multinominal logit has an errorDear statalist users: The independence of irrelevant alternatives assumpition test using "mlogtest, …
Subscribe to:
Post Comments (Atom)
0 Response to Using anymatch in a forvalue loop to detect if each value in v1 matches ANY value in v2
Post a Comment