Hi guys,
I would like to make a loop that includes several different variables for different databases. Let's say I have DB1, DB2, DB3 corresponding to 3 different aggregations (product, firm, market). For each level some of the variables I will create are similar and just differ for the names (e.g. gr_rate_product, gr_rate_firm, gr_rate_atc2) so that I can just change the name in the loop like this for instance: gr_rate_`i' . However some of the variables are specific for each level and are not included in other levels (e.g. for market database there is a variable called share_off_generics which does not appear neither in DB1 nor in DB2 and that cannot be created with the data contained in such DBs). My aim is to perform 3 regression with all the variables of the 3 DBs and include them in a single loop. So something like:
reg gr_rate`i' var1_`i' var2 if DB = DB1
reg gr_rate`i' var1_`i' var2 var3 if DB = DB2
reg gr_rate`i' var1_`i' var4 if DB = DB3
where var1_`i' denotes the generic variable in common and var2, var3, var4 are DB specific variables
Is there a way to do it?
Thanks a lot
Related Posts with Looping through different databases
Esttab: Combining summary statistics and correlation tableHello Stata experts, I try to export my summary statistics, the correlation table and my regression…
how can I generate a dummy variable based on another dummy variable?Hi all, my data pretty much looks like the following Code: Year company var1 1999 CompanyA 0 200…
Maximum Likelihood EstimationHey I am supposed to estimate the three parameters (i.e. lambda0, lambda1 and delta) in the followi…
Partialing out multiple regressors (Frisch-Waugh Lovell Theorem) and reghdfe commandDear All, I want to run a generalized diff-in-diff regression that exploits time variation in state…
Grouping DataI am conducting a cross-sectional study of UK FTSE 100 firms. I want to group companies by industry …
Subscribe to:
Post Comments (Atom)
0 Response to Looping through different databases
Post a Comment