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
Calculating day-level statistics with data that may span across several daysHi, Data at hand: patient visit start and end dates/times, with each line representing a unique vis…
percent of correct predictionsHello, I am trying to estimate the number of correct predictions in a linear model using robust and …
Plotting a fitted Line for log scale axisHello, I have to plot a simple fitted line for exports relative to GDP (the variable is called "nor…
eprobit and marginsHi, I am going to use eprobit for my purpose of regressing a binary variable(y) on another endogeno…
need to drop duplicates depending on how many duplicates there are per observationI am trying to reshape my data from wide to long, however I need to drop duplicates first. Here is a…
Subscribe to:
Post Comments (Atom)
0 Response to Aggregating Dummy Variables Efficiently
Post a Comment