I'm trying to get make this into a panel, but I can't since it duplicated time observations within panels.
xtset CIK date
repeated time values within panel
My dataset for each panel, TIC and CIK (both unique panel indentifiers), date, (yearly) company name, form type (submitted company form to the SEC, can be 10-k or 10-K/A), and the business, city, stata and zip code for that company's specific year. Now what I want to see is if there is a change in the street, city, state or zip address from one year to another.
The data initially had only to get 10-K submissions, but it got all the 10K/A as well, which are amendments a company does after they submitted a 10-K on a specific year. Therefore there are might be more than one observation per year of a company.
Therefore, to create the panel, I have to tell stata to keep only the 10-K year observation (NOT the 10-K/A) IFF, there hasn't been a change of city, street, zip or state. (the ba_street_change ba_city_change ba_state_change ba_zip_change are dummies for change from one year to another). If with the 10-K/A there is a change of location, then I have to keep that obervation and drop the other one.
How can I tell stata to do this?
The dataaset below:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str7 TIC long CIK int date str72 Company_Conformed_Name str9 Form_Type str40 BA_Street1 str30 BA_City str8 BA_State str10 BA_Zip float(ba_street_change ba_city_change ba_state_change ba_zip_change) "AIR" 1750 2009 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "AIR" 1750 2010 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "AIR" 1750 2011 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "AIR" 1750 2012 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "AIR" 1750 2013 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "AIR" 1750 2014 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "AIR" 1750 2015 "AAR CORP" "10-K" "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 "ABT" 1800 2009 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2010 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2011 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2012 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2013 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2013 "ABBOTT LABORATORIES" "10-K/A" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2014 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ABT" 1800 2015 "ABBOTT LABORATORIES" "10-K" "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 "ACET" 2034 2009 "ACETO CORP" "10-K" "ONE HOLLOW LANE" "LAKE SUCCESS" "NY" "11042" 0 0 0 0 "ACET" 2034 2010 "ACETO CORP" "10-K" "ONE HOLLOW LANE" "LAKE SUCCESS" "NY" "11042" 0 0 0 0 "ACET" 2034 2011 "ACETO CORP" "10-K" "ONE HOLLOW LANE" "LAKE SUCCESS" "NY" "11042" 0 0 0 0 "ACET" 2034 2012 "ACETO CORP" "10-K" "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 1 1 0 1 "ACET" 2034 2013 "ACETO CORP" "10-K" "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 0 0 0 0 "ACET" 2034 2014 "ACETO CORP" "10-K" "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 0 0 0 0 "ACET" 2034 2015 "ACETO CORP" "10-K" "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 0 0 0 0 "AE" 2178 2009 "ADAMS RESOURCES & ENERGY, INC." "10-K" "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 "AE" 2178 2010 "ADAMS RESOURCES & ENERGY, INC." "10-K" "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 "AE" 2178 2011 "ADAMS RESOURCES & ENERGY, INC." "10-K" "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 "AE" 2178 2012 "ADAMS RESOURCES & ENERGY, INC." "10-K" "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 "AE" 2178 2013 "ADAMS RESOURCES & ENERGY, INC." "10-K" "17 S. BRIAR HOLLOW LN." "HOUSTON" "TX" "77027" 1 0 0 0 "AE" 2178 2014 "ADAMS RESOURCES & ENERGY, INC." "10-K" "17 S. BRIAR HOLLOW LN." "HOUSTON" "TX" "77027" 0 0 0 0 "AE" 2178 2015 "ADAMS RESOURCES & ENERGY, INC." "10-K" "17 S. BRIAR HOLLOW LN." "HOUSTON" "TX" "77027" 0 0 0 0 "AMD" 2488 2009 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "AMD" 2488 2010 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "AMD" 2488 2011 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "AMD" 2488 2012 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "AMD" 2488 2013 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "AMD" 2488 2014 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "AMD" 2488 2015 "ADVANCED MICRO DEVICES INC" "10-K" "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 "BYI" 2491 2009 "BALLY TECHNOLOGIES, INC." "10-K" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "BYI" 2491 2010 "BALLY TECHNOLOGIES, INC." "10-K" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "BYI" 2491 2011 "BALLY TECHNOLOGIES, INC." "10-K" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "BYI" 2491 2012 "BALLY TECHNOLOGIES, INC." "10-K" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "BYI" 2491 2013 "BALLY TECHNOLOGIES, INC." "10-K" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "BYI" 2491 2014 "BALLY TECHNOLOGIES, INC." "10-K/A" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "BYI" 2491 2014 "BALLY TECHNOLOGIES, INC." "10-K" "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 "APD" 2969 2009 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "APD" 2969 2010 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "APD" 2969 2011 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "APD" 2969 2012 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "APD" 2969 2013 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "APD" 2969 2014 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "APD" 2969 2015 "AIR PRODUCTS & CHEMICALS INC /DE/" "10-K" "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 "AKRX" 3116 2009 "AKORN INC" "10-K" "2500 MILLBROOK DRIVE" "BUFFALO GROVE" "IL" "60089" 1 1 0 1 "AKRX" 3116 2009 "AKORN INC" "10-K/A" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2010 "AKORN INC" "10-K" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 1 1 0 1 "AKRX" 3116 2011 "AKORN INC" "10-K" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2012 "AKORN INC" "10-K" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2013 "AKORN INC" "10-K" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2013 "AKORN INC" "10-K/A" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2014 "AKORN INC" "10-K" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2015 "AKORN INC" "10-K" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "AKRX" 3116 2015 "AKORN INC" "10-K/A" "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 "CECE" 3197 2009 "CECO ENVIRONMENTAL CORP" "10-K/A" "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 "CECE" 3197 2009 "CECO ENVIRONMENTAL CORP" "10-K" "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 "CECE" 3197 2010 "CECO ENVIRONMENTAL CORP" "10-K" "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 "CECE" 3197 2011 "CECO ENVIRONMENTAL CORP" "10-K" "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 "CECE" 3197 2012 "CECO ENVIRONMENTAL CORP" "10-K" "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 1 0 0 1 "CECE" 3197 2013 "CECO ENVIRONMENTAL CORP" "10-K" "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 0 0 0 0 "CECE" 3197 2014 "CECO ENVIRONMENTAL CORP" "10-K" "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 0 0 0 0 "CECE" 3197 2015 "CECO ENVIRONMENTAL CORP" "10-K" "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 0 0 0 0 "LNG" 3570 2009 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2010 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2011 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2012 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2012 "CHENIERE ENERGY INC" "10-K/A" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2013 "CHENIERE ENERGY INC" "10-K/A" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2013 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2014 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "LNG" 3570 2015 "CHENIERE ENERGY INC" "10-K" "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 "AYE" 3673 2009 "ALLEGHENY ENERGY, INC" "10-K" "800 CABIN HILL DRIVE" "GREENSBURG" "PA" "15601" 0 0 0 0 "AYE" 3673 2010 "ALLEGHENY ENERGY, INC" "10-K" "800 CABIN HILL DRIVE" "GREENSBURG" "PA" "15601" 0 0 0 0 "AYE" 3673 2011 "ALLEGHENY ENERGY, INC" "10-K" "800 CABIN HILL DRIVE" "GREENSBURG" "PA" "15601" 0 0 0 0 "SWKS" 4127 2009 "SKYWORKS SOLUTIONS INC" "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2009 "SKYWORKS SOLUTIONS INC" "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2010 "SKYWORKS SOLUTIONS INC" "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2010 "SKYWORKS SOLUTIONS INC" "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2011 "SKYWORKS SOLUTIONS, INC." "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2011 "SKYWORKS SOLUTIONS INC" "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2012 "SKYWORKS SOLUTIONS, INC." "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2012 "SKYWORKS SOLUTIONS, INC." "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2013 "SKYWORKS SOLUTIONS, INC." "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2013 "SKYWORKS SOLUTIONS, INC." "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2014 "SKYWORKS SOLUTIONS, INC." "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2014 "SKYWORKS SOLUTIONS, INC." "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2015 "SKYWORKS SOLUTIONS, INC." "10-K" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "SWKS" 4127 2015 "SKYWORKS SOLUTIONS, INC." "10-K/A" "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 "IDSA" 4187 2009 "INDUSTRIAL SERVICES OF AMERICA INC /FL" "10-K" "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 "IDSA" 4187 2010 "INDUSTRIAL SERVICES OF AMERICA INC /FL" "10-K" "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 "IDSA" 4187 2011 "INDUSTRIAL SERVICES OF AMERICA INC /FL" "10-K/A" "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 "IDSA" 4187 2011 "INDUSTRIAL SERVICES OF AMERICA INC /FL" "10-K" "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 "IDSA" 4187 2012 "INDUSTRIAL SERVICES OF AMERICA INC /FL" "10-K" "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 "IDSA" 4187 2013 "INDUSTRIAL SERVICES OF AMERICA INC /FL" "10-K/A" "7100 GRADE LN BUILDING 1" "LOUISVILLE" "KY" "40232" 1 0 0 0 end
0 Response to Dropping duplicated time vars conditional to changes of other variables
Post a Comment