Announcement

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

    Merging Two Datasets on a Common Variable Throwing Error

    My data is panel data and I am trying to merge these two data sets on common variable "Ticker" and I ran the code while having "Industry Data" file loaded

    Code:
     merge m:1 Ticker using NetIncome
    But its throwing me an error saying "variable Ticker does not uniquely identify observations in the using data".

    I also tried the below code but it comes with the same error

    Code:
     merge 1:1 Ticker using
    Although I think the correct function should be
    Code:
    merge m:1
    in this case

    Net Income data

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str9 Ticker int Year long Yr_
"TH:2S"  1994        .
"TH:2S"  1995        .
"TH:2S"  1996        .
"TH:2S"  1997        .
"TH:2S"  1998        .
"TH:2S"  1999        .
"TH:2S"  2000        .
"TH:2S"  2001        .
"TH:2S"  2002        .
"TH:2S"  2003        .
"TH:2S"  2004        .
"TH:2S"  2005        .
"TH:2S"  2006    34020
"TH:2S"  2007    55390
"TH:2S"  2008   112840
"TH:2S"  2009    91864
"TH:2S"  2010    71431
"TH:2S"  2011    64980
"TH:2S"  2012    52643
"TH:2S"  2013    68031
"TH:2S"  2014    41898
"TH:7UP" 1994        .
"TH:7UP" 1995        .
"TH:7UP" 1996        .
"TH:7UP" 1997        .
"TH:7UP" 1998        .
"TH:7UP" 1999        .
"TH:7UP" 2000        .
"TH:7UP" 2001    84000
"TH:7UP" 2002   301429
"TH:7UP" 2003  -123386
"TH:7UP" 2004   178368
"TH:7UP" 2005   179860
"TH:7UP" 2006    67330
"TH:7UP" 2007   146175
"TH:7UP" 2008   125678
"TH:7UP" 2009   126637
"TH:7UP" 2010    66485
"TH:7UP" 2011  -625090
"TH:7UP" 2012   962232
"TH:7UP" 2013    58762
"TH:7UP" 2014  -214396
end
    Industry Data

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str9 Ticker str7 Sector str23 Industry str3 Board
"TH:2S"     "STEEL"   "Industrials"             "SET"
"TH:7UP"    "ENERG"   "Resources"               "SET"
end
    Thank you in advance for your help !


    Tags: None
  • #2
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str9 Ticker int Year long Yr_
"TH:2S"  1994       .
"TH:2S"  1995       .
"TH:2S"  1996       .
"TH:2S"  1997       .
"TH:2S"  1998       .
"TH:2S"  1999       .
"TH:2S"  2000       .
"TH:2S"  2001       .
"TH:2S"  2002       .
"TH:2S"  2003       .
"TH:2S"  2004       .
"TH:2S"  2005       .
"TH:2S"  2006   34020
"TH:2S"  2007   55390
"TH:2S"  2008  112840
"TH:2S"  2009   91864
"TH:2S"  2010   71431
"TH:2S"  2011   64980
"TH:2S"  2012   52643
"TH:2S"  2013   68031
"TH:2S"  2014   41898
"TH:7UP" 1994       .
"TH:7UP" 1995       .
"TH:7UP" 1996       .
"TH:7UP" 1997       .
"TH:7UP" 1998       .
"TH:7UP" 1999       .
"TH:7UP" 2000       .
"TH:7UP" 2001   84000
"TH:7UP" 2002  301429
"TH:7UP" 2003 -123386
"TH:7UP" 2004  178368
"TH:7UP" 2005  179860
"TH:7UP" 2006   67330
"TH:7UP" 2007  146175
"TH:7UP" 2008  125678
"TH:7UP" 2009  126637
"TH:7UP" 2010   66485
"TH:7UP" 2011 -625090
"TH:7UP" 2012  962232
"TH:7UP" 2013   58762
"TH:7UP" 2014 -214396
end

