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
categorical variableDear researchers, I am new to this great website, and this is my first post, and I hope to receive a…
Define Variables in a loopDear all, I would like to run a regression for three different (dependent) variables in a loop, whi…
Problem on Hansen test for over identifying restriction (system-GMM)Dear Stata users, I have a dynamic panel of 113 countries for 27 year, and I am using the system-GMM…
Creating compositional variables and sample weightsHello everyone, I have a quick question about creating compositional variables, such as the share o…
Histogram with dummiesHi I want to do a Histogram, which shows how many percentage of certain people earn less than the mi…
Subscribe to:
Post Comments (Atom)
0 Response to Looping through different databases
Post a Comment