Announcement

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

    Merge

    I have two STATA files I would like to merge,

    Number 1 contains GEO-LOCATION of Indian districts
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input int sno str21 district str23 state float(latitude longitude)
  1 "ANDAMAN_NICOBAR_IS"   "Andman & Nicobar Island" 10.7 92.5
  2 "ADILABAD"             "Andhra Pradesh"          19.7 78.5
  3 "ANANTAPUR"            "Andhra Pradesh"          14.7 77.6
  4 "CHITTOOR"             "Andhra Pradesh"          13.2 79.1
  5 "EAST_GODAVARI"        "Andhra Pradesh"          17.3   82
  6 "GUNTUR"               "Andhra Pradesh"          16.3 80.4
  7 "HYDERABAD"            "Andhra Pradesh"          17.4 78.5
  8 "Kadapa"               "Andhra Pradesh"          14.5 78.8
  9 "KARIMNAGAR"           "Andhra Pradesh"          18.4 79.1
 10 "KHAMMAM/BHADRACHALAM" "Andhra Pradesh"          17.7 80.9
 11 "KRISHNA"              "Andhra Pradesh"          16.6 80.7
 12 "KURNOOL"              "Andhra Pradesh"          15.8   78
 13 "MAHBUBNAGAR"          "Andhra Pradesh"          15.9 79.7
 14 "MEDAK"                "Andhra Pradesh"          15.9 79.7
 15 "NALGONDA"             "Andhra Pradesh"          15.9 79.7
 16 "NELLORE"              "Andhra Pradesh"          14.4   80
 17 "NIZAMABAD"            "Andhra Pradesh"          18.3   84
 18 "PRAKASAM"             "Andhra Pradesh"          15.3 79.6
 19 "RANGAREDDI"           "Andhra Pradesh"          15.9 79.7
 20 "SRIKAKULAM"           "Andhra Pradesh"          18.3 83.9
 21 "VISAKHAPATNAM"        "Andhra Pradesh"          17.7 83.2
 22 "VIZIANAGARAM"         "Andhra Pradesh"          18.1 83.4
 23 "WARANGAL"             "Andhra Pradesh"            18 79.6
 24 "WEST_GODAVARI"        "Andhra Pradesh"          16.9 81.3
 25 "ANJAW"                "Arunachal Pradesh"         28 96.8
 26 "CHANGLANG"            "Arunachal Pradesh"       27.1 95.7
 27 "EAST KAMENG"          "Arunachal Pradesh"       27.6 92.9
 28 "EAST SIANG"           "Arunachal Pradesh"       28.1 95.4
 29 "KURUNG KUMEY"         "Arunachal Pradesh"       28.1 93.3
 30 "LOHIT"                "Arunachal Pradesh"       28.1 96.2
 31 "LOWER DIBANG_VALLEY"  "Arunachal Pradesh"       28.1 95.8
 32 "LOWER SUBANSIRI"      "Arunachal Pradesh"       27.6 93.8
 33 "PAPUM PARE"           "Arunachal Pradesh"       27.2 93.5
 34 "TAWANG"               "Arunachal Pradesh"       27.6 91.9
 35 "TIRAP"                "Arunachal Pradesh"         27 95.5
 36 "UPPER DIBANG VALLEY"  "Arunachal Pradesh"       28.7 95.9
 37 "UPPER SIANG"          "Arunachal Pradesh"       28.9   95
 38 "UPPER SUBANSIRI"      "Arunachal Pradesh"       28.3   94
 39 "WEST KAMENG"          "Arunachal Pradesh"       27.3 92.3
 40 "WEST SIANG"           "Arunachal Pradesh"       28.2 94.5
 41 "BAKSA"                "Assam"                   26.7 91.3
 42 "BARPETA"              "Assam"                   26.3   91
 43 "BONGAIGAON"           "Assam"                   26.5 90.6
 44 "CACHAR"               "Assam"                   24.8 92.9
 45 "CHIRANG"              "Assam"                   26.5 90.7
 46 "DARRANG"              "Assam"                   26.5 92.1
 47 "DHEMAJI"              "Assam"                   27.5 94.6
 48 "DHUBRI"               "Assam"                     26   90
 49 "DIBRUGARH"            "Assam"                   27.5 94.9
 50 "GOALPARA"             "Assam"                   26.2 90.6
 51 "GOLAGHAT"             "Assam"                   26.5   94
 52 "HAILAKANDI"           "Assam"                   24.7 92.6
 53 "JORHAT"               "Assam"                   26.8 94.2
 54 "KAMRUP"               "Assam"                   25.9 91.3
 55 "KARBI ANGLONG"        "Assam"                   26.2 93.6
 56 "KARIMGANJ"            "Assam"                   24.9 92.4
 57 "KOKRAJHAR"            "Assam"                   26.4 90.3
 58 "LAKHIMPUR"            "Assam"                   27.2 94.2
 59 "MARIGAON"             "Assam"                   26.3 92.3
 60 "NAGAON"               "Assam"                   26.3 92.7
 61 "NALBARI"              "Assam"                   26.4 91.4
 62 "NORTH_CACHAR_HILLS"   "Assam"                   25.3   93
 63 "SIBSAGAR"             "Assam"                     27 94.6
 64 "SONITPUR"             "Assam"                   26.7 92.7
 65 "TINSUKIA"             "Assam"                   27.5 95.4
 66 "UDALGURI"             "Assam"                   26.7 92.1
 67 "ARARIA"               "Bihar"                   26.1 87.5
 68 "ARWAL"                "Bihar"                   25.2 84.7
 69 "AURANGABAD-BI"        "Bihar"                   24.7 84.4
 70 "BANKA"                "Bihar"                   24.9 86.9
 71 "BEGUSARAI"            "Bihar"                   25.4 86.1
 72 "BHAGALPUR"            "Bihar"                   25.2   87
 73 "BHOJPUR"              "Bihar"                   25.5 84.5
 74 "BUXAR"                "Bihar"                   25.6   84
 75 "DARBHANGA"            "Bihar"                   26.2 85.9
 76 "EAST CHAMPARAN"       "Bihar"                   26.6 84.9
 77 "GAYA"                 "Bihar"                   24.8   85
 78 "GOPALGANJ"            "Bihar"                   26.5 84.4
 79 "JAMUI"                "Bihar"                   24.9 86.2
 80 "JEHANABAD"            "Bihar"                   25.2   85
 81 "KAIMUR"               "Bihar"                   24.9 83.5
 82 "KATIHAR"              "Bihar"                   25.6 87.6
 83 "KHAGARIA"             "Bihar"                   25.5 86.5
 84 "KISHANGANJ"           "Bihar"                   26.1 87.9
 85 "LAKHISARAI"           "Bihar"                   25.2 86.1
 86 "MADHEPURA"            "Bihar"                   25.9 86.8
 87 "MADHUBANI"            "Bihar"                   26.3 86.1
 88 "MUNGER"               "Bihar"                   25.4 86.5
 89 "MUZAFFARPUR"          "Bihar"                   26.1 85.4
 90 "NALANDA"              "Bihar"                   25.3 85.5
 91 "NAWADA"               "Bihar"                   24.9 85.5
 92 "PATNA"                "Bihar"                   25.6 85.1
 93 "PURNIA"               "Bihar"                   25.8 87.5
 94 "ROHTAS"               "Bihar"                   24.6 83.9
 95 "SAHARSA"              "Bihar"                   25.9 86.6
 96 "SAMASTIPUR"           "Bihar"                   25.9 85.8
 97 "SARAN"                "Bihar"                   25.8 84.7
 98 "SHEIKHPURA"           "Bihar"                   25.1 85.8
 99 "SHEOHAR"              "Bihar"                   26.5 85.3
