Announcement

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

    merging of two dataset when adding only information of one country

    hello dear all,
    I have two dataset. one is included 26 contries with about 300 regions. it is apart of my dataset:
    Code:
    input str4 Country float ifscode str3 NUTS1 double(year eps_new)
"AUT" 122 "AT1" 1980    .
"AUT" 122 "AT1" 1981    .
"AUT" 122 "AT1" 1982    .
"AUT" 122 "AT1" 1983    .
"AUT" 122 "AT1" 1984    .
"AUT" 122 "AT1" 1985    .
"AUT" 122 "AT1" 1986    .
"AUT" 122 "AT1" 1987    .
"AUT" 122 "AT1" 1988    .
"AUT" 122 "AT1" 1989    .
"AUT" 122 "AT1" 1990 1.39
"AUT" 122 "AT1" 1991 1.39
"AUT" 122 "AT1" 1992 1.39
"AUT" 122 "AT1" 1993 1.39
"AUT" 122 "AT1" 1994 1.39
"AUT" 122 "AT1" 1995 1.61
"AUT" 122 "AT1" 1996 1.61
"AUT" 122 "AT1" 1997 1.61
"AUT" 122 "AT1" 1998 1.61
"AUT" 122 "AT1" 1999 1.61
"AUT" 122 "AT1" 2000 1.89
"AUT" 122 "AT1" 2001 1.89
"AUT" 122 "AT1" 2002 1.89
"AUT" 122 "AT1" 2003 2.19
"AUT" 122 "AT1" 2004 2.19
"AUT" 122 "AT1" 2005 2.31
"AUT" 122 "AT1" 2006 2.53
"AUT" 122 "AT1" 2007 2.25
"AUT" 122 "AT1" 2008 2.67
"AUT" 122 "AT1" 2009 2.94
"AUT" 122 "AT1" 2010 3.08
"AUT" 122 "AT1" 2011 3.06
"AUT" 122 "AT1" 2012 2.94
"AUT" 122 "AT1" 2013 3.28
"AUT" 122 "AT1" 2014 3.11
"AUT" 122 "AT1" 2015 2.94
"AUT" 122 "AT1" 2016 2.94
"AUT" 122 "AT1" 2017 2.94
"AUT" 122 "AT1" 2018 3.08
"AUT" 122 "AT1" 2019 3.14
"AUT" 122 "AT1" 2020 3.31
"AUT" 122 "AT1" 1980    .
"AUT" 122 "AT1" 1981    .
"AUT" 122 "AT1" 1982    .
"AUT" 122 "AT1" 1983    .
"AUT" 122 "AT1" 1984    .
"AUT" 122 "AT1" 1985    .
"AUT" 122 "AT1" 1986    .
"AUT" 122 "AT1" 1987    .
"AUT" 122 "AT1" 1988    .
"AUT" 122 "AT1" 1989    .
"AUT" 122 "AT1" 1990 1.39
"AUT" 122 "AT1" 1991 1.39
"AUT" 122 "AT1" 1992 1.39
"AUT" 122 "AT1" 1993 1.39
"AUT" 122 "AT1" 1994 1.39
"AUT" 122 "AT1" 1995 1.61
"AUT" 122 "AT1" 1996 1.61
"AUT" 122 "AT1" 1997 1.61
"AUT" 122 "AT1" 1998 1.61
"AUT" 122 "AT1" 1999 1.61
"AUT" 122 "AT1" 2000 1.89
"AUT" 122 "AT1" 2001 1.89
"AUT" 122 "AT1" 2002 1.89
"AUT" 122 "AT1" 2003 2.19
"AUT" 122 "AT1" 2004 2.19
"AUT" 122 "AT1" 2005 2.31
"AUT" 122 "AT1" 2006 2.53
"AUT" 122 "AT1" 2007 2.25
"AUT" 122 "AT1" 2008 2.67
"AUT" 122 "AT1" 2009 2.94
"AUT" 122 "AT1" 2010 3.08
"AUT" 122 "AT1" 2011 3.06
"AUT" 122 "AT1" 2012 2.94
"AUT" 122 "AT1" 2013 3.28
"AUT" 122 "AT1" 2014 3.11
"AUT" 122 "AT1" 2015 2.94
"AUT" 122 "AT1" 2016 2.94
"AUT" 122 "AT1" 2017 2.94
"AUT" 122 "AT1" 2018 3.08
"AUT" 122 "AT1" 2019 3.14
"AUT" 122 "AT1" 2020 3.31
"AUT" 122 "AT1" 1980    .
"AUT" 122 "AT1" 1981    .
"AUT" 122 "AT1" 1982    .
"AUT" 122 "AT1" 1983    .
"AUT" 122 "AT1" 1984    .
"AUT" 122 "AT1" 1985    .
"AUT" 122 "AT1" 1986    .
"AUT" 122 "AT1" 1987    .
"AUT" 122 "AT1" 1988    .
"AUT" 122 "AT1" 1989    .
"AUT" 122 "AT1" 1990 1.39
"AUT" 122 "AT1" 1991 1.39
"AUT" 122 "AT1" 1992 1.39
"AUT" 122 "AT1" 1993 1.39
"AUT" 122 "AT1" 1994 1.39
"AUT" 122 "AT1" 1995 1.61
"AUT" 122 "AT1" 1996 1.61
"AUT" 122 "AT1" 1997 1.61
end
    I want to merge another dat file which is only one country with 41 regions.
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str4 Country double year float ifscode str3 NUTS1 double eps_new
"GBR" 1980 112 "UKC"    .
"GBR" 1981 112 "UKC"    .
"GBR" 1982 112 "UKC"    .
"GBR" 1983 112 "UKC"    .
"GBR" 1984 112 "UKC"    .
"GBR" 1985 112 "UKC"    .
"GBR" 1986 112 "UKC"    .
"GBR" 1987 112 "UKC"    .
"GBR" 1988 112 "UKC"    .
"GBR" 1989 112 "UKC"    .
"GBR" 1990 112 "UKC" 1.11
"GBR" 1991 112 "UKC" 1.11
"GBR" 1992 112 "UKC" 1.11
"GBR" 1993 112 "UKC"  .94
"GBR" 1994 112 "UKC"    1
"GBR" 1995 112 "UKC"    1
"GBR" 1996 112 "UKC"    1
"GBR" 1997 112 "UKC"    1
"GBR" 1998 112 "UKC"    1
"GBR" 1999 112 "UKC"    1
"GBR" 2000 112 "UKC" 1.33
"GBR" 2001 112 "UKC" 1.33
"GBR" 2002 112 "UKC" 1.33
"GBR" 2003 112 "UKC" 2.14
"GBR" 2004 112 "UKC" 2.14
"GBR" 2005 112 "UKC" 2.31
"GBR" 2006 112 "UKC" 2.42
"GBR" 2007 112 "UKC" 2.25
"GBR" 2008 112 "UKC" 2.47
"GBR" 2009 112 "UKC" 2.67
"GBR" 2010 112 "UKC" 3.36
"GBR" 2011 112 "UKC" 3.33
"GBR" 2012 112 "UKC" 2.89
"GBR" 2013 112 "UKC" 3.22
"GBR" 2014 112 "UKC" 3.75
"GBR" 2015 112 "UKC" 3.86
"GBR" 2016 112 "UKC" 3.36
"GBR" 2017 112 "UKC" 3.47
"GBR" 2018 112 "UKC" 3.53
"GBR" 2019 112 "UKC" 3.53
"GBR" 2020 112 "UKC" 3.61
end
    so, I am using this comments :
    merge m:1 ifscode year using "the second dataset--only 1 country with 41 regions).
    but when after merging when I use:
    bro eps_new if ifscode==112, it is missing data.

    I appreciate receiving your assistance.
    I did several times but missing data.

    best regards,
    Tags: None
  • #2
    It's because both data sets have "eps_new" in them. So, the data in the master data will stay. If you wish to update the missing in eps_new with the eps_new data from the second data set, add the option "update" after the merge command:

    Code:
    merge m:1 ifscode year using dataSet2, update

    Comment

    • #3
      @Ken Chui many thanks for your reply and assistance.
      it works.

      Comment

      Previous Next
      Working...
      X