Help with computing a new variable

[ANASTASSIA VILDERSON]

Dear Community,

I have a following challenge in generating a certain variable for my dataset (a sample is attached as -dataex- below).

A brief description of the data: it is a panel data on firm (variable ID) and year level. All firms are classified by Industry and sample is sorted by industry and by year. All firms have some good and bad characteristics (below, there are only two characteristics – Good_char and Bad_char but the actual data set has many more characteristics). Some firms in the dataset are classified as Good and some are classified as Bad. The task is as follows:

For each industry-year, sum the values of Good_char for Good firms only and record the computed value as a new variable (let’s say, Index_Good) for all firms in this industry-year combination. And the same logic for Bad firms: for each industry-year, sum the values of Bad_char for Bad firms only and record the computed value as a new variable (let’s say, Index_Bad) for all firms in this industry-year combination.

For example, for Food Products and Year 2001 (rows 127-140): there are two IDs marked as Good (rows 130 and 139). The sum of Good_char of these two Good fims = 1 (1 + 0). So, the Index_Good variable for all firms in this industry-year combination (rows 127-140) should equal 1.

I tried the following

egen Index_Good = total( Good_char ) if Good == 1, by( Industry Year )

but it assigns the computed value only to the Good firms in the sample, and all others are assigned missing values.

Many thanks in advance for your help,
Anastassia.

