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
Sankey visual analysisHi, I am trying to use Sankey to visually describe longitudinal patterns/flow in Stata 17. (I have …
Advice on Reshaping/Collapsing Data on Resident Stays to a Dataset on Facility OccupancyDear all, I am working with nursing home data, and would greatly appreciate some advice on how to e…
Getting rid of unwanted missing value in a variableHi, I have the following variable "coeff" Code: * Example generated by -dataex-. To install: ssc …
mixed: How do I retrieve the intercept-slope correlation?Hi I am fitting a model like this: Code: webuse nlswork, clear mixed ln_w tenure || id: tenure, …
psmatch2 and teffects psmatchI have a question, how can I get the pscore delivered by psmatch2 command automatically, but using t…
Subscribe to:
Post Comments (Atom)
0 Response to Aggregating Dummy Variables Efficiently
Post a Comment