Hello,

I have a dataset that looks like with trade data from 1988-2017
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float year str43 hs06_name str28 country double export_CAD
2014 "Coconut, abaca, ramie/veg tex fib"    "United States"    7613
2015 "Coconut, abaca, ramie/veg tex fib"    "United States"   22107
2016 "Coconut, abaca, ramie/veg tex fib"    "United States"  123544
2017 "Coconut, abaca, ramie/veg tex fib"    "United States"    8401
2002 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"   7500
2003 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"   7500
2004 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"  23250
2005 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"   4000
2006 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"  21085
2007 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"  27562
2008 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom" 160485
2009 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"  37155
2010 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"  60613
2011 "Horses,asses,mules,hinnies,pure-bred" "United Kingdom"  66815
1988 "Horses, pure-bred breeding"           "United Kingdom" 478979
end
The issue is for the column export CAD, I want to make it into USD. I have a separate excel file that has a column with the exchange rate from 1988-2017similar to
year avg.
1988 0.81
1989 0.84
1990 0.85
1991 0.87
1992 0.82
1993 0.77
1994 0.73
1995 0.72
. I need to multiply the exchange rate for every year by the export value for that particular year. Is there a way to do it by uploading my excel dataset of exchange rate to my trade dataset that already exists in stata?

THanks