Help needed for merging datasets

Hi,

I am using Stata 16 and I am trying to merge datasets. Below is an example of my dataset:

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input double event_id str154 metric_name double layer_experiment_id str10 winning_direction float significance str48 confidence_interval double visitors_remaining
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3511690461 "Visit Page: Page 1 - Test Site"  7698980897 ""           . ""                   .
3519611368 "Add to Cart (Product Detail)"   11060530574 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   11060530574 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   11206333789 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   11060530574 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
3519611368 "Add to Cart (Product Detail)"   11060530574 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   11060530574 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   11206333789 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   11060530574 "increasing" . ""                   .
3519611368 "Add to Cart (Product Detail)"   16250520467 "increasing" 0 "" 9223372036854775808
end

I try to use one to one merge by using this code:

Code:

merge 1:1 event_id using layer_metrics

The file "layer_metrics" has the following variables:

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input double(event_id layer_id) str8 event_type byte event_condition str6 aggregator str7(field scope) byte layer_metric_order str10 winning_direction
3133741760  4059780040 "pageview" . "unique" ""        "visitor" 1 "increasing"
3161640478  4037710648 "pageview" . "unique" ""        "visitor" 1 "increasing"
3161640478  4039121526 "pageview" . "unique" ""        "visitor" 1 "increasing"
3161640478  4046270190 "pageview" . "unique" ""        "visitor" 1 "increasing"
3161640478  3963760730 "pageview" . "unique" ""        "visitor" 1 "increasing"
3161640478  4054280602 "pageview" . "unique" ""        "visitor" 1 "increasing"
3193351489  6123210681 "custom"   . "unique" ""        "visitor" 1 "increasing"
3208200576  5853043789 "click"    . "unique" ""        "visitor" 2 "increasing"
3217340419  5539050231 "pageview" . "unique" ""        "visitor" 2 "increasing"
3346701078  3961346903 "click"    . "unique" ""        "visitor" 1 "increasing"
3346701078  3922842430 "click"    . "unique" ""        "visitor" 1 "increasing"
3351800175  8488382980 "custom"   . "sum"    "revenue" "visitor" 1 "increasing"
3369360966  7384852344 "pageview" . "bounce" ""        "event"   2 "decreasing"
3377501640  8011796059 "click"    . "unique" ""        "visitor" 1 "increasing"
3491330310 10398195529 "click"    . "unique" ""        "visitor" 1 "increasing"
3511690461  7700030200 "pageview" . "unique" ""        "visitor" 1 "increasing"
3513281290  4059900881 "pageview" . "unique" ""        "visitor" 1 "increasing"
3519611368 11198413208 "click"    . "unique" ""        "visitor" 1 "increasing"
3519611368 11052420280 "click"    . "unique" ""        "visitor" 1 "increasing"
3519611368 16260300321 "click"    . "unique" ""        "visitor" 1 "increasing"
3519611368  6490930408 "click"    . "unique" ""        "visitor" 1 "increasing"
3524782929  7964510922 "pageview" . "unique" ""        "visitor" 1 "increasing"
3524782929  7933197463 "pageview" . "unique" ""        "visitor" 1 "increasing"
3528550419  7853692716 "pageview" . "unique" ""        "visitor" 1 "increasing"
3528550419  7747724328 "pageview" . "unique" ""        "visitor" 1 "increasing"
3528550419  7754843893 "pageview" . "unique" ""        "visitor" 1 "increasing"
3532434357  6504390344 "pageview" . "unique" ""        "visitor" 1 "increasing"
3535601020 18247890584 "click"    . "unique" ""        "visitor" 1 "increasing"
3536920208  6743760345 "pageview" . "unique" ""        "visitor" 1 "increasing"
3536920208  7729960575 "pageview" . "unique" ""        "visitor" 2 "increasing"
3536920208  8180620179 "pageview" . "unique" ""        "visitor" 1 "increasing"
3536920208  8169565973 "pageview" . "unique" ""        "visitor" 1 "increasing"
3536920208 11397720676 "pageview" . "unique" ""        "visitor" 2 "increasing"
3536920208  7600620936 "pageview" . "unique" ""        "visitor" 2 "increasing"
3536920208  6812420300 "pageview" . "unique" ""        "visitor" 1 "increasing"
3539112080  8363570862 "custom"   . "sum"    "value"   "visitor" 6 "increasing"
3540741811  8310084124 "pageview" . "unique" ""        "visitor" 1 "increasing"
3540741811  8364489015 "pageview" . "unique" ""        "visitor" 1 "increasing"
3540741811  8363552325 "pageview" . "unique" ""        "visitor" 1 "increasing"
3540741811  8364489015 "pageview" . "sum"    "revenue" "event"   3 "increasing"
3548412017  8650640031 "click"    . "unique" ""        "visitor" 1 "increasing"
3548412017  8650280130 "click"    . "unique" ""        "visitor" 1 "increasing"
3548412017  8543050953 "click"    . "unique" ""        "visitor" 1 "increasing"
3551850147  4978341941 "pageview" . "unique" ""        "visitor" 1 "increasing"
3556690047  8211741016 "click"    . "unique" ""        "visitor" 1 "increasing"
3563292603 14429840344 "custom"   . "unique" ""        "visitor" 2 "increasing"
3576090042  7728960675 "custom"   . "unique" ""        "visitor" 1 "increasing"
3581400552  5457973095 "custom"   . "unique" ""        "visitor" 2 "increasing"
3581400552  5196382083 "custom"   . "unique" ""        "visitor" 2 "increasing"
3581400552  7521690110 "custom"   . "unique" ""        "visitor" 2 "increasing"
end

However, I have this error message:

Code:

merge 1:1 event_id using layer_metrics
variable event_id does not uniquely identify observations in the master data
r(459);

I am not sure how to go about this problem. I initially tried merge m:m but was advised it was ill-advised even though there were matches. Any help in this area would be appreciated. Thanks!

Share on FacebookPlus on Google+