Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    MATCHIT- Stata for data consolidation and cleaning using fuzzy string comparisons

    Hello,

    I came across your matchit command in Stata for data consolidation and cleaning using fuzzy string comparisons. I would like to use it for matching EU-ETS installations (ID) and emission details (ED) of such installations. ID contains location and ED contains emissions from such installations. Both the ID and ED file contains unique identification code PERMIT_ID. The problem is there are more than 15,000 entries for ID and more than 12,000 entries for ED, I want to match both the files and find the locations for installations in the ED file, I know the only way is to use by PERMIT_ID, but I cannot figure out the command. . I have checked in excel both the files have more than 10,000 common entries. I also do not want to discard the extra 2,000 in the ED file.

    The columns look as below. I would really appreciate if you can suggest me a way.


    ED file:
    INSTALLATION_NAME PERMIT_ID 2019 2018 2017
    Baumit Baustoffe Bad Ischl IKA119 46415 42302 48681
    Breitenfelder Edelstahl Mitterdorf IES069 26777 23457 21031
    Ziegelwerk Danreiter Ried im Innkreis IZI155 5129 3738 3487
    Isomax Dekorative Laminate Wiener Neudorf ICH113 33020 30922 30088
    Sandoz Werk Kundl ICH106 57869 58011 65993
    Ziegelwerk Martin Pichler Aschach IZI150 14202 14040 8852
    FHKW Süd StW St. Pölten EFE041 1476 3060 3687
    FHKW Nord StW St. Pölten EFE040 31973 32342 31624
    Vetropack Pöchlarn IGL173 59982 59513 58286
    Vetropack Kremsmünster IGL172 68178 61631 66001
    Sinteranl., Hochöfen, Stahlwerk Donawitz IVA065 2846643 2923552 3075201
    Voestalpine Stahl Linz IVA062 8812969 7816077 9220971
    VOEST-Alpine Stahl Linz (Kalk) Steyrling IKA120 303621 274486 346279

    ID file:
    Installation Name Permit_ID NUTS_ID
    Baumit Baustoffe Bad Ischl IKA119 AT31
    Breitenfelder Edelstahl Mitterdorf IES069 AT22
    Ziegelwerk Danreiter Ried im Innkreis IZI155 AT31
    Wienerberger Blindenmarkt IZI146-1 AT12
    Isomax Dekorative Laminate Wiener Neudorf ICH113 AT12
    Sandoz Werk Kundl ICH106 AT33
    Ziegelwerk Martin Pichler Aschach IZI150 AT31
    FHKW Süd StW St. Pölten EFE041 AT12
    FHKW Nord StW St. Pölten EFE040 AT12
    Vetropack Pöchlarn IGL173 AT12
    Vetropack Kremsmünster IGL172 AT31
    Energiepark Donawitz IVA066 AT22
    Sinteranl., Hochöfen, Stahlwerk Donawitz IVA065 AT22


    Thanks
    Last edited by saptorshee chakraborty; 30 Mar 2021, 18:45.
    Tags: None
  • #2
    Have you tried this?
    Code:
    use ED, clear
merge 1:1 PERMIT_ID using ID
    If that does not solve your problem, when posting back, please provide example data from both data sets. Note that the examples must come from your Stata data sets, not from Excel. And to make them usable to anyone who might want to help you, you must use the -dataex- command to post the example data here. f you are running version 16 or a fully updated version 15.1 or 14.2, -dataex- is already part of your official Stata installation. If not, run -ssc install dataex- to get it. Either way, run -help dataex- to read the simple instructions for using it. -dataex- will save you time; it is easier and quicker than typing out tables. It includes complete information about aspects of the data that are often critical to answering your question but cannot be seen from tabular displays or screenshots. It also makes it possible for those who want to help you to create a faithful representation of your example to try out their code, which in turn makes it more likely that their answer will actually work in your data.

    In choosing the example data from the two data sets, be sure to include at least some observations in each of the data sets that will match to something in the other.

    As far as I can see, there is no need for fuzzy matching here. It looks, at least so far, like everything can be -merged- exactly on the PERMIT_ID variable.

    Comment

    • #3
      Hello,

      Thank you very much, it did not work by the previous code, the error I received: variable PERMIT_ID does not uniquely identify observations in the master data


      I am pasting the dataex for both files

      file id:

      Code:
      * Example generated by -dataex-. To install: ssc install dataex
