Hi all,
I was wondering whether someone could help me how to get a cumulative sum across the different years for different HS product codes among country pairs.
I want an extra column such that it tells me how many NTM_Tech's have been installed on the product (HS1992) between the country pair in a specific year. The variable of NTM_Tech is a dummy variable which equals 1 if there has been a NTM installed, 0 otherwise. (In the data provided at the end, only the country pair EU-USA is considered, but my dataset also contains other pairs)
So for example:
I want that:
Is there someone who could help me?
Thanks in advance!
I was wondering whether someone could help me how to get a cumulative sum across the different years for different HS product codes among country pairs.
I want an extra column such that it tells me how many NTM_Tech's have been installed on the product (HS1992) between the country pair in a specific year. The variable of NTM_Tech is a dummy variable which equals 1 if there has been a NTM installed, 0 otherwise. (In the data provided at the end, only the country pair EU-USA is considered, but my dataset also contains other pairs)
So for example:
| year | Origin | Destination | HS1992 | NTM_Tech |
| 1997 | EU | USA | 010111 | 1 |
| 1998 | EU | USA | 010111 | 1 |
| year | Origin | Destination | HS1992 | NTM_Tech | Tech_Total |
| 1997 | EU | USA | 010111 | 1 | 1 |
| 1998 | EU | USA | 010111 | 1 | 2 |
Thanks in advance!
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str12 year str25 Origin str32 Destination str6 HS1992 str1 NTM_Tech "1997" "EU" "USA" "010111" "1" "1997" "EU" "USA" "010119" "1" "1998" "EU" "USA" "010111" "1" "1998" "EU" "USA" "010119" "1" "1999" "EU" "USA" "010111" "1" "1999" "EU" "USA" "010119" "1" "2000" "EU" "USA" "010111" "1" "2000" "EU" "USA" "010119" "1" "2001" "EU" "USA" "010111" "1" "2001" "EU" "USA" "010119" "1" "2002" "EU" "USA" "010111" "1" "2002" "EU" "USA" "010119" "1" "2003" "EU" "USA" "010111" "0" "2003" "EU" "USA" "010119" "0" "2004" "EU" "USA" "010111" "0" "2004" "EU" "USA" "010119" "0" "2005" "EU" "USA" "010111" "1" "2005" "EU" "USA" "010119" "1" "2006" "EU" "USA" "010111" "0" "2006" "EU" "USA" "010119" "0" "2007" "EU" "USA" "010111" "1" "2007" "EU" "USA" "010119" "1" "2008" "EU" "USA" "010111" "1" "2008" "EU" "USA" "010119" "1" "2009" "EU" "USA" "010111" "0" "2009" "EU" "USA" "010119" "0" "2010" "EU" "USA" "010111" "0" "2010" "EU" "USA" "010119" "0" "2011" "EU" "USA" "010111" "1" "2011" "EU" "USA" "010119" "1" "2012" "EU" "USA" "010111" "1" "2012" "EU" "USA" "010119" "1" "2013" "EU" "USA" "010111" "1" "2013" "EU" "USA" "010119" "1" "2014" "EU" "USA" "010111" "1" "2014" "EU" "USA" "010119" "1" "2015" "EU" "USA" "010111" "1" "2015" "EU" "USA" "010119" "1" "2016" "EU" "USA" "010111" "0" "2016" "EU" "USA" "010119" "0" "2017" "EU" "USA" "010111" "0" "2017" "EU" "USA" "010119" "0" "2018" "EU" "USA" "010111" "0" "2018" "EU" "USA" "010119" "0" "2019" "EU" "USA" "010111" "0" "2019" "EU" "USA" "010119" "0" "2020" "EU" "USA" "010111" "0" "2020" "EU" "USA" "010119" "0" "2021" "EU" "USA" "010111" "1" "2021" "EU" "USA" "010111" "1" "2021" "EU" "USA" "010119" "1" "2021" "EU" "USA" "010119" "1" end
Comment