100 "SITAMARHI"            "Bihar"                   26.6 85.5
end


    Second file contains RAINFALL of LAT/LONG combination of the WORLD
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input float(latitude longitude jan23 feb23 mar23 apr23 may23)
90     0 .000652313 .000225067 .000442505 .000250816 .00063324
90   .25 .000652313 .000225067 .000442505 .000250816 .00063324
90    .5 .000652313 .000225067 .000442505 .000250816 .00063324
90   .75 .000652313 .000225067 .000442505 .000250816 .00063324
90     1 .000652313 .000225067 .000442505 .000250816 .00063324
90  1.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   1.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  1.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     2 .000652313 .000225067 .000442505 .000250816 .00063324
90  2.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   2.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  2.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     3 .000652313 .000225067 .000442505 .000250816 .00063324
90  3.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   3.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  3.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     4 .000652313 .000225067 .000442505 .000250816 .00063324
90  4.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   4.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  4.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     5 .000652313 .000225067 .000442505 .000250816 .00063324
90  5.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   5.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  5.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     6 .000652313 .000225067 .000442505 .000250816 .00063324
90  6.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   6.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  6.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     7 .000652313 .000225067 .000442505 .000250816 .00063324
90  7.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   7.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  7.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     8 .000652313 .000225067 .000442505 .000250816 .00063324
90  8.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   8.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  8.75 .000652313 .000225067 .000442505 .000250816 .00063324
90     9 .000652313 .000225067 .000442505 .000250816 .00063324
90  9.25 .000652313 .000225067 .000442505 .000250816 .00063324
90   9.5 .000652313 .000225067 .000442505 .000250816 .00063324
90  9.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    10 .000652313 .000225067 .000442505 .000250816 .00063324
90 10.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  10.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 10.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    11 .000652313 .000225067 .000442505 .000250816 .00063324
90 11.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  11.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 11.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    12 .000652313 .000225067 .000442505 .000250816 .00063324
90 12.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  12.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 12.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    13 .000652313 .000225067 .000442505 .000250816 .00063324
90 13.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  13.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 13.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    14 .000652313 .000225067 .000442505 .000250816 .00063324
90 14.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  14.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 14.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    15 .000652313 .000225067 .000442505 .000250816 .00063324
90 15.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  15.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 15.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    16 .000652313 .000225067 .000442505 .000250816 .00063324
90 16.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  16.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 16.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    17 .000652313 .000225067 .000442505 .000250816 .00063324
90 17.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  17.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 17.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    18 .000652313 .000225067 .000442505 .000250816 .00063324
90 18.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  18.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 18.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    19 .000652313 .000225067 .000442505 .000250816 .00063324
90 19.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  19.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 19.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    20 .000652313 .000225067 .000442505 .000250816 .00063324
90 20.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  20.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 20.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    21 .000652313 .000225067 .000442505 .000250816 .00063324
90 21.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  21.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 21.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    22 .000652313 .000225067 .000442505 .000250816 .00063324
90 22.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  22.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 22.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    23 .000652313 .000225067 .000442505 .000250816 .00063324
90 23.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  23.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 23.75 .000652313 .000225067 .000442505 .000250816 .00063324
90    24 .000652313 .000225067 .000442505 .000250816 .00063324
90 24.25 .000652313 .000225067 .000442505 .000250816 .00063324
90  24.5 .000652313 .000225067 .000442505 .000250816 .00063324
90 24.75 .000652313 .000225067 .000442505 .000250816 .00063324
end

    I would like to merge the two files by both LAT/LONG of Indian districts. I know its easier to do with merge 1:1, but how do I join by both LAT/LONG.


    Any help would be appreciable.

    Regards
    Tags: None
  • #2
    With the district dataset in memory, you could do

    Code:
    rename (latitude longitude) =_orig

gen latitude = round(latitude_orig, 0.25)
gen longitude = round(longitude_orig, 0.25)
    and then do a 1:1 merge with the rainfall database.
    • 1 like

    Comment

    Previous Next
    Working...
    X