Merging on multiple variables

[Dimple khattar khattar]

Hi, dataset 1 with 20 vars (not all are listed in the dataex example) with different units. I want to make the units consistent. I have dataset 2 with conversions details. Need help in making units consistent- and want help in merging all different units in D1 with D2.

dataset1:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str173(sale_unit_1 sale_unit_2) str5(output_unit_1 output_unit_2) byte ex_stock_2 str143 ex_crop_2 str3 ex_type_2
"."     "."     "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
"dozen" "kilo"  "dozen" "kilo"  . "." "."
"."     "."     "."     "."     . "." "."
"dozen" "kilo"  "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
"dozen" ""      "kilo"  "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"dozen" "kilo"  "kilo"  "kilo"  . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  ""      "kilo"  "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
"dozen" ""      "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"dozen" "kilo"  "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"dozen" ""      "kilo"  "."     . "." "."
"dozen" "kilo"  "dozen" "kilo"  . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"dozen" ""      "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"."     "."     "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"dozen" "kilo"  "."     "."     . "." "."
"dozen" "kilo"  "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"dozen" "kilo"  "kilo"  "kilo"  . "." "."
""      ""      "."     "."     . "." "."
"."     "."     "."     "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
"."     "."     "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
"kilo"  "piece" "kilo"  "piece" . "." "."
"kilo"  "bunch" "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  ""      "kilo"  "."     . "." "."
"kilo"  "kilo"  "kilo"  "kilo"  . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
"kilo"  "kilo"  "."     "."     . "." "."
""      ""      "."     "."     . "." "."
""      ""      "."     "."     . "." "."
end

Dataset 2:

* Example generated by -dataex-. To install: ssc install dataex
clear
input byte order1 str21 crop str14 sale_unit double conversion
1 "Bottle Gourd"          "piece"            1
1 "Leafy Vegetable"       "bunch"           .2
1 "Lemon        "                "piece"          .03
1 "Green Chilli"          "bunch"           .2
1 "Pineapple"             "piece"           .4
1 "DHANIA PARRA"          "bunch"           .2
1 "Green Chilli"          "Bhaga"           .2
1 "DHANIA PATRA"          "bunch"           .2
1 "Green Chilli"          "Bhaga 10 tanka"  .2
1 "Ripe Banana"           "dozen"          1.5
1 "Snake Bean/Long Beans" "bunch"            1
1 "Watermelon"            "piece"          2.5
1 "Ripe Papaya"           "piece"            1
1 "Jackfruit"             "piece"            2
1 "Raw Papaya"            "piece"            1
1 "Pumpkin"               "piece"            2
1 "Lemon        "                "Bhaga"           .2
end

[Wei Hai Deng]

I'm having trouble understanding your datastructure and goal.
Dataset 1 has two lists of just units.
Dataset 2 has conversion factors.

There is no fruit/vegetable or quantity in dataset 1? So what exactly are you converting?

Otherwise it looks like you're looking to just generate and replace new variables?

help gen
help replace

[Dimple khattar khattar]

Hi, you are right it was more about gen and replacing var. I figured it, thanks.