Hello,
I have a dataset that looks into the type of offences that companies made in a given year. Sometimes companies have different types of offences in a given year, so there are several observations with the same year. My goal is to transform my dataset in a way that I have company names, the given year, and type of offense in the given year, but if in the same year different types of offenses happened, I want Stata to recode the offense group "Mixed". So in the end, I will get rid of repetitive years for a given company. I would greatly appreciate if you could adivse me on how I can get there.
I have a dataset that looks into the type of offences that companies made in a given year. Sometimes companies have different types of offences in a given year, so there are several observations with the same year. My goal is to transform my dataset in a way that I have company names, the given year, and type of offense in the given year, but if in the same year different types of offenses happened, I want Stata to recode the offense group "Mixed". So in the end, I will get rid of repetitive years for a given company. I would greatly appreciate if you could adivse me on how I can get there.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str450 parentcompany double year str39 offensegroup "3D Systems Corporation (NYSE:DDD)" 2002 "" "3D Systems Corporation (NYSE:DDD)" 2003 "" "3D Systems Corporation (NYSE:DDD)" 2004 "" "3D Systems Corporation (NYSE:DDD)" 2005 "employment-related offenses" "3D Systems Corporation (NYSE:DDD)" 2006 "" "3D Systems Corporation (NYSE:DDD)" 2007 "" "3D Systems Corporation (NYSE:DDD)" 2008 "" "3D Systems Corporation (NYSE:DDD)" 2009 "" "3D Systems Corporation (NYSE:DDD)" 2010 "" "3D Systems Corporation (NYSE:DDD)" 2011 "" "3D Systems Corporation (NYSE:DDD)" 2012 "" "3D Systems Corporation (NYSE:DDD)" 2013 "safety-related offenses" "3D Systems Corporation (NYSE:DDD)" 2014 "safety-related offenses" "3D Systems Corporation (NYSE:DDD)" 2015 "" "3D Systems Corporation (NYSE:DDD)" 2016 "" "3D Systems Corporation (NYSE:DDD)" 2017 "" "3D Systems Corporation (NYSE:DDD)" 2018 "" "3D Systems Corporation (NYSE:DDD)" 2019 "" "3M Company (NYSE:MMM)" 2002 "safety-related offenses" "3M Company (NYSE:MMM)" 2003 "environment-related offenses" "3M Company (NYSE:MMM)" 2003 "safety-related offenses" "3M Company (NYSE:MMM)" 2004 "safety-related offenses" "3M Company (NYSE:MMM)" 2004 "environment-related offenses" "3M Company (NYSE:MMM)" 2005 "employment-related offenses" "3M Company (NYSE:MMM)" 2006 "environment-related offenses" "3M Company (NYSE:MMM)" 2006 "safety-related offenses" "3M Company (NYSE:MMM)" 2007 "employment-related offenses" "3M Company (NYSE:MMM)" 2008 "environment-related offenses" "3M Company (NYSE:MMM)" 2008 "safety-related offenses" "3M Company (NYSE:MMM)" 2008 "employment-related offenses" "3M Company (NYSE:MMM)" 2009 "safety-related offenses" "3M Company (NYSE:MMM)" 2010 "financial offenses" "3M Company (NYSE:MMM)" 2010 "employment-related offenses" "3M Company (NYSE:MMM)" 2010 "safety-related offenses" "3M Company (NYSE:MMM)" 2010 "competition-related offenses" "3M Company (NYSE:MMM)" 2010 "environment-related offenses" "3M Company (NYSE:MMM)" 2011 "safety-related offenses" "3M Company (NYSE:MMM)" 2011 "employment-related offenses" "3M Company (NYSE:MMM)" 2011 "environment-related offenses" "3M Company (NYSE:MMM)" 2012 "safety-related offenses" "3M Company (NYSE:MMM)" 2012 "competition-related offenses" "3M Company (NYSE:MMM)" 2012 "environment-related offenses" "3M Company (NYSE:MMM)" 2013 "environment-related offenses" "3M Company (NYSE:MMM)" 2013 "safety-related offenses" "3M Company (NYSE:MMM)" 2014 "safety-related offenses" "3M Company (NYSE:MMM)" 2014 "environment-related offenses" "3M Company (NYSE:MMM)" 2015 "" "3M Company (NYSE:MMM)" 2016 "safety-related offenses" "3M Company (NYSE:MMM)" 2017 "environment-related offenses" "3M Company (NYSE:MMM)" 2017 "safety-related offenses" "3M Company (NYSE:MMM)" 2018 "safety-related offenses" "3M Company (NYSE:MMM)" 2018 "employment-related offenses" "3M Company (NYSE:MMM)" 2018 "government-contracting-related offenses" "3M Company (NYSE:MMM)" 2018 "environment-related offenses" "3M Company (NYSE:MMM)" 2019 "safety-related offenses" "3M Company (NYSE:MMM)" 2019 "environment-related offenses" "3M Company (NYSE:MMM)" 2019 "employment-related offenses" "AECOM (NYSE:ACM)" 2005 "" "AECOM (NYSE:ACM)" 2006 "" "AECOM (NYSE:ACM)" 2007 "" "AECOM (NYSE:ACM)" 2008 "" "AECOM (NYSE:ACM)" 2009 "" "AECOM (NYSE:ACM)" 2010 "" "AECOM (NYSE:ACM)" 2011 "" "AECOM (NYSE:ACM)" 2012 "government-contracting-related offenses" "AECOM (NYSE:ACM)" 2012 "safety-related offenses" "AECOM (NYSE:ACM)" 2012 "employment-related offenses" "AECOM (NYSE:ACM)" 2013 "" "AECOM (NYSE:ACM)" 2014 "" "AECOM (NYSE:ACM)" 2015 "" "AECOM (NYSE:ACM)" 2016 "" "AECOM (NYSE:ACM)" 2017 "" "AECOM (NYSE:ACM)" 2018 "" "AECOM (NYSE:ACM)" 2019 "safety-related offenses" "AECOM (NYSE:ACM)" 2019 "employment-related offenses" "ANSYS, Inc. (NasdaqGS:ANSS)" 2002 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2003 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2004 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2005 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2006 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2007 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2008 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2009 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2010 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2011 "employment-related offenses" "ANSYS, Inc. (NasdaqGS:ANSS)" 2012 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2013 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2014 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2015 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2016 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2017 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2018 "" "ANSYS, Inc. (NasdaqGS:ANSS)" 2019 "" "AT&T Inc. (NYSE:T)" 2002 "consumer-protection-related offenses" "AT&T Inc. (NYSE:T)" 2002 "competition-related offenses" "AT&T Inc. (NYSE:T)" 2002 "employment-related offenses" "AT&T Inc. (NYSE:T)" 2003 "employment-related offenses" "AT&T Inc. (NYSE:T)" 2003 "consumer-protection-related offenses" "AT&T Inc. (NYSE:T)" 2003 "safety-related offenses" "AT&T Inc. (NYSE:T)" 2004 "safety-related offenses" end
Comment