Hello!
I am currently working on a panel dataset containing, amongst others, the variables "companies", "year" (2010-2018), "sector" (arbitrary 4 digit number), and "net sales". Now,
I want to generate a new variable, namely, the sum of the net sales for all individual companies in each corresponding sector and the corresponding year.
I tried to find a command, however, I was unsuccessful.
Can anyone help me out?
Thank you in advance!
Related Posts with Creating a sum variable which depends on 2 other variables
reshape 4-levels wide format to 2X2 long formatHello, I have designed a 2✖2 within-subject design and get a 4-level repeated measure, how could I …
Diff command - Kernel-based Propensity Score Matching DID in the context of RCS dataHello, Hope you all are keeping safe. I hope some of you would be better positioned to answer a few…
Help with Stochastic Frontier Analysis/Translog Cost Function in Stata 15, bc95 modelDear Stata users, I am using Stata 15 and I am quite new in using this software. I am working on a …
Matching country specific data with relationship specific dataHello, I am trying to build up panel data for my gravity model. the dependent variable is trade flo…
Change scores in two wave panel dataHello, I have a two wave balanced panel dataset and I am trying to model change in employment statu…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a sum variable which depends on 2 other variables
Post a Comment