tempfile netincome
save `netincome'

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 Ticker str7 Sector str23 Industry str3 Board
"TH:2S"  "STEEL" "Industrials" "SET"
"TH:7UP" "ENERG" "Resources"   "SET"
end

merge 1:m Ticker using `netincome', nogen
sort Ticker Year
l, sepby(Ticker)
    Res.:

    Code:
    . l, sepby(Ticker)

     +--------------------------------------------------------+
     | Ticker   Sector      Industry   Board   Year       Yr_ |
     |--------------------------------------------------------|
  1. |  TH:2S    STEEL   Industrials     SET   1994         . |
  2. |  TH:2S    STEEL   Industrials     SET   1995         . |
  3. |  TH:2S    STEEL   Industrials     SET   1996         . |
  4. |  TH:2S    STEEL   Industrials     SET   1997         . |
  5. |  TH:2S    STEEL   Industrials     SET   1998         . |
  6. |  TH:2S    STEEL   Industrials     SET   1999         . |
  7. |  TH:2S    STEEL   Industrials     SET   2000         . |
  8. |  TH:2S    STEEL   Industrials     SET   2001         . |
  9. |  TH:2S    STEEL   Industrials     SET   2002         . |
 10. |  TH:2S    STEEL   Industrials     SET   2003         . |
 11. |  TH:2S    STEEL   Industrials     SET   2004         . |
 12. |  TH:2S    STEEL   Industrials     SET   2005         . |
 13. |  TH:2S    STEEL   Industrials     SET   2006     34020 |
 14. |  TH:2S    STEEL   Industrials     SET   2007     55390 |
 15. |  TH:2S    STEEL   Industrials     SET   2008    112840 |
 16. |  TH:2S    STEEL   Industrials     SET   2009     91864 |
 17. |  TH:2S    STEEL   Industrials     SET   2010     71431 |
 18. |  TH:2S    STEEL   Industrials     SET   2011     64980 |
 19. |  TH:2S    STEEL   Industrials     SET   2012     52643 |
 20. |  TH:2S    STEEL   Industrials     SET   2013     68031 |
 21. |  TH:2S    STEEL   Industrials     SET   2014     41898 |
     |--------------------------------------------------------|
 22. | TH:7UP    ENERG     Resources     SET   1994         . |
 23. | TH:7UP    ENERG     Resources     SET   1995         . |
 24. | TH:7UP    ENERG     Resources     SET   1996         . |
 25. | TH:7UP    ENERG     Resources     SET   1997         . |
 26. | TH:7UP    ENERG     Resources     SET   1998         . |
 27. | TH:7UP    ENERG     Resources     SET   1999         . |
 28. | TH:7UP    ENERG     Resources     SET   2000         . |
 29. | TH:7UP    ENERG     Resources     SET   2001     84000 |
 30. | TH:7UP    ENERG     Resources     SET   2002    301429 |
 31. | TH:7UP    ENERG     Resources     SET   2003   -123386 |
 32. | TH:7UP    ENERG     Resources     SET   2004    178368 |
 33. | TH:7UP    ENERG     Resources     SET   2005    179860 |
 34. | TH:7UP    ENERG     Resources     SET   2006     67330 |
 35. | TH:7UP    ENERG     Resources     SET   2007    146175 |
 36. | TH:7UP    ENERG     Resources     SET   2008    125678 |
 37. | TH:7UP    ENERG     Resources     SET   2009    126637 |
 38. | TH:7UP    ENERG     Resources     SET   2010     66485 |
 39. | TH:7UP    ENERG     Resources     SET   2011   -625090 |
 40. | TH:7UP    ENERG     Resources     SET   2012    962232 |
 41. | TH:7UP    ENERG     Resources     SET   2013     58762 |
 42. | TH:7UP    ENERG     Resources     SET   2014   -214396 |
     +--------------------------------------------------------+
    • 1 like

    Comment

    • #3
      it should be 1:m because Ticker uniquely identify observations in the master (industry) data,
      Code:
      use Industry, clear
merge 1:m Ticker using NetIncome

      Comment

      • #4
        Andrew Musau and @Øyvind Snilsberg Thank you so much, it worked perfectly! Adds to my learning process

        Comment

        Previous Next
        Working...
        X