Hi Statalist,
I very much appreciate your help with my question.
I have hundreds of dummy variables that I would like to group together and then create new variables of these groups. I can do this successfully using the following code. For instance:
gen OSB6_Sci = 1 if ( SB6_42_Sci == 1 | SB6_20_Sci == 1 | SB6_13_Sci == 1 | SB6_11_Sci == 1)
gen OSB6_Vol = 1 if (SB6_42_Vol == 1 | SB6_13_Vol == 1)
gen OSB5_Sci = 1 if ( SB5_42_Sci == 1 | SB5_13_Sci == 1 | SB5_11_Sci == 1)
gen OSB4_Vol = 1 if ( SB4_20_Vol == 1 | SB4_13_Vol == 1 | SB6_5_Vol == 1)
As you can see there are many combinations and this is a very time consuming method. Is there any code that would enable me to do this more efficiently?
(I have tried using a loop command but I am unsure how to do this because I am creating the new variable for all of the dummy variables in that group not foreach of them.)
Thank you very much for all your time and help. If you required further detail or clarification I can provide more information.
Best regards
Seren
Related Posts with Aggregating Dummy Variables Efficiently
Predicting counterfactual from reghdfeDear Statlisters, I am trying to compute a counterfactual prediction if a certain explanatory varia…
SEM panel model with three variables: cross-lagged vs synchronousI have limited training in SEM and have a couple of questions about a somewhat complicated model dec…
Convert variables to numericHello, I have the following dataset (below) and I want to convert the variables "tfertrate", "mofert…
Regressions Table in StataHow to create a table in Stata which shows the difference of two regression results previously run? …
OLS with binary dependent variableHi everyone, I read several papers where they employ an OLS method (xtreg with fixed effects) for p…
Subscribe to:
Post Comments (Atom)
0 Response to Aggregating Dummy Variables Efficiently
Post a Comment