clear
input int CODE str101 AccountHolderName double InstallationID str90 InstallationName str63 ActivityType str36 PERMIT_ID str7 PermitStatus str2 ContactCountry str13 Country str7 NUTS_ID
  1 `""BAUMIT" Baustoffe Gesellschaft m.b.H."'                  1 "Baumit Baustoffe Bad Ischl"                  "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IKA119"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
  2 "Breitenfeld Edelstahl AG"                                  2 "Breitenfelder Edelstahl Mitterdorf"          "PRODUCTION_PIG_IRON_STEEL_CONT_CASTING_INSTALLATIONS" "IES069"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
  3 "Ziegelwerk Danreiter GmbH & Co KG"                         3 "Ziegelwerk Danreiter Ried im Innkreis"       "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI155"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
  4 "Wienerberger Ziegelindustrie GmbH"                         4 "Wienerberger Blindenmarkt"                   "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI146-1" "ACTIVE"  "AT" "AUSTRIA" "AT12"
  5 "FunderMax GmbH"                                            5 "Isomax Dekorative Laminate Wiener Neudorf"   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ICH113"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
  6 "SANDOZ GmbH"                                               6 "Sandoz Werk Kundl"                           "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ICH106"   "ACTIVE"  "AT" "AUSTRIA" "AT33"
  7 "Martin Pichler Ziegelwerk GmbH."                           7 "Ziegelwerk Martin Pichler Aschach"           "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI150"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
  8 "Fernwärme St. Pölten GmbH"                               8 "FHKW Süd StW St. Pölten"                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE041"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
  9 "Fernwärme St. Pölten GmbH"                               9 "FHKW Nord StW St. Pölten"                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE040"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 10 "Vetropack Austria GmbH"                                   10 "Vetropack Pöchlarn"                         "MANUFACTURE_OF_GLASS_INCLUDING_GLASS_FIBRE"           "IGL173"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 11 "Vetropack Austria GmbH"                                   11 "Vetropack Kremsmünster"                     "MANUFACTURE_OF_GLASS_INCLUDING_GLASS_FIBRE"           "IGL172"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 12 "voestalpine Stahl Donawitz GmbH"                          12 "Energiepark Donawitz"                        "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IVA066"   "REVOKED" "AT" "AUSTRIA" "AT22"
 13 "voestalpine Stahl Donawitz GmbH"                          13 "Sinteranl., Hochöfen, Stahlwerk Donawitz"   "PRODUCTION_OF_PIG_IRON_OR_STEEL"                      "IVA065"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 14 "voestalpine Stahl GmbH"                                   14 "Voestalpine Kokerei Linz"                    "PRODUCTION_OF_COKE"                                   "IVA063"   "REVOKED" "AT" "AUSTRIA" "AT31"
 15 "voestalpine Stahl GmbH"                                   15 "Voestalpine Kraftwerk Linz"                  "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IVA064"   "REVOKED" "AT" "AUSTRIA" "AT31"
 16 "voestalpine Stahl GmbH"                                   16 "Voestalpine Stahl Linz"                      "PRODUCTION_OF_PIG_IRON_OR_STEEL"                      "IVA062"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 17 "voestalpine Stahl GmbH"                                   17 "VOEST-Alpine Stahl Linz (Kalk) Steyrling"    "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IKA120"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 18 "WIEN ENERGIE GmbH"                                        18 "FHKW Süd Inzersdorf"                        "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE043"   "ACTIVE"  "AT" "AUSTRIA" "AT13"
 19 "WIEN ENERGIE GmbH"                                        19 "FHKW Kagran Fernwärme Wien"                 "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE044"   "ACTIVE"  "AT" "AUSTRIA" "AT13"
 20 "WIEN ENERGIE GmbH"                                        20 "FW Leopoldau Fernwärme Wien"                "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE045"   "ACTIVE"  "AT" "AUSTRIA" "AT13"
 21 "WIEN ENERGIE GmbH"                                        21 "FHKW Arsenal Fernwärme Wien"                "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE046"   "ACTIVE"  "AT" "AUSTRIA" "AT13"
 22 "Ziegelwerk Pichler Wels Gesellschaft m.b.H."              22 "Ziegelwerk Pichler Wels"                     "MANUFACTURE_OF_CERAMIC_PRODUCTS"                      "IZI145"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 23 "Wopfinger Baustoffindustrie GmbH"                         23 "Wopfinger Baustoffindustrie Waldegg"         "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IKA121"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 24 "Wopfinger Baustoffindustrie GmbH"                         24 "Wopfinger Zement Waldegg"                    "PRODUCTION_OF_CEMENT_CLINKER"                         "IZE202"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 25 "Borealis Agrolinz Melamine GmbH"                          25 "AMI Agrolinz Melamine International Linz"    "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ICH114"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 26 "OMV Refining & Marketing GmbH"                            26 "Raffinerie Schwechat"                        "REFINING_OF_MINERAL_OIL"                              "EMV061"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 27 "OMV Austria Exploration & Production GmbH"                27 "OMV Gasstation Aderklaa II"                  "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EMV059"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 28 "OMV Austria Exploration & Production GmbH"                28 "OMV Gasstation Aderklaa I"                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EMV060"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 29 "Weindl Gesellschaft m.b.H."                               29 "Ziegelwerk Weindl Steyr"                     "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI160"   "REVOKED" "AT" "AUSTRIA" "AT31"
 30 "Ziegelwerk Lizzi GmbH"                                    30 "Ziegelwerk Lizzi Erlach"                     "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI152"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 31 "Zementwerk Hatschek GmbH"                                 31 "Gmundner Zement Gmunden"                     "PRODUCTION_OF_CEMENT_CLINKER"                         "IZE077"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 32 "Salzburg AG für Energie, Verkehr und Telekommunikation"  32 "Salzburg AG FHKW Mitte Salzburg"             "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW024"   "ACTIVE"  "AT" "AUSTRIA" "AT32"
 33 "Salzburg AG für Energie, Verkehr und Telekommunikation"  33 "Salzburg AG FHKW Nord Salzburg"              "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW025"   "ACTIVE"  "AT" "AUSTRIA" "AT32"
 34 "Salzburg AG für Energie, Verkehr und Telekommunikation"  34 "Salzburg AG FHKW West Salzburg"              "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "EEW26-1"  "ACTIVE"  "AT" "AUSTRIA" "AT32"
 35 "Salzburg AG für Energie, Verkehr und Telekommunikation"  35 "Salzburg AG HW Süd Salzburg"                "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "EFE035"   "REVOKED" "AT" "AUSTRIA" "AT32"
 36 "Salzburg AG für Energie, Verkehr und Telekommunikation"  36 "Salzburg AG LKH Salzburg"                    "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "EFE049"   "ACTIVE"  "AT" "AUSTRIA" "AT32"
 37 "F.M. Hämmerle Textil Produktion und Vertrieb GmbH"       37 "F.M. Hämmerle Dornbirn"                     "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "ICH203"   "ACTIVE"  "AT" "AUSTRIA" "AT34"
 38 "Stadtwerke Klagenfurt AG"                                 38 "FHKW Klagenfurt Stadtwerke Klagenfurt"       "PRODUCTION_OF_BULK_ORGANIC_CHEMICALS"                 "EFE027"   "ACTIVE"  "AT" "AUSTRIA" "AT21"
 39 "Energie Klagenfurt GmbH"                                  39 "Stw Heizwerk Süd Klagenfurt"                "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE057"   "ACTIVE"  "AT" "AUSTRIA" "AT21"
 40 "Ziegelwerk Eberschwang Gesellschaft m.b.H."               40 "Ziegelwerk Eberschwang"                      "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI158"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 41 "AMAG Service GmbH"                                        41 "AMAG Service Ranshofen"                      "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IMS193"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 42 "Ernstbrunner Kalktechnik GmbH"                            42 "Ernstbrunner Kalktechnik Ernstbrunn"         "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IKA118"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 43 "LINZ STROM GmbH"                                          43 "LS FHKW Mitte Linz Linie 1a"                 "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW021"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 44 "LINZ STROM GmbH"                                          44 "LS FHKW Mitte Linz Linie 1b"                 "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "EEW022"   "REVOKED" "AT" "AUSTRIA" "AT31"
 45 "LINZ STROM GmbH"                                          45 "FHKW Dornach Linz AG Linz"                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE036"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 46 "LINZ STROM GmbH"                                          46 "LS FHKW Süd Linz"                           "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW023"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 47 "AGRANA Stärke GmbH"                                      47 "AGRANA Gmünd"                               "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ILE166"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 48 "AGRANA Zucker GmbH"                                       48 "AGRANA Leopoldsdorf"                         "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ILE163"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 49 "AGRANA Zucker GmbH"                                       49 "AGRANA Hohenau"                              "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "ILE162"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 50 "AGRANA Stärke GmbH"                                      50 "AGRANA Aschach"                              "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ILE165"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 51 "AGRANA Zucker GmbH"                                       51 "AGRANA Tulln"                                "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ILE161"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 52 "Ziegelwerk Eder GmbH & Co.KG."                            52 "Ziegelwerk Eder Peuerbach Bruck"             "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI143"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 53 "Dynea Austria GmbH"                                       53 "Dynea Krems"                                 "PRODUCTION_OF_BULK_ORGANIC_CHEMICALS"                 "ICH108"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 54 "Ziegelwerk Eder GmbH & Co.KG."                            54 "Ziegelwerk Eder Weibern"                     "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI144"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 55 "w&p Zement GmbH"                                          55 "Wietersdorfer & Peggauer Zement Wietersdorf" "PRODUCTION_OF_CEMENT_CLINKER"                         "IZE076"   "ACTIVE"  "AT" "AUSTRIA" "AT21"
 56 "w&p Zement GmbH"                                          56 "Wietersdorfer & Peggauer Zement Peggau"      "PRODUCTION_OF_CEMENT_CLINKER"                         "IZE075"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 57 "w&p Kalk GmbH"                                            57 "Wietersdorfer & Peggauer (Kalk) Peggau"      "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IKA122"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 58 "Steirische Gas-Wärme GmbH"                               58 "FWZ Voitsberg"                               "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE048"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 59 "DSM Fine Chemicals Austria Nfg GmbH & CoKG"               59 "DSM Fine Chemicals Austria Linz"             "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ICH112"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 60 "Steirische Gas-Wärme GmbH"                               60 "FHKW Graz"                                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE037"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 61 "Lafarge Zementwerke GmbH"                                 61 "Lafarge Perlmooser Retznei"                  "PRODUCTION_OF_CEMENT_CLINKER"                         "IZE073"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 62 "Constantia Teich GmbH"                                    62 "TEICH AG Weinburg"                           "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IMS199"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 63 "Lafarge Zementwerke GmbH"                                 63 "Lafarge Perlmooser Mannersdorf"              "PRODUCTION_OF_CEMENT_CLINKER"                         "IZE072"   "ACTIVE"  "AT" "AUSTRIA" "AT12"
 64 "D. Swarovski KG"                                          64 "Swarovski Wattens"                           "MANUFACTURE_OF_GLASS_INCLUDING_GLASS_FIBRE"           "IGL179"   "ACTIVE"  "AT" "AUSTRIA" "AT33"
 65 "Tondach Gleinstätten AG"                                 65 "Tondach Gleinstätten"                       "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI131"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 66 "Tondach Gleinstätten AG"                                 66 "Tondach Pinkafeld"                           "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI139"   "ACTIVE"  "AT" "AUSTRIA" "AT11"
 67 "Tondach Gleinstätten AG"                                 67 "Tondach Unterpremstätten"                   "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI135"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 68 "Semperit Reifen Gesellschaft m.b.H."                      68 "Semperit Reifen Traiskirchen"                "COMBUSTION_INSTALLATIONS_THERMAL_MORE_TWENTY_MW"      "ICH111-1" "ACTIVE"  "AT" "AUSTRIA" "AT12"
 69 "M. Kaindl KG"                                             69 "Kaindl Holzindustrie Wals"                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IHO192"   "ACTIVE"  "AT" "AUSTRIA" "AT32"
 70 "Ziegelei Hilti, Mettauer GmbH"                            70 "Hilti Mettauer Götzis"                      "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IZI147"   "ACTIVE"  "AT" "AUSTRIA" "AT34"
 71 "Solvay Österreich GmbH"                                  71 "Solvay Ebensee"                              "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "ICH110"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 72 "Veitsch-Radex GmbH & Co OG"                               72 "Veitsch-Radex Hochfilzen"                    "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IFE126"   "ACTIVE"  "AT" "AUSTRIA" "AT33"
 73 "Veitsch-Radex GmbH & Co OG"                               73 "Veitsch-Radex Radenthein"                    "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IFE125"   "ACTIVE"  "AT" "AUSTRIA" "AT21"
 74 "Veitsch-Radex GmbH & Co OG"                               74 "Veitsch-Radex Trieben"                       "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IFE127"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 75 "Veitsch-Radex GmbH & Co OG"                               75 "Veitsch-Radex Veitsch"                       "PRODUCTION_CERAMICS_BRICKS_PORCELAIN_INSTALLATIONS"   "IFE128"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 76 "Energie AG Oberösterreich"                               76 "KW Timelkam III"                             "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW003"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 77 "Veitsch-Radex GmbH & Co OG"                               77 "Veitsch-Radex Breitenau"                     "PRODUCTION_OF_LIME_OR_CALCINATION_"                   "IFE130"   "ACTIVE"  "AT" "AUSTRIA" "AT22"
 78 "Energie AG Oberösterreich Wärme GmbH"                   78 "FW Kirchdorf"                                "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EFE017"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 79 "Energie AG Oberösterreich"                               79 "KW Riedersbach"                              "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW001"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 80 "Energie AG Oberösterreich"                               80 "KW Timelkam II"                              "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "EEW002"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 81 "Energie-Contracting Steyr GmbH"                           81 "Energie-Contracting Steyr"                   "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IMS200"   "ACTIVE"  "AT" "AUSTRIA" "AT31"
 82 "Papierfabrik Wattens GmbH & Co KG"                        82 "Papierfabrik Wattens"                        "PRODUCTION_OF_PAPER_OR_CARDBOARD"                     "IPA079"   "ACTIVE"  "AT" "AUSTRIA" "AT33"
 83 "Cogeneration-Kraftwerke Management Oberösterreich GmbH"  83 "CMOÖ GuD Anlage Laakirchen"                 "COMBUSTION_OF_FUELS_IN_INSTALLATIONS"                 "IPA102"   "ACTIVE"  "AT" "AUSTRIA" "AT31"

end


      file ed:

      Code:
      * Example generated by -dataex-. To install: ssc install dataex
clear
input str32 PERMIT_ID str94 INSTALLATION_NAME byte MAIN_ACTIVITY_TYPE_CODE str8(y2019 y2018    y2017)
"IKA119" "Baumit Baustoffe Bad Ischl"                  30 "46415"   "42302"   "48681"  
"IES069" "Breitenfelder Edelstahl Mitterdorf"          24 "26777"   "23457"   "21031"  
"IZI155" "Ziegelwerk Danreiter Ried im Innkreis"       32 "5129"    "3738"    "3487"   
"ICH113" "Isomax Dekorative Laminate Wiener Neudorf"   20 "33020"   "30922"   "30088"  
"ICH106" "Sandoz Werk Kundl"                           20 "57869"   "58011"   "65993"  
"IZI150" "Ziegelwerk Martin Pichler Aschach"           32 "14202"   "14040"   "8852"   
"EFE041" "FHKW Süd StW St. Pölten"                   20 "1476"    "3060"    "3687"   
"EFE040" "FHKW Nord StW St. Pölten"                   20 "31973"   "32342"   "31624"  
"IGL173" "Vetropack Pöchlarn"                         31 "59982"   "59513"   "58286"  
"IGL172" "Vetropack Kremsmünster"                     31 "68178"   "61631"   "66001"  
"IVA065" "Sinteranl., Hochöfen, Stahlwerk Donawitz"   24 "2846643" "2923552" "3075201"
"IVA062" "Voestalpine Stahl Linz"                      24 "8812969" "7816077" "9220971"
"IKA120" "VOEST-Alpine Stahl Linz (Kalk) Steyrling"    30 "303621"  "274486"  "346279" 
"EFE043" "FHKW Süd Inzersdorf"                        20 "16272"   "36272"   "48176"  
"EFE044" "FHKW Kagran Fernwärme Wien"                 20 "2"       "1"       "1"      
"EFE045" "FW Leopoldau Fernwärme Wien"                20 "19078"   "25652"   "39888"  
"EFE046" "FHKW Arsenal Fernwärme Wien"                20 "-1"      "-1"      "-1"     
"IZI145" "Ziegelwerk Pichler Wels"                     32 "20309"   "19873"   "18478"  
"IKA121" "Kalkwerk Wopfing"                            30 "138751"  "132986"  "109861" 
"IZE202" "Zementwerk Wopfing"                          29 "291278"  "290522"  "280216" 
"ICH114" "AMI Agrolinz Melamine International Linz"    20 "60724"   "56227"   "56679"  
"EMV061" "Raffinerie Schwechat"                        21 "2791040" "2824369" "2738604"
"EMV059" "OMV Gasstation Aderklaa II"                  20 "14940"   "7126"    "15839"  
"EMV060" "OMV Gasstation Aderklaa I"                   20 "40932"   "38114"   "36115"  
"IZI152" "Ziegelwerk Lizzi Erlach"                     32 "1877"    "1492"    "706"    
"IZE077" "Gmundner Zement Gmunden"                     29 "253322"  "328580"  "367391" 
"EEW024" "Salzburg AG FHKW Mitte Salzburg"             20 "156799"  "146926"  "171771" 
"EEW025" "Salzburg AG FHKW Nord Salzburg"              20 "37945"   "35697"   "39436"  
"EFE027" "FHKW Klagenfurt Stadtwerke Klagenfurt"       20 "6553"    "18668"   "45330"  
"EFE057" "Stw Heizwerk Süd Klagenfurt"                20 "3"       "2"       "270"    
"IZI158" "Ziegelwerk Eberschwang"                      32 "0"       "0"       "0"      
"IMS193" "AMAG Service Ranshofen"                      20 "5231"    "5645"    "6783"   
"IKA118" "Ernstbrunner Kalktechnik Ernstbrunn"         30 "22549"   "22541"   "26945"  
"EEW021" "LS FHKW Mitte Linz Linie 1a"                 20 "234327"  "220941"  "247104" 
"EFE036" "FHKW Dornach Linz AG Linz"                   20 "0"       "0"       "7"      
"EEW023" "LS FHKW Süd Linz"                           20 "139736"  "118548"  "123061" 
"ILE166" "AGRANA Gmünd"                               20 "39942"   "40089"   "39282"  
"ILE163" "AGRANA Leopoldsdorf"                         20 "45890"   "53318"   "74543"  
"ILE165" "AGRANA Aschach"                              20 "69660"   "83757"   "84100"  
"ILE161" "AGRANA Tulln"                                20 "64788"   "69086"   "88764"  
"IZI143" "Ziegelwerk Eder Peuerbach Bruck"             32 "18202"   "16095"   "20037"  
"ICH108" "Dynea Krems"                                 42 "20111"   "20139"   "20052"  
"IZI144" "Ziegelwerk Eder Weibern"                     32 "14906"   "13930"   "13643"  
"IZE076" "Wietersdorfer & Peggauer Zement Wietersdorf" 29 "468704"  "449914"  "409718" 
"IZE075" "Wietersdorfer & Peggauer Zement Peggau"      29 "0"       "0"       "0"      
"IKA122" "Wietersdorfer & Peggauer (Kalk) Peggau"      30 "91459"   "89528"   "84544"  
"EFE048" "FWZ Voitsberg"                               20 "9926"    "11891"   "12376"  
"ICH112" "DSM Fine Chemicals Austria Linz"             20 "9459"    "8695"    "9051"   
"EFE037" "FHKW Graz"                                   20 "37936"   "34104"   "45450"  
"IZE073" "Lafarge Perlmooser Retznei"                  29 "300968"  "326094"  "323694" 
"IMS199" "TEICH AG Weinburg"                           20 "28352"   "25242"   "27305"  
"IZE072" "Lafarge Perlmooser Mannersdorf"              29 "610139"  "601756"  "539340" 
"IGL179" "Swarovski Wattens"                           31 "8605"    "8671"    "8928"   
"IZI131" "Tondach Gleinstätten"                       32 "23827"   "22018"   "23338"  
"IZI139" "Tondach Pinkafeld"                           32 "9678"    "9443"    "8034"   
"IZI135" "Tondach Unterpremstätten"                   32 "-1"      "-1"      "-1"     
"IHO192" "Kaindl Holzindustrie Wals"                   20 "18432"   "20301"   "19581"  
"ICH110" "Solvay Ebensee"                              20 "2126"    "12324"   "12129"  
"IFE126" "Veitsch-Radex Hochfilzen"                    30 "119859"  "180987"  "167489" 
"IFE125" "Veitsch-Radex Radenthein"                    32 "76311"   "77453"   "73649"  
"IFE127" "Veitsch-Radex Trieben"                       32 "17959"   "23683"   "18448"  
"IFE128" "Veitsch-Radex Veitsch"                       32 "12505"   "12001"   "12255"  
"EEW003" "KW Timelkam III"                             20 "0"       "0"       "0"      
"IFE130" "Veitsch-Radex Breitenau"                     30 "227618"  "271930"  "256444" 
"EFE017" "FW Kirchdorf"                                20 "15180"   "16311"   "15190"  
"EEW001" "KW Riedersbach"                              20 "6660"    "6576"    "7775"   
"EEW002" "KW Timelkam II"                              20 "4240"    "7118"    "5887"   
"IMS200" "Energie-Contracting Steyr"                   20 "9360"    "8447"    "9347"   
"IPA079" "Papierfabrik Wattens"                        36 "21151"   "26805"   "25034"  
"IPA102" "CMOÖ GuD Anlage Laakirchen"                 20 "214667"  "180671"  "137915" 
"EEW031" "Wienstrom KW Simmering Wien"                 20 "386451"  "541419"  "651666" 
"EEW030" "Wienstrom KW Donaustadt Wien"                20 "640791"  "630614"  "409794" 
"EEW029" "Wienstrom KW Leopoldau Wien"                 20 "1076"    "6300"    "3825"   
"IPA090" "Nettingsdorfer Ansfelden"                    36 "56979"   "58292"   "57843"  
"IZI156" "Ziegelwerk Frixeder Senftenbach"             32 "13716"   "12833"   "12015"  
"EFE047" "Stadtwerke Kufstein"                         20 "1957"    "1527"    "1314"   
"EFE058" "Stadtwärme Lienz"                           20 "348"     "233"     "404"    
"IZE074" "Zementwerk Hofmann Kirchdorf"                29 "233084"  "234800"  "189999" 
"EEW007" "Verbund KW Dürnrohr Zwentendorf"            20 "-1"      "0"       "0"      
"EEW009" "Verbund FHKW Mellach"                        20 "706836"  "742168"  "809346" 

end


      Thanks.

      Comment

      • #4
        Well, the example data you show does not produce that error. They merge properly.

        The error message you are getting says that the same PERMIT_ID can appear more than once in the ed file. The question is why. This may be perfectly appropriate: perhaps the same permit ID can cover multiple installations. Or perhaps there are just extraneous duplicate observations in the ed file, or data errors. So I suggest you start by running:

        Code:
        use ed, clear
duplicates tag PERMIT_ID, gen(flag)
browse if flag
        to see what's going on. If there are errors, or extraneous duplicates, fix those problems and then try again.

        If it is correct that a single permit ID can legitimately cover multiple installations, then we have a different issue. In that case we need to try to merge on the combination of PERMIT_ID and InstallationName. (Note, in the example data you show, one data set calls it INSTALLATION_NAME and the other calls it InstallationName. You will need to harmonize those variable names first.) Then you can try
        Code:
        use ed, clear
rename INSTALLATION_NAME InstallationName
merge 1:1 PERMIT_ID InstallationName using id
        Then you will have to assess whether this has solved your problem or not. I notice that in your two data sets there are two instances of an ID appearing in both data sets, but with a different InstallationName in each. IKA121 is associated with Kalwerk Wopfing in ed, but with Wopfinger Baustoffindustrie Waldegg in id; IZE202 is associated with Zementwerk Wopfing in ed, but Wopfinger Zemend Waldegg in id. You will have to judge whether these are instances of truly separate installations whose data do not belong together (hence the -merge- is correct as is) or whether the alternate names actually refer to the same thing and the data from the two files should be made to match. If it is the latter, you will first have to identify such instances, and then consider applying -matchit- to these (or, if there is only a small number of such cases, perhaps resolving the issue "by hand").

        Comment

        • #5
          Thank you very much, this works perfectly fine.

          Comment

          Previous Next
          Working...
          X