I have a lot of duplicated values,
I have companies like this one, which the company had to do two ammendments in that year, and submit it to the sex (10-K/A).
"TREC" 7039 2011 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K/A" "1600 HWY 6 SOUTH, SUITE 240" "SUGAR LAND" "TX" 1
"TREC" 7039 2011 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K/A" "1600 HWY 6 SOUTH, SUITE 240" "SUGAR LAND" "TX" 1
So my question is, how can I get stata to select the newest oldest duplicate in one year and tell it to drop it? That would be, the first duplicate that appears here?
Thank you.
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 byte dup "SSI" 6885 2009 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "SSI" 6885 2010 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "SSI" 6885 2011 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "SSI" 6885 2012 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "SSI" 6885 2013 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "SSI" 6885 2014 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "SSI" 6885 2015 "STAGE STORES INC" "10-K" "10201 MAIN ST" "HOUSTON" "TX" 0 "AMAT" 6951 2009 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2009 "APPLIED MATERIALS INC /DE" "10-K/A" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2010 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2011 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2012 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2013 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2014 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "AMAT" 6951 2015 "APPLIED MATERIALS INC /DE" "10-K" "3050 BOWERS AVE" "SANTA CLARA" "CA" 0 "ATU" 6955 2009 "ACTUANT CORP" "10-K" "ATTN: CHAD DELUKA" "BUTLER" "WI" 0 "ATU" 6955 2010 "ACTUANT CORP" "10-K" "ATTN: MATT PAULI" "BUTLER" "WI" 0 "ATU" 6955 2011 "ACTUANT CORP" "10-K" "ATTN: MATT PAULI" "MENOMONEE FALLS" "WI" 0 "ATU" 6955 2012 "ACTUANT CORP" "10-K" "ATTN: MATT PAULI" "MENOMONEE FALLS" "WI" 0 "ATU" 6955 2013 "ACTUANT CORP" "10-K" "ATTN: MATT PAULI" "MENOMONEE FALLS" "WI" 0 "ATU" 6955 2014 "ACTUANT CORP" "10-K" "ATTN: MATT PAULI" "MENOMONEE FALLS" "WI" 0 "ATU" 6955 2015 "ACTUANT CORP" "10-K" "ATTN: MATT PAULI" "MENOMONEE FALLS" "WI" 0 "TREC" 7039 2009 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K" "10830 N CENTRAL EXPRWY STE 175" "DALLAS" "TX" 0 "TREC" 7039 2010 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K" "7752 FM 418" "SILSBEE" "TX" 0 "TREC" 7039 2011 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K" "1600 HWY 6 SOUTH, SUITE 240" "SUGAR LAND" "TX" 0 "TREC" 7039 2011 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K/A" "1600 HWY 6 SOUTH, SUITE 240" "SUGAR LAND" "TX" 1 "TREC" 7039 2011 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K/A" "1600 HWY 6 SOUTH, SUITE 240" "SUGAR LAND" "TX" 1 "TREC" 7039 2012 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K" "1600 HWY 6 SOUTH, SUITE 240" "SUGAR LAND" "TX" 0 "TREC" 7039 2013 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K/A" "1650 HWY 6 SOUTH, SUITE 190" "SUGAR LAND" "TX" 1 "TREC" 7039 2013 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K/A" "1650 HWY 6 SOUTH, SUITE 190" "SUGAR LAND" "TX" 1 "TREC" 7039 2013 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K" "1650 HWY 6 SOUTH, SUITE 190" "SUGAR LAND" "TX" 0 "TREC" 7039 2014 "ARABIAN AMERICAN DEVELOPMENT CO" "10-K" "1650 HWY 6 SOUTH, SUITE 190" "SUGAR LAND" "TX" 0 "TREC" 7039 2015 "TRECORA RESOURCES" "10-K" "1650 HWY 6 SOUTH, SUITE 190" "SUGAR LAND" "TX" 0 "ADM" 7084 2009 "ARCHER DANIELS MIDLAND CO" "10-K" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2010 "ARCHER DANIELS MIDLAND CO" "10-K" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2011 "ARCHER DANIELS MIDLAND CO" "10-K" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2011 "ARCHER DANIELS MIDLAND CO" "10-K/A" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2012 "ARCHER DANIELS MIDLAND CO" "10-K" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2013 "ARCHER DANIELS MIDLAND CO" "10-KT" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2014 "ARCHER DANIELS MIDLAND CO" "10-K" "4666 FARIES PKWY" "DECATUR" "IL" 0 "ADM" 7084 2015 "ARCHER DANIELS MIDLAND CO" "10-K" "4666 FARIES PKWY" "DECATUR" "IL" 0 "SWN" 7332 2009 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2010 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2011 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2011 "SOUTHWESTERN ENERGY CO" "10-K/A" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2012 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2013 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2014 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "SWN" 7332 2015 "SOUTHWESTERN ENERGY CO" "10-K" "2350 N. SAM HOUSTON PARKWAY EAST" "HOUSTON" "TX" 0 "ARW" 7536 2009 "ARROW ELECTRONICS INC" "10-K" "25 HUB DR" "MELVILLE" "NY" 0 "ARW" 7536 2010 "ARROW ELECTRONICS INC" "10-K" "25 HUB DR" "MELVILLE" "NY" 0 "ARW" 7536 2011 "ARROW ELECTRONICS INC" "10-K" "25 HUB DR" "MELVILLE" "NY" 0 "ARW" 7536 2012 "ARROW ELECTRONICS INC" "10-K" "25 HUB DR" "MELVILLE" "NY" 0 "ARW" 7536 2013 "ARROW ELECTRONICS INC" "10-K" "25 HUB DR" "MELVILLE" "NY" 0 "ARW" 7536 2014 "ARROW ELECTRONICS INC" "10-K" "25 HUB DR" "MELVILLE" "NY" 0 "ARW" 7536 2015 "ARROW ELECTRONICS INC" "10-K" "9201 EAST DRY CREEK ROAD" "CENTENNIAL" "CO" 0 "ATRO" 8063 2009 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2010 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2011 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2012 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2013 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2014 "ASTRONICS CORP" "10-K/A" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2014 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ATRO" 8063 2015 "ASTRONICS CORP" "10-K" "130 COMMERCE WAY" "EAST AURORA" "NY" 0 "ADP" 8670 2009 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "ADP" 8670 2010 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "ADP" 8670 2011 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "ADP" 8670 2012 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "ADP" 8670 2013 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "ADP" 8670 2014 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "ADP" 8670 2015 "AUTOMATIC DATA PROCESSING INC" "10-K" "ONE ADP BOULVARD" "ROSELAND" "NJ" 0 "AVY" 8818 2009 "AVERY DENNISON CORPORATION" "10-K" "150 N ORANGE GROVE BLVD" "PASADENA" "CA" 0 "AVY" 8818 2010 "AVERY DENNISON CORPORATION" "10-K" "150 N ORANGE GROVE BLVD" "PASADENA" "CA" 0 "AVY" 8818 2011 "AVERY DENNISON CORPORATION" "10-K" "150 N ORANGE GROVE BLVD" "PASADENA" "CA" 0 "AVY" 8818 2012 "Avery Dennison Corp" "10-K" "150 N ORANGE GROVE BLVD" "PASADENA" "CA" 0 "AVY" 8818 2013 "Avery Dennison Corp" "10-K" "150 N ORANGE GROVE BLVD" "PASADENA" "CA" 0 "AVY" 8818 2014 "Avery Dennison Corp" "10-K" "207 GOODE AVENUE" "GLENDALE" "CA" 0 "AVY" 8818 2015 "Avery Dennison Corp" "10-K" "207 GOODE AVENUE" "GLENDALE" "CA" 0 "AVT" 8858 2009 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2010 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2011 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2011 "AVNET INC" "10-K/A" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2012 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2013 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2014 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVT" 8858 2015 "AVNET INC" "10-K" "2211 SOUTH 47TH STREET" "PHOENIX" "AZ" 0 "AVP" 8868 2009 "AVON PRODUCTS INC" "10-K" "1345 AVENUE OF THE AMERICAS" "NEW YORK" "NY" 0 "AVP" 8868 2010 "AVON PRODUCTS INC" "10-K" "1345 AVENUE OF THE AMERICAS" "NEW YORK" "NY" 0 "AVP" 8868 2011 "AVON PRODUCTS INC" "10-K" "1345 AVENUE OF THE AMERICAS" "NEW YORK" "NY" 0 "AVP" 8868 2012 "AVON PRODUCTS INC" "10-K" "1345 AVENUE OF THE AMERICAS" "NEW YORK" "NY" 0 "AVP" 8868 2013 "AVON PRODUCTS INC" "10-K/A" "1345 AVENUE OF THE AMERICAS" "NEW YORK" "NY" 0 "AVP" 8868 2013 "AVON PRODUCTS INC" "10-K" "1345 AVENUE OF THE AMERICAS" "NEW YORK" "NY" 0 "AVP" 8868 2014 "AVON PRODUCTS INC" "10-K" "777 THIRD AVENUE" "NEW YORK" "NY" 0 "AVP" 8868 2015 "AVON PRODUCTS INC" "10-K" "777 THIRD AVENUE" "NEW YORK" "NY" 0 "AZZ" 8947 2009 "AZZ INC" "10-K" "ONE MUSEUM PLACE, SUITE 500" "FORT WORTH" "TX" 0 "AZZ" 8947 2009 "AZZ INC" "10-K/A" "ONE MUSEUM PLACE, SUITE 500" "FORT WORTH" "TX" 0 "AZZ" 8947 2010 "AZZ INC" "10-K" "ONE MUSEUM PLACE, SUITE 500" "FORT WORTH" "TX" 0 "AZZ" 8947 2011 "AZZ INC" "10-K" "ONE MUSEUM PLACE, SUITE 500" "FORT WORTH" "TX" 0 "AZZ" 8947 2011 "AZZ INC" "10-K/A" "ONE MUSEUM PLACE, SUITE 500" "FORT WORTH" "TX" 0 "AZZ" 8947 2012 "AZZ INC" "10-K" "ONE MUSEUM PLACE, SUITE 500" "FORT WORTH" "TX" 0 end
0 Response to Duplicates Help
Post a Comment