* Example generated by -dataex-. For more info, type help dataex
clear
input double Year str16 ID float(Industry Good Bad) double(Good_char Bad_char)
1998 "72368610" 1 0 0 0 0
2001 "61166W10" 1 0 1 0 1
2002 "61166W10" 1 0 1 0 0
2003 "01623010" 1 0 0 0 0
2003 "24735710" 1 0 0 0 0
2003 "61166W10" 1 0 1 0 0
2003 "87908010" 1 0 0 0 0
2003 "91819410" 1 0 0 0 0
2003 "17003280" 1 1 0 0 0
2004 "17003280" 1 1 0 0 0
2004 "61166W10" 1 0 1 0 0
2004 "87908010" 1 0 0 0 0
2004 "01623010" 1 0 0 0 0
2004 "24735710" 1 0 0 0 0
2004 "91819410" 1 0 0 0 0
2004 "12803020" 1 0 0 0 0
2005 "91819410" 1 0 0 0 0
2005 "87908010" 1 0 0 0 0
2005 "61166W10" 1 0 0 0 0
2005 "24735710" 1 0 0 0 0
2005 "17003280" 1 1 0 0 0
2006 "87908010" 1 0 0 0 0
2006 "17003280" 1 0 0 0 0
2006 "24735710" 1 0 0 0 0
2006 "91819410" 1 0 0 0 0
2006 "61166W10" 1 0 1 0 0
2007 "12803020" 1 0 0 0 0
2007 "17003280" 1 0 0 0 0
2007 "91819410" 1 0 0 0 0
2007 "61166W10" 1 0 1 0 1
2007 "G3673810" 1 0 0 0 0
2007 "87908010" 1 0 0 0 0
2008 "12803020" 1 0 0 0 0
2008 "87908010" 1 0 0 0 0
2008 "17003280" 1 0 0 0 0
2008 "61166W10" 1 0 0 0 1
2008 "G3673810" 1 0 0 0 0
2008 "91819410" 1 0 0 0 0
2009 "91819410" 1 0 0 0 0
2009 "12803020" 1 0 0 0 0
2009 "17003280" 1 0 0 0 0
2009 "87908010" 1 0 0 0 0
2009 "61166W10" 1 0 0 0 1
2009 "G3673810" 1 0 0 0 0
2010 "17003280" 1 0 0 0 .
2010 "25660310" 1 0 0 0 .
2010 "12803020" 1 0 0 0 .
2010 "61166W10" 1 0 0 0 .
2010 "91819410" 1 0 0 . .
2010 "G3673810" 1 0 0 0 .
2010 "87908010" 1 0 0 0 .
2011 "61166W10" 1 0 0 0 .
2011 "17003280" 1 0 0 0 .
2011 "91819410" 1 0 0 . .
2011 "12803020" 1 0 0 0 .
2011 "25660310" 1 0 0 0 .
2011 "G3673810" 1 0 0 0 .
2011 "53274610" 1 0 0 0 .
2011 "87908010" 1 0 0 0 .
2012 "12803020" 1 0 0 . .
2012 "61166W10" 1 0 1 0 .
2012 "87908010" 1 0 0 0 .
2012 "53274610" 1 0 0 0 .
2012 "91819410" 1 0 0 . .
2012 "17003280" 1 0 0 . .
2012 "25660310" 1 0 0 . .
2013 "12803020" 1 0 0 . .
2013 "91819410" 1 0 0 . .
2013 "61166W10" 1 0 1 0 .
2013 "01623010" 1 0 0 . .
2013 "87908010" 1 0 0 . .
2014 "12803020" 1 0 0 . .
2014 "61166W10" 1 0 1 0 .
2014 "91819410" 1 0 0 . .
2014 "87908010" 1 0 0 . .
2015 "91819410" 1 0 0 . .
2015 "01623010" 1 0 0 . .
2015 "61166W10" 1 0 1 0 .
2015 "87908010" 1 0 0 . .
2015 "12803020" 1 0 0 . .
2016 "12803020" 1 0 0 . .
2016 "91819410" 1 0 0 . .
2016 "61166W10" 1 1 0 0 .
2016 "87908010" 1 0 0 . .
1998 "42786610" 2 0 0 0 0
1998 "75127730" 2 0 0 0 0
1998 "98252610" 2 0 0 0 0
1998 "20588710" 2 0 1 0 1
1998 "89051610" 2 0 0 0 0
1998 "03948310" 2 0 1 0 0
1998 "08146510" 2 0 0 0 0
1998 "08658U10" 2 0 1 0 1
1998 "67611110" 2 1 0 0 0
1998 "74740210" 2 0 0 0 0
1998 "48783610" 2 0 0 0 0
1998 "13442910" 2 0 0 0 0
1998 "37033410" 2 0 0 0 0
1998 "09676110" 2 0 0 0 0
1998 "87224510" 2 0 0 0 0
1999 "75127730" 2 0 0 0 0
1999 "37033410" 2 0 0 0 0
1999 "08658U10" 2 0 1 0 1
1999 "74740210" 2 0 0 0 0
1999 "20588710" 2 0 1 0 1
1999 "89051610" 2 0 0 0 0
1999 "03948310" 2 0 1 0 0
1999 "08146510" 2 0 0 0 0
1999 "67611110" 2 0 0 0 0
1999 "09676110" 2 0 0 0 0
1999 "42786610" 2 0 0 0 0
1999 "62952P10" 2 0 0 0 0
1999 "48783610" 2 0 0 0 0
1999 "13442910" 2 0 1 0 0
1999 "87224510" 2 0 0 0 0
1999 "98252610" 2 0 0 0 0
2000 "20588710" 2 0 1 0 1
2000 "44043T10" 2 1 0 0 0
2000 "74740210" 2 0 0 0 0
2000 "13442910" 2 0 1 0 0
2000 "42786610" 2 0 0 0 0
2000 "98252610" 2 0 0 0 0
2000 "89051610" 2 0 0 0 0
2000 "37033410" 2 0 0 0 0
2000 "48783610" 2 0 0 0 0
2000 "75127730" 2 0 0 0 0
2000 "67611110" 2 0 0 0 0
2001 "44045210" 2 0 0 0 0
2001 "03948310" 2 0 1 0 0
2001 "13442910" 2 0 1 0 0
2001 "44043T10" 2 1 0 1 0
2001 "37033410" 2 0 0 0 0
2001 "09676110" 2 0 0 0 0
2001 "57978020" 2 0 0 0 0
2001 "20588710" 2 0 1 0 1
2001 "42786610" 2 0 0 0 0
2001 "98252610" 2 0 0 0 0
2001 "90249410" 2 0 1 0 0
2001 "48783610" 2 0 0 0 0
2001 "40521710" 2 1 0 0 0
2001 "89051610" 2 0 0 0 0
2002 "09676110" 2 0 0 0 0
2002 "13442910" 2 0 0 0 0
2002 "20588710" 2 0 1 0 1
2002 "44043T10" 2 1 0 1 0
2002 "98252610" 2 0 0 0 0
2002 "89051610" 2 0 0 0 0
2002 "40521710" 2 1 0 1 0
2002 "03948310" 2 0 1 0 0
2002 "83269640" 2 1 0 1 0
2002 "48783610" 2 0 0 0 0
2002 "51384710" 2 0 0 0 0
2002 "90249410" 2 0 1 0 0
2002 "37033410" 2 0 0 0 0
2002 "42786610" 2 0 0 0 0
2002 "57978020" 2 0 0 0 0
2002 "44045210" 2 0 0 0 0
2003 "48783610" 2 0 0 0 0
2003 "70556010" 2 0 0 0 0
2003 "23726610" 2 0 0 0 0
2003 "20588710" 2 0 1 0 1
2003 "98252610" 2 0 0 0 0
2003 "80001310" 2 0 0 0 0
2003 "34349810" 2 0 0 0 0
2003 "68210P10" 2 0 0 0 0
2003 "42786610" 2 0 0 0 0
2003 "30767510" 2 0 0 0 0
2003 "46603210" 2 0 0 0 0
2003 "51384710" 2 0 0 0 0
2003 "75102810" 2 0 0 0 0
2003 "44045210" 2 0 0 0 0
2003 "03948310" 2 0 1 0 0
2003 "46004310" 2 0 0 0 0
2003 "37033410" 2 0 0 0 0
2003 "76953610" 2 0 0 0 0
2003 "90249410" 2 0 1 0 0
2003 "57978020" 2 0 0 0 0
2003 "80042210" 2 0 0 0 0
2003 "89051610" 2 0 0 0 0
2003 "09676110" 2 0 0 0 0
2003 "02707010" 2 0 0 0 0
2003 "13442910" 2 0 0 0 0
2003 "46072H10" 2 0 0 0 0
2003 "83269640" 2 1 0 1 0
2003 "40521710" 2 1 0 1 0
2004 "20588710" 2 0 1 0 1
2004 "80001310" 2 0 0 0 0
2004 "75102810" 2 0 0 0 0
2004 "70556010" 2 0 0 0 0
2004 "03948310" 2 0 1 0 0
2004 "83269640" 2 0 0 0 0
2004 "09676110" 2 0 0 0 0
2004 "23726610" 2 0 0 0 0
2004 "80042210" 2 0 0 0 0
2004 "37033410" 2 0 0 0 0
2004 "89051610" 2 0 0 0 0
2004 "40521710" 2 1 0 1 0
2004 "57978020" 2 0 0 0 0
2004 "34349810" 2 0 0 0 0
2004 "38061410" 2 0 0 0 0
2004 "44045210" 2 0 0 0 0
2004 "90249410" 2 0 1 0 0
2004 "48783610" 2 0 0 0 0
2004 "46603210" 2 0 0 0 0
2004 "13442910" 2 0 0 0 0
2004 "51384710" 2 0 0 0 0
2004 "02707010" 2 0 0 0 0
2004 "42786610" 2 0 0 0 0
2004 "30767510" 2 0 0 0 0
2004 "98252610" 2 0 0 0 0
2004 "68210P10" 2 0 0 0 0
2005 "42786610" 2 0 0 0 0
2005 "25260310" 2 0 0 0 0
2005 "98252610" 2 0 0 0 0
2005 "90249410" 2 0 1 0 0
2005 "80042210" 2 0 0 0 0
2005 "48783610" 2 0 0 0 0
2005 "37033410" 2 1 0 1 0
2005 "40521710" 2 1 0 1 0
2005 "46603210" 2 0 0 0 0
2005 "38061410" 2 0 0 0 0
2005 "23726610" 2 0 0 0 0
2005 "20588710" 2 0 1 0 1
2005 "57978020" 2 0 0 0 0
2005 "89469A10" 2 0 0 0 0
2005 "13442910" 2 0 1 0 0
2005 "51384710" 2 0 0 0 0
2005 "83269640" 2 0 0 0 0
2005 "30767510" 2 0 0 0 0
2005 "74060C10" 2 0 1 0 0
2005 "80001310" 2 0 0 0 0
2005 "89051610" 2 0 0 0 0
2005 "75734R10" 2 0 0 0 0
2005 "44045210" 2 0 0 0 0
2005 "70556010" 2 0 0 0 0
2005 "75102810" 2 0 0 0 0
2005 "34349810" 2 0 0 0 0
2006 "75734R10" 2 0 0 0 0
2006 "34349810" 2 0 0 0 0
2006 "44045210" 2 0 0 0 0
2006 "80001310" 2 0 1 0 0
2006 "13442910" 2 0 1 0 0
2006 "98252610" 2 0 0 0 0
2006 "83269640" 2 1 0 0 0
2006 "46603210" 2 0 0 0 0
2006 "89469A10" 2 0 0 0 0
2006 "30767510" 2 0 0 0 0
2006 "51384710" 2 0 0 0 0
2006 "90249410" 2 0 1 0 0
2006 "58470H10" 2 0 0 0 0
2006 "37033410" 2 1 0 0 0
2006 "75102810" 2 0 0 0 0
2006 "48783610" 2 1 0 0 0
2006 "70556010" 2 0 0 0 0
2006 "45309620" 2 0 0 0 0
2006 "25260310" 2 0 0 0 0
2006 "40521710" 2 1 0 1 0
2006 "23726610" 2 0 0 0 0
2006 "42786610" 2 0 0 0 0
2006 "89051610" 2 0 1 0 0
2006 "57978020" 2 0 0 0 0
2006 "20588710" 2 0 1 0 1
2007 "34349810" 2 0 0 0 0
2007 "51384710" 2 0 0 0 0
2007 "75102810" 2 0 0 0 0
2007 "83269640" 2 1 0 0 0
2007 "45309620" 2 0 0 0 0
2007 "42786610" 2 0 0 0 0
2007 "20588710" 2 0 1 0 1
2007 "30767510" 2 0 0 0 0
2007 "48783610" 2 1 0 0 0
2007 "23726610" 2 0 0 0 0
2007 "46603210" 2 0 0 0 0
2007 "98252610" 2 0 0 0 0
2007 "57978020" 2 0 0 0 0
2007 "37033410" 2 1 0 0 0
2007 "44045210" 2 0 0 0 0
2007 "80001310" 2 0 1 0 0
2007 "13442910" 2 0 1 0 0
2007 "40521710" 2 1 0 1 0
2007 "75734R10" 2 0 0 0 0
2007 "70556010" 2 0 0 0 0
2007 "51476610" 2 0 0 0 0
2007 "89469A10" 2 0 0 0 0
2007 "89051610" 2 0 1 0 0
2007 "G1696210" 2 0 1 0 0
2007 "90249410" 2 0 1 0 0
2007 "87164C10" 2 0 0 0 0
2008 "57978020" 2 0 0 0 0
2008 "51476610" 2 0 0 0 0
2008 "23726610" 2 1 0 0 0
2008 "05508R10" 2 0 0 0 0
2008 "45309620" 2 0 0 0 0
2008 "37033410" 2 1 0 0 0
2008 "25260310" 2 0 0 0 0
2008 "G1696210" 2 0 1 0 0
2008 "46603210" 2 0 0 0 0
2008 "89469A10" 2 0 0 0 0
2008 "75102810" 2 0 0 0 0
2008 "90249410" 2 0 1 0 0
2008 "83269640" 2 1 0 0 0
2008 "70556010" 2 0 0 0 0
2008 "30767510" 2 0 0 0 0
2008 "13442910" 2 0 1 0 0
2008 "34349810" 2 0 0 0 0
2008 "51384710" 2 0 0 0 0
2008 "75734R10" 2 0 0 0 0
2008 "20588710" 2 0 1 0 1
2008 "44045210" 2 0 0 0 0
2008 "89051610" 2 0 1 0 0
2008 "42786610" 2 0 0 0 0
2008 "80001310" 2 0 1 0 0
2008 "48783610" 2 1 0 0 0
2008 "40521710" 2 1 0 1 0
2008 "68210P10" 2 0 0 0 0
2008 "70705110" 2 0 0 0 0
2009 "13442910" 2 0 1 0 0
2009 "58470H10" 2 0 0 0 0
2009 "83269640" 2 1 0 0 0
2009 "34349810" 2 0 0 0 0
2009 "G1696210" 2 0 1 0 0
2009 "37033410" 2 1 0 0 0
2009 "57978020" 2 0 0 0 0
2009 "23726610" 2 1 0 0 0
2009 "89469A10" 2 0 0 0 0
2009 "30767510" 2 0 0 0 0
2009 "80001310" 2 0 1 0 0
2009 "75734R10" 2 0 0 0 0
2009 "48783610" 2 1 0 0 0
2009 "89051610" 2 0 1 0 0
2009 "46603210" 2 0 0 0 0
2009 "20588710" 2 0 1 0 1
2009 "75102810" 2 0 0 0 0
2009 "40521710" 2 1 0 1 0
2009 "68210P10" 2 0 0 0 0
2009 "44045210" 2 0 0 0 0
2009 "05508R10" 2 0 0 0 0
2009 "51476610" 2 0 0 0 0
2009 "40426A20" 2 0 0 0 0
2009 "70556010" 2 0 0 0 0
2009 "25260310" 2 0 0 0 0
2009 "45309620" 2 0 0 0 0
2009 "70705110" 2 0 0 0 0
2009 "53191410" 2 0 0 0 0
2009 "90249410" 2 0 1 0 0
2009 "51384710" 2 0 0 0 0
2009 "42786610" 2 0 0 0 0
2010 "58470H10" 2 0 0 0 .
2010 "45309620" 2 0 0 0 .
2010 "81707050" 2 0 0 0 .
2010 "68210P10" 2 0 0 0 .
2010 "90249410" 2 0 0 . .
2010 "37033410" 2 1 0 . .
2010 "70705110" 2 1 0 0 .
2010 "80042210" 2 0 0 0 .
2010 "13442910" 2 1 0 . .
2010 "57978020" 2 1 0 . .
2010 "25260310" 2 0 0 0 .
2010 "46603210" 2 0 0 0 .
2010 "75734R10" 2 0 0 . .
2010 "48783610" 2 1 0 . .
2010 "42786610" 2 1 0 . .
2010 "83269640" 2 1 0 . .
2010 "51476610" 2 0 0 0 .
2010 "34349810" 2 0 0 0 .
2010 "83355110" 2 0 0 0 .
2010 "40521710" 2 0 0 0 .
2010 "31429Y10" 2 0 0 0 .
2010 "30767510" 2 0 0 0 .
2010 "53191410" 2 0 0 0 .
2010 "70556010" 2 1 0 0 .
2010 "75102810" 2 0 0 . .
2010 "72147K10" 2 0 0 0 .
2010 "20588710" 2 1 0 . .
2010 "89051610" 2 0 0 . .
2010 "44045210" 2 1 0 . .
2010 "05508R10" 2 0 0 0 .
2010 "G1696210" 2 0 0 . .
2010 "23726610" 2 1 0 1 .
2010 "80001310" 2 0 0 0 .
2010 "98952K10" 2 0 0 0 .
2010 "87164C10" 2 0 0 0 .
2010 "51384710" 2 0 0 0 .
2010 "89469A10" 2 0 0 0 .
2011 "68210P10" 2 0 0 0 .
2011 "57978020" 2 1 0 . .
2011 "51384710" 2 0 0 0 .
2011 "83355110" 2 0 0 0 .
2011 "30767510" 2 0 0 0 .
2011 "83269640" 2 1 0 . .
2011 "20588710" 2 1 0 . .
2011 "89469A10" 2 0 0 0 .
2011 "46603210" 2 0 0 0 .
2011 "48783610" 2 1 0 . .
2011 "40521710" 2 0 0 0 .
2011 "89051610" 2 0 0 . .
2011 "53191410" 2 0 0 0 .
2011 "44045210" 2 1 0 . .
2011 "75102810" 2 0 0 . .
2011 "70556010" 2 1 0 0 .
2011 "13442910" 2 1 0 . .
2011 "51476610" 2 0 0 0 .
2011 "37033410" 2 1 0 . .
2011 "80042210" 2 0 0 0 .
2011 "58470H10" 2 0 0 0 .
2011 "81707050" 2 0 0 0 .
2011 "G1696210" 2 0 0 . .
2011 "42786610" 2 1 0 . .
2011 "23726610" 2 1 0 1 .
2011 "96169B10" 2 0 0 0 .
2011 "45309620" 2 0 0 0 .
2011 "90249410" 2 0 0 . .
2011 "25260310" 2 0 0 0 .
2011 "72147K10" 2 0 0 0 .
2011 "80001310" 2 0 0 0 .
2011 "34349810" 2 0 0 0 .
2011 "05508R10" 2 0 0 0 .
2012 "83355110" 2 0 0 . .
2012 "34349810" 2 0 0 . .
2012 "60920710" 2 1 0 . .
2012 "73744610" 2 0 0 . .
2012 "13442910" 2 1 0 . .
2012 "46603210" 2 0 0 . .
2012 "51384710" 2 0 0 . .
2012 "50076Q10" 2 1 0 . .
2012 "80001310" 2 0 0 . .
2012 "05508R10" 2 0 0 . .
2012 "30767510" 2 0 0 0 .
2012 "03600T10" 2 0 0 . .
2012 "58470H10" 2 0 0 . .
2012 "51476610" 2 0 0 0 .
2012 "48783610" 2 1 0 . .
2012 "45718710" 2 0 0 . .
2012 "42786610" 2 1 0 . .
2012 "43258910" 2 0 0 . .
2012 "40521710" 2 0 0 . .
2012 "44045210" 2 1 0 . .
2012 "57978020" 2 0 0 . .
2012 "83269640" 2 0 0 . .
2012 "25260310" 2 0 0 . .
2012 "20588710" 2 1 0 . .
2012 "80042210" 2 0 0 0 .
2012 "89051610" 2 0 0 . .
2012 "37033410" 2 1 0 . .
2012 "68210P10" 2 0 0 0 .
2012 "58283910" 2 0 0 . .
2012 "23726610" 2 0 0 . .
2012 "89469A10" 2 0 0 . .
2012 "90249410" 2 0 1 . .
2012 "10140510" 2 0 0 . .
2012 "81707050" 2 0 0 . .
2012 "87164C10" 2 0 0 0 .
2012 "53191410" 2 0 0 0 .
2012 "72147K10" 2 0 0 . .
2013 "34349810" 2 0 0 . .
2013 "25260310" 2 0 0 . .
2013 "45718710" 2 0 0 . .
2013 "24237020" 2 0 0 . .
2013 "23726610" 2 0 0 . .
2013 "40521710" 2 0 0 . .
2013 "51476610" 2 0 0 0 .
2013 "80001310" 2 0 0 . .
2013 "83355110" 2 0 0 . .
2013 "48783610" 2 1 0 . .
2013 "72348P10" 2 0 0 . .
2013 "57978020" 2 1 0 . .
2013 "42786610" 2 1 0 . .
2013 "10552T10" 2 0 0 . .
2013 "96624410" 2 0 0 . .
2013 "51384710" 2 0 0 . .
2013 "43258910" 2 0 0 . .
2013 "23636T10" 2 1 0 . .
2013 "46603210" 2 0 0 . .
2013 "20588710" 2 1 0 . .
2013 "56490510" 2 0 0 . .
2013 "90249410" 2 0 1 . .
2013 "60920710" 2 0 0 . .
2013 "58470H10" 2 0 0 . .
2013 "03948310" 2 0 0 . .
2013 "58283910" 2 1 0 . .
2013 "09676110" 2 0 0 . .
2013 "72147K10" 2 0 0 . .
2013 "44045210" 2 1 0 . .
2013 "10140510" 2 0 0 . .
2013 "64106940" 2 0 0 . .
2013 "89469A10" 2 0 0 . .
2013 "73744610" 2 0 0 . .
2013 "89051610" 2 0 0 . .
2013 "37033410" 2 1 0 . .
2013 "74061A10" 2 0 0 . .
2013 "05508R10" 2 0 0 . .
2013 "81707050" 2 0 0 . .
2013 "13442910" 2 1 0 . .
2013 "83269640" 2 1 0 . .
2013 "80291210" 2 0 0 . .
2014 "80001310" 2 0 0 . .
2014 "23726610" 2 0 0 . .
2014 "40521710" 2 0 0 . .
2014 "81707050" 2 0 0 . .
2014 "46603210" 2 0 0 . .
2014 "25260310" 2 0 0 . .
2014 "90249410" 2 0 1 . .
2014 "10140510" 2 0 0 . .
2014 "83269640" 2 1 0 . .
2014 "89051610" 2 0 0 . .
2014 "44045210" 2 1 0 . .
2014 "42786610" 2 1 0 . .
2014 "51384710" 2 0 0 . .
2014 "51476610" 2 0 0 0 .
2014 "89469A10" 2 0 0 . .
2014 "45718710" 2 0 0 . .
2014 "13442910" 2 1 0 . .
2014 "60920710" 2 0 0 . .
2014 "73744610" 2 0 0 . .
2014 "72348P10" 2 0 0 . .
2014 "34349810" 2 0 0 . .
2014 "05508R10" 2 0 0 . .
2014 "58283910" 2 1 0 . .
2014 "30767510" 2 0 0 . .
2014 "58470H10" 2 0 0 . .
2014 "24237020" 2 0 0 . .
2014 "83355110" 2 0 0 . .
2014 "96624410" 2 0 0 . .
2014 "80042210" 2 0 0 . .
2014 "20588710" 2 1 0 . .
2014 "57978020" 2 1 0 . .
2014 "37033410" 2 1 0 . .
2015 "25260310" 2 0 0 . .
2015 "51476610" 2 0 0 0 .
2015 "83355110" 2 0 0 . .
2015 "35803910" 2 0 0 . .
2015 "09676110" 2 0 0 . .
2015 "34349810" 2 0 0 . .
2015 "81707050" 2 0 0 . .
2015 "50075410" 2 0 0 . .
2015 "23726610" 2 0 0 . .
2015 "89051610" 2 0 0 . .
2015 "13442910" 2 1 0 . .
2015 "44045210" 2 1 0 . .
2015 "45718710" 2 0 0 . .
2015 "05508R10" 2 0 0 . .
2015 "37033410" 2 1 0 . .
2015 "24237020" 2 0 0 . .
2015 "20588710" 2 1 0 . .
2015 "51384710" 2 0 0 . .
2015 "42786610" 2 1 0 . .
2015 "40521710" 2 0 0 . .
2015 "30767510" 2 0 0 . .
2015 "60920710" 2 1 0 . .
2015 "73744610" 2 0 0 . .
2015 "72348P10" 2 0 0 . .
2015 "89469A10" 2 0 0 . .
2015 "03948310" 2 1 0 . .
2015 "58470H10" 2 0 0 . .
2015 "83269640" 2 1 0 . .
2015 "80001310" 2 0 0 . .
2015 "48783610" 2 1 0 . .
2015 "80042210" 2 0 0 . .
2015 "90249410" 2 0 0 . .
2015 "46603210" 2 0 0 . .
2015 "57978020" 2 1 0 . .
2015 "96624410" 2 0 0 . .
2016 "83269640" 2 1 0 . .
2016 "46603210" 2 0 0 . .
2016 "80042210" 2 0 0 . .
2016 "51384710" 2 0 0 . .
2016 "34349810" 2 0 0 . .
2016 "09531U10" 2 0 0 . .
2016 "72348P10" 2 1 0 . .
2016 "96624410" 2 0 0 . .
2016 "90249410" 2 0 1 . .
2016 "37033410" 2 1 0 . .
2016 "68210P10" 2 0 0 . .
2016 "35803910" 2 0 0 . .
2016 "48783610" 2 1 0 . .
2016 "13442910" 2 1 0 . .
2016 "83355110" 2 0 0 . .
2016 "03211L10" 2 0 0 . .
2016 "44045210" 2 1 0 . .
2016 "45718710" 2 0 0 . .
2016 "50075410" 2 0 0 . .
2016 "57978020" 2 1 0 . .
2016 "40521710" 2 0 0 . .
2016 "73744610" 2 0 0 . .
2016 "89469A10" 2 0 0 . .
2016 "30767510" 2 0 0 . .
2016 "81707050" 2 0 0 . .
2016 "42786610" 2 1 0 . .
2016 "89051610" 2 0 0 . .
2016 "23726610" 2 0 0 . .
2016 "05508R10" 2 0 0 . .
2016 "24237020" 2 1 0 . .
2016 "20588710" 2 1 0 . .
2016 "60920710" 2 1 0 . .
2016 "03948310" 2 1 0 . .
2016 "58470H10" 2 0 0 . .
2016 "51476610" 2 0 0 0 .
2016 "09676110" 2 0 0 . .
2016 "80001310" 2 0 0 . .
1998 "19121610" 3 0 0 0 0
1999 "19121610" 3 0 0 0 0
2000 "19121610" 3 0 1 0 0
2001 "71340910" 3 0 0 0 0
2001 "71343P20" 3 0 1 0 1
2001 "19121610" 3 0 1 0 0
2002 "19121610" 3 0 1 0 0
2002 "71343P20" 3 0 1 0 1
2002 "71340910" 3 0 0 0 0
2003 "71343P20" 3 0 1 0 1
2003 "19109810" 3 0 0 0 0
2003 "63501710" 3 0 0 0 0
2003 "19121610" 3 0 1 0 0
2003 "71340910" 3 0 0 0 0
2004 "63501710" 3 0 0 0 0
2004 "19121610" 3 0 1 0 0
2004 "71340910" 3 0 0 0 0
2004 "19109810" 3 0 0 0 0
2004 "71343P20" 3 0 1 0 1
2005 "19109810" 3 0 1 0 0
2005 "19121610" 3 0 0 0 0
2005 "71343P20" 3 0 1 0 1
2005 "71340910" 3 0 1 0 0
2005 "63501710" 3 0 0 0 0
2006 "19109810" 3 0 1 0 0
2006 "48023P10" 3 0 0 0 0
2006 "71340910" 3 0 0 0 0
2006 "19121610" 3 0 0 0 0
2006 "71343P20" 3 0 1 0 1
2006 "63501710" 3 0 0 0 0
2007 "71343P20" 3 0 1 0 1
2007 "19121610" 3 0 0 0 0
2007 "63501710" 3 0 0 0 0
2007 "71340910" 3 0 0 0 0
2007 "48023P10" 3 0 0 0 0
2007 "19109810" 3 0 1 0 0
2008 "19121610" 3 0 0 0 0
2008 "19109810" 3 0 1 0 0
2008 "71343P20" 3 0 0 0 0
2008 "71340910" 3 0 1 0 0
2008 "26138E10" 3 0 0 0 0
2009 "71343P20" 3 0 0 0 0
2009 "19121610" 3 0 0 0 0
2009 "48023P10" 3 0 0 0 0
2009 "19109810" 3 0 1 0 0
2009 "26138E10" 3 0 0 0 0
2009 "63501710" 3 0 0 0 0
2009 "71340910" 3 0 1 0 0
2010 "19109810" 3 0 0 0 .
2010 "26138E10" 3 1 0 . .
2010 "48023P10" 3 0 0 0 .
2010 "19121610" 3 0 0 . .
2010 "63501710" 3 0 0 0 .
2011 "63501710" 3 0 0 0 .
2011 "19109810" 3 0 0 0 .
2011 "74165N10" 3 0 0 0 .
2011 "19121610" 3 0 0 . .
2011 "26138E10" 3 1 0 . .
2012 "26138E10" 3 0 0 . .
2012 "19121610" 3 0 0 . .
2012 "63501710" 3 0 0 . .
2012 "19109810" 3 0 0 . .
2013 "61174X10" 3 0 0 . .
2013 "34441910" 3 1 0 . .
2013 "19122320" 3 1 0 . .
2013 "19124110" 3 1 0 . .
2013 "63501710" 3 0 0 . .
2013 "29081P30" 3 0 0 . .
2013 "26138E10" 3 1 0 . .
2013 "19109810" 3 0 0 . .
2013 "19121610" 3 0 0 . .
2014 "61174X10" 3 1 0 . .
2014 "19121610" 3 0 0 . .
2014 "19109810" 3 0 0 . .
2014 "26138E10" 3 1 0 . .
2014 "63501710" 3 0 0 . .
2015 "26138E10" 3 1 0 . .
2015 "63501710" 3 0 0 . .
2015 "19121610" 3 0 0 . .
2015 "61174X10" 3 1 0 . .
2015 "19109810" 3 0 0 . .
2016 "19121610" 3 1 0 . .
2016 "63501710" 3 0 0 . .
2016 "19109810" 3 0 0 . .
2016 "26138E10" 3 1 0 . .
2016 "61174X10" 3 0 0 . .
1998 "03522910" 4 1 0 0 0
1998 "71344810" 4 0 0 0 0
1999 "11563720" 4 0 0 0 0
1999 "03522910" 4 0 0 0 0
1999 "71344810" 4 0 0 0 0
2000 "71344810" 4 0 1 0 0
2001 "03522910" 4 0 0 0 0
2001 "21036P10" 4 0 0 0 0
2001 "71344810" 4 0 1 0 0
2002 "21036P10" 4 0 0 0 0
2002 "03522910" 4 0 0 0 0
2002 "71344810" 4 0 1 0 0
2003 "03522910" 4 0 0 0 0
2003 "21036P10" 4 0 0 0 0
2003 "60920010" 4 0 0 0 0
2003 "10055710" 4 0 0 0 0
2003 "71344810" 4 0 1 0 0
2003 "11563720" 4 0 0 0 0
2004 "10055710" 4 0 0 0 0
2004 "21036P10" 4 0 0 0 0
2004 "03522910" 4 0 0 0 0
2004 "11563720" 4 0 0 0 0
2004 "60920010" 4 0 0 0 0
2004 "71344810" 4 0 1 0 0
2005 "71344810" 4 0 1 0 0
2005 "21036P10" 4 0 0 0 0
2005 "60871R20" 4 1 0 0 0
2005 "11563720" 4 0 0 0 0
2005 "81724Q10" 4 0 0 0 0
2005 "10055710" 4 0 0 0 0
2006 "21036P10" 4 0 0 0 0
2006 "71344810" 4 0 1 0 0
2006 "11563720" 4 0 0 0 0
2006 "10055710" 4 0 0 0 0
2006 "81724Q10" 4 0 0 0 0
2006 "60871R20" 4 1 0 0 0
2007 "81724Q10" 4 0 0 0 0
2007 "10055710" 4 0 0 0 0
2007 "21036P10" 4 0 0 0 0
2007 "71344810" 4 0 0 0 0
2007 "11563720" 4 0 0 0 0
2007 "60871R20" 4 1 0 0 0
2008 "11563720" 4 0 0 0 0
2008 "60871R20" 4 1 0 0 0
2008 "21036P10" 4 0 0 0 0
2008 "71344810" 4 0 0 0 0
2008 "81724Q10" 4 0 0 0 0
2008 "10055710" 4 0 0 0 0
2009 "71344810" 4 0 0 0 0
2009 "81724Q10" 4 0 0 0 0
2009 "21036P10" 4 0 0 0 0
2009 "11563720" 4 0 0 0 0
2009 "60871R20" 4 1 0 0 0
2009 "10055710" 4 0 0 0 0
2010 "60871R20" 4 1 0 . .
2010 "11563720" 4 1 0 . .
2010 "71344810" 4 1 0 . .
2010 "21036P10" 4 1 0 . .
2010 "10055710" 4 0 0 0 .
2010 "81724Q10" 4 0 0 0 .
2011 "22412210" 4 0 0 0 .
2011 "60871R20" 4 1 0 . .
2011 "21036P10" 4 1 0 . .
2011 "81724Q10" 4 0 0 0 .
2011 "10055710" 4 0 0 0 .
2011 "71344810" 4 1 0 . .
2011 "11563720" 4 1 0 . .
2012 "55303J10" 4 0 0 0 .
2012 "11563720" 4 0 0 . .
2012 "60871R20" 4 1 0 . .
2012 "71344810" 4 1 0 . .
2012 "22412210" 4 0 0 0 .
2012 "21036P10" 4 0 0 . .
2012 "10055710" 4 0 0 . .
2013 "92719110" 4 0 0 . .
2013 "11563720" 4 1 0 . .
2013 "42301230" 4 1 0 . .
2013 "60871R20" 4 1 0 . .
2013 "25243Q20" 4 1 0 . .
2013 "20442910" 4 0 0 . .
2013 "03524A10" 4 0 0 . .
2013 "02319V10" 4 0 0 . .
2013 "71344810" 4 1 0 . .
2013 "10055710" 4 0 0 . .
2013 "21036P10" 4 0 0 . .
2014 "71344810" 4 1 0 . .
2014 "60871R20" 4 1 0 . .
2014 "11563720" 4 1 0 . .
2014 "10055710" 4 0 0 . .
2014 "21036P10" 4 1 0 . .
2015 "11563720" 4 1 0 . .
2015 "10055710" 4 0 0 . .
2015 "60871R20" 4 1 0 . .
2015 "71344810" 4 1 0 . .
2015 "21036P10" 4 1 0 . .
2016 "11563720" 4 1 0 . .
2016 "55303J10" 4 0 0 . .
2016 "10055710" 4 0 0 . .
2016 "60871R20" 4 1 0 . .
2016 "71344810" 4 1 0 . .
2016 "21036P10" 4 1 0 . .
1998 "90291110" 5 0 0 0 0
1999 "90291110" 5 0 0 0 0
2000 "90291110" 5 0 0 0 0
2001 "90291110" 5 0 0 0 0
2003 "02209S10" 5 0 0 0 0
2004 "02209S10" 5 0 0 0 0
2004 "76171310" 5 0 0 0 0
2004 "90291110" 5 0 0 0 0
2005 "90291110" 5 0 0 0 0
2005 "02209S10" 5 0 0 0 0
2005 "76171310" 5 0 0 0 0
2006 "90291110" 5 0 0 0 0
2006 "02209S10" 5 0 0 0 0
2006 "76171310" 5 0 0 0 0
2007 "76171310" 5 0 0 0 0
2007 "02209S10" 5 0 0 0 0
2008 "02209S10" 5 0 0 0 0
2008 "54414710" 5 0 0 0 0
2008 "71817210" 5 0 0 0 0
2008 "76171310" 5 1 0 0 0
2009 "76171310" 5 1 0 0 0
2009 "02209S10" 5 0 0 0 0
2009 "54414710" 5 0 0 0 0
2009 "71817210" 5 0 0 0 0
2010 "71817210" 5 1 0 . .
2010 "76171310" 5 1 0 . .
2010 "02209S10" 5 1 0 . .
2011 "76171310" 5 1 0 . .
2011 "71817210" 5 1 0 . .
2011 "02209S10" 5 1 0 . .
2012 "71817210" 5 1 0 . .
2012 "02209S10" 5 1 0 . .
2012 "76171310" 5 0 0 . .
2013 "02209S10" 5 1 0 . .
2013 "76171310" 5 1 0 . .
2013 "11044810" 5 1 0 . .
2014 "02209S10" 5 1 0 . .
2014 "76171310" 5 1 0 . .
2015 "76171310" 5 1 0 . .
2015 "02209S10" 5 1 0 . .
2016 "76171310" 5 1 0 . .
2016 "02209S10" 5 1 0 . .
1998 "41805610" 6 0 0 0 0
1998 "41308610" 6 0 0 0 0
1998 "81185010" 6 0 0 0 0
1998 "57708110" 6 0 0 0 0
1999 "57708110" 6 0 0 0 0
1999 "41308610" 6 0 0 0 0
1999 "41805610" 6 0 0 0 0
1999 "81185010" 6 0 0 0 0
2000 "81185010" 6 0 0 0 0
2000 "57708110" 6 0 0 0 0
2000 "41308610" 6 0 0 0 0
2000 "41805610" 6 0 0 0 0
2001 "41805610" 6 0 0 0 0
2001 "13119310" 6 0 0 0 0
2001 "57708110" 6 0 0 0 0
2001 "41308610" 6 0 0 0 0
2002 "57708110" 6 0 0 0 0
2002 "41308610" 6 0 0 0 0
2002 "41805610" 6 0 0 0 0
2002 "13119310" 6 0 0 0 0
2003 "29108720" 6 0 0 0 0
2003 "13119310" 6 0 0 0 0
2003 "91348310" 6 0 0 0 0
2003 "52186N10" 6 0 0 0 0
2003 "85849510" 6 0 0 0 0
2003 "63910B10" 6 0 0 0 0
2003 "41308610" 6 0 0 0 0
2003 "74938810" 6 0 0 0 0
2003 "57708110" 6 0 0 0 0
2003 "41805610" 6 0 0 0 0
2003 "10335410" 6 0 0 0 0
2004 "91348310" 6 0 0 0 0
2004 "41805610" 6 0 0 0 0
2004 "29605610" 6 0 0 0 0
2004 "74938810" 6 0 0 0 0
2004 "41308610" 6 0 0 0 0
2004 "63910B10" 6 0 0 0 0
2004 "85849510" 6 0 0 0 0
2004 "57708110" 6 0 0 0 0
2004 "13119310" 6 0 0 0 0
2004 "52186N10" 6 0 0 0 0
2005 "29605610" 6 0 0 0 0
2005 "13119310" 6 0 0 0 0
2005 "52186N10" 6 0 0 0 0
2005 "74938810" 6 0 0 0 0
2005 "85849510" 6 0 0 0 0
2005 "63910B10" 6 0 0 0 0
2005 "41805610" 6 0 0 0 0
2005 "41308610" 6 0 0 0 0
2005 "57708110" 6 0 0 0 0
2005 "91348310" 6 0 0 0 0
2006 "57708110" 6 0 0 0 0
2006 "52186N10" 6 0 0 0 0
2006 "91348310" 6 0 0 0 0
2006 "63910B10" 6 0 0 0 0
2006 "85849510" 6 0 0 0 0
2006 "41805610" 6 0 0 0 0
2006 "41308610" 6 0 0 0 0
2006 "74938810" 6 0 0 0 0
2006 "13119310" 6 0 0 0 0
2007 "85849510" 6 0 0 0 0
2007 "52186N10" 6 0 0 0 0
2007 "41308610" 6 0 0 0 0
2007 "13119310" 6 0 0 0 0
2007 "74938810" 6 0 0 0 0
2007 "57708110" 6 1 0 0 0
2007 "63910B10" 6 0 0 0 0
2007 "41805610" 6 0 0 0 0
2007 "91348310" 6 0 0 0 0
2007 "87163L10" 6 0 0 0 0
2008 "13119310" 6 0 0 0 0
2008 "52186N10" 6 0 0 0 0
2008 "41308610" 6 0 0 0 0
2008 "74938810" 6 0 0 0 0
2008 "41805610" 6 1 0 0 0
2008 "57708110" 6 1 0 0 0
2008 "85849510" 6 0 0 0 0
2008 "91348310" 6 0 0 0 0
2008 "63910B10" 6 0 0 0 0
2009 "85849510" 6 0 0 0 0
2009 "13119310" 6 0 0 0 0
2009 "91348310" 6 0 0 0 0
2009 "52186N10" 6 0 0 0 0
2009 "41308610" 6 0 0 0 0
2009 "57708110" 6 1 0 0 0
2009 "74938810" 6 0 0 0 0
2009 "63910B10" 6 0 0 0 0
2009 "41805610" 6 1 0 0 0
2010 "74938810" 6 0 0 0 .
2010 "41308610" 6 0 0 . .
2010 "41805610" 6 1 0 . .
2010 "52186N10" 6 0 0 0 .
2010 "57708110" 6 1 0 . .
2010 "91348310" 6 0 0 0 .
2010 "63910B10" 6 0 0 . .
2010 "13119310" 6 0 0 0 .
2010 "85849510" 6 0 0 . .
2011 "85849510" 6 0 0 0 .
2011 "52186N10" 6 0 0 0 .
2011 "13119310" 6 0 0 0 .
2011 "41308610" 6 0 0 . .
2011 "57708110" 6 1 0 . .
2011 "91348310" 6 0 0 0 .
2011 "41805610" 6 1 0 . .
2012 "57708110" 6 1 0 . .
2012 "83083J10" 6 0 0 0 .
2012 "13119310" 6 0 0 . .
2012 "85849510" 6 0 0 0 .
2012 "41805610" 6 1 0 . .
2012 "41308610" 6 0 0 0 .
2012 "91348310" 6 0 0 0 .
2012 "91829F10" 6 0 0 0 .
2012 "52186N10" 6 0 0 . .
2013 "41805610" 6 0 0 . .
2013 "57708110" 6 0 0 . .
2013 "41308610" 6 0 0 0 .
2013 "91348310" 6 0 0 0 .
2013 "13119310" 6 0 0 . .
2013 "52186N10" 6 0 0 . .
2013 "65444530" 6 0 0 . .
2014 "91348310" 6 0 0 0 .
2014 "13119310" 6 0 0 . .
2014 "57708110" 6 1 0 . .
2014 "63910B10" 6 0 0 . .
2014 "52186N10" 6 0 0 . .
2015 "91348310" 6 0 0 0 .
2015 "41308610" 6 1 0 0 .
2015 "57708110" 6 1 0 . .
2015 "13119310" 6 0 0 . .
2015 "41805610" 6 1 0 . .
2015 "63910B10" 6 0 0 . .
2016 "13119310" 6 0 0 . .
2016 "91348310" 6 0 0 0 .
2016 "41308610" 6 0 0 0 .
2016 "63910B10" 6 0 0 . .
2016 "41805610" 6 1 0 . .
2016 "57708110" 6 1 0 . .
1998 "60462E10" 7 0 0 0 0
1998 "88731510" 7 0 0 0 0
1998 "49566710" 7 0 0 0 0
1999 "60462E10" 7 0 0 0 0
1999 "88731510" 7 0 0 0 0
2001 "45990210" 7 0 0 0 0
2001 "46033520" 7 0 0 0 0
2001 "56256710" 7 0 0 0 0
2001 "59161010" 7 0 0 0 0
2001 "55295310" 7 0 0 0 0
2001 "72581110" 7 0 0 0 0
2002 "45990210" 7 0 0 0 0
2002 "46033520" 7 0 0 0 0
2002 "55295310" 7 0 0 0 0
2002 "56256710" 7 0 0 0 0
2002 "59161010" 7 0 0 0 0
2002 "75876610" 7 0 0 0 0
2002 "72581110" 7 0 0 0 0
2003 "91879Q10" 7 0 0 0 0
2003 "55295310" 7 0 0 0 0
2003 "75876610" 7 0 0 0 0
2003 "56256710" 7 0 0 0 0
2003 "17148410" 7 0 0 0 0
2003 "00166910" 7 0 0 0 0
2003 "70756910" 7 0 0 0 0
2003 "85768910" 7 0 0 0 0
2003 "84778810" 7 0 0 0 0
2003 "03070Q10" 7 0 0 0 0
2003 "46459210" 7 0 0 0 0
2003 "83615120" 7 0 0 0 0
2003 "14343640" 7 0 0 0 0
2003 "59161010" 7 0 0 0 0
2003 "26017410" 7 0 0 0 0
2003 "45990210" 7 0 0 0 0
2003 "75540810" 7 0 0 0 0
2003 "05480210" 7 0 0 0 0
end
label values Industry ffi48
label def ffi48 1 "Agriculture", modify
label def ffi48 2 "Food Products", modify
label def ffi48 3 "Candy & Soda", modify
label def ffi48 4 "Beer & Liquor", modify
label def ffi48 5 "Tobacco Products", modify
label def ffi48 6 "Recreation", modify
label def ffi48 7 "Entertainment", modify

[Andrew Musau]

You want the -bysort- prefix to execute a command for each group of observations.

but it assigns the computed value only to the Good firms in the sample, and all others are assigned missing values.

This is because you include the -if- qualifier in your command which restricts observations to those where "Good" is equal to 1. You want:

bys Industry Year: egen wanted= total(Good_char==1)

or

egen wanted= total(Good_char==1), by(Industry Year)

[ANASTASSIA VILDERSON]

Hello Andrew Musau and thank you for such a quick reply!

I think the code proposed sums up all the Good_char observations by year and industry. My task is to sum up Good_char of Good firms only (by industry and year) but then to assign this calculated summed value to all the firms within same industry-year group.. So, basically the sum of Good-char of Good firms serves as a benchmark value for all the firms in the same industry-year combination.

Thanks,
Anastassia.

[Andrew Musau]

bys Industry Year: egen wanted= total(Good_char==1 & Good)

[ANASTASSIA VILDERSON]

Thank you so much!! This is exactly what's needed!