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
Downloading data from internetHello, I need to download data from this website. Technically, to download data one is supposed to c…
Finding the maximum value for a subset of observationsHi everyone, I have a panel dataset with 148 countries and 70 years and I am trying to identify epi…
Summary statistics over two groupsI want to have the mean and sd of a variable separated by two grouping variables, like below but in …
Commands to get the graph between cumulative distribution function of years of schooling and birth orderDear stat specialists, I am working with cross-sectional data obtained from Pakistan Bureau of stati…
Pooled regression with interaction term for time?Dear All! I have panel data (time: 2 periods; N: 2,093) and because the Breusch and Pagan Lagrange …
Subscribe to:
Post Comments (Atom)
0 Response to Aggregating Dummy Variables Efficiently
Post a Comment