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
Graded fading of the background color using plotregion(color())Hello, I am using Stata 16.1 MP. I have the code and output for a simple injury risk (burden) matr…
DHS Data - Sample weights and stratification - Nigeria 2008 and 2018Dear all, Currently I am using DHS data in combination with Stata for the first time. I intend to e…
Unit root in variablesFor my study I am writing a research paper for the first time and I seem to be having a problem with…
Mixed Logit model issueHello everyone. I'm trying to perform a mixlogit model on a panel of firm-level data across 14 year…
"tsegen" by groupHi, I would like to calculate the moving average of _b_LogSize _b_LogBM _b_MOM12 _b_cons by months …
Subscribe to:
Post Comments (Atom)
0 Response to Aggregating Dummy Variables Efficiently
Post a Comment