I'm trying to calculate the transmission rate of the virus by country as new column variables. I want to subtract the first reported number of cases (in the total_cases column) from the latest number of cases (in the total_cases column) and divide the answer by the number of days that have passed since the first case was reported by that country. I also want to calculate the first 15 days growth rate of the virus by subtracting the first reported cases from the number of total cases on the 15th day divided by 15. The new variables to be named fifteen_day_rate and average_rate.
I appreciate any help.


. dataex

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 date str32 location int(new_cases new_deaths) long total_cases int total_deaths
"12/31/2019" "Afghanistan"  0 0  0 0
"1/1/2020"   "Afghanistan"  0 0  0 0
"1/2/2020"   "Afghanistan"  0 0  0 0
"1/3/2020"   "Afghanistan"  0 0  0 0
"1/4/2020"   "Afghanistan"  0 0  0 0
"1/5/2020"   "Afghanistan"  0 0  0 0
"1/6/2020"   "Afghanistan"  0 0  0 0
"1/7/2020"   "Afghanistan"  0 0  0 0
"1/8/2020"   "Afghanistan"  0 0  0 0
"1/9/2020"   "Afghanistan"  0 0  0 0
"1/10/2020"  "Afghanistan"  0 0  0 0
"1/11/2020"  "Afghanistan"  0 0  0 0
"1/12/2020"  "Afghanistan"  0 0  0 0
"1/13/2020"  "Afghanistan"  0 0  0 0
"1/14/2020"  "Afghanistan"  0 0  0 0
"1/15/2020"  "Afghanistan"  0 0  0 0
"1/16/2020"  "Afghanistan"  0 0  0 0
"1/17/2020"  "Afghanistan"  0 0  0 0
"1/18/2020"  "Afghanistan"  0 0  0 0
"1/19/2020"  "Afghanistan"  0 0  0 0
"1/20/2020"  "Afghanistan"  0 0  0 0
"1/21/2020"  "Afghanistan"  0 0  0 0
"1/22/2020"  "Afghanistan"  0 0  0 0
"1/23/2020"  "Afghanistan"  0 0  0 0
"1/24/2020"  "Afghanistan"  0 0  0 0
"1/25/2020"  "Afghanistan"  0 0  0 0
"1/26/2020"  "Afghanistan"  0 0  0 0
"1/27/2020"  "Afghanistan"  0 0  0 0
"1/28/2020"  "Afghanistan"  0 0  0 0
"1/29/2020"  "Afghanistan"  0 0  0 0
"1/30/2020"  "Afghanistan"  0 0  0 0
"1/31/2020"  "Afghanistan"  0 0  0 0
"2/1/2020"   "Afghanistan"  0 0  0 0
"2/2/2020"   "Afghanistan"  0 0  0 0
"2/3/2020"   "Afghanistan"  0 0  0 0
"2/4/2020"   "Afghanistan"  0 0  0 0
"2/5/2020"   "Afghanistan"  0 0  0 0
"2/6/2020"   "Afghanistan"  0 0  0 0
"2/7/2020"   "Afghanistan"  0 0  0 0
"2/8/2020"   "Afghanistan"  0 0  0 0
"2/9/2020"   "Afghanistan"  0 0  0 0
"2/10/2020"  "Afghanistan"  0 0  0 0
"2/11/2020"  "Afghanistan"  0 0  0 0
"2/12/2020"  "Afghanistan"  0 0  0 0
"2/13/2020"  "Afghanistan"  0 0  0 0
"2/14/2020"  "Afghanistan"  0 0  0 0
"2/15/2020"  "Afghanistan"  0 0  0 0
"2/16/2020"  "Afghanistan"  0 0  0 0
"2/17/2020"  "Afghanistan"  0 0  0 0
"2/18/2020"  "Afghanistan"  0 0  0 0
"2/19/2020"  "Afghanistan"  0 0  0 0
"2/20/2020"  "Afghanistan"  0 0  0 0
"2/21/2020"  "Afghanistan"  0 0  0 0
"2/22/2020"  "Afghanistan"  0 0  0 0
"2/23/2020"  "Afghanistan"  0 0  0 0
"2/24/2020"  "Afghanistan"  0 0  0 0
"2/25/2020"  "Afghanistan"  1 0  1 0
"2/26/2020"  "Afghanistan"  0 0  1 0
"2/27/2020"  "Afghanistan"  0 0  1 0
"2/28/2020"  "Afghanistan"  0 0  1 0
"2/29/2020"  "Afghanistan"  0 0  1 0
"3/1/2020"   "Afghanistan"  0 0  1 0
"3/2/2020"   "Afghanistan"  0 0  1 0
"3/8/2020"   "Afghanistan"  3 0  4 0
"3/11/2020"  "Afghanistan"  3 0  7 0
"3/15/2020"  "Afghanistan"  3 0 10 0
"3/16/2020"  "Afghanistan"  6 0 16 0
"3/17/2020"  "Afghanistan"  5 0 21 0
"3/18/2020"  "Afghanistan"  1 0 22 0
"3/19/2020"  "Afghanistan"  0 0 22 0
"3/20/2020"  "Afghanistan"  0 0 22 0
"3/21/2020"  "Afghanistan"  2 0 24 0
"3/9/2020"   "Albania"      2 0  2 0
"3/10/2020"  "Albania"      4 0  6 0
"3/11/2020"  "Albania"      4 0 10 0
"3/12/2020"  "Albania"      1 1 11 1
"3/13/2020"  "Albania"     12 0 23 1
"3/14/2020"  "Albania"     10 0 33 1
"3/15/2020"  "Albania"      5 0 38 1
"3/16/2020"  "Albania"      4 0 42 1
"3/17/2020"  "Albania"      9 0 51 1
"3/18/2020"  "Albania"      4 0 55 1
"3/19/2020"  "Albania"      4 1 59 2
"3/20/2020"  "Albania"     11 0 70 2
"3/21/2020"  "Albania"      0 0 70 2
"12/31/2019" "Algeria"      0 0  0 0
"1/1/2020"   "Algeria"      0 0  0 0
"1/2/2020"   "Algeria"      0 0  0 0
"1/3/2020"   "Algeria"      0 0  0 0
"1/4/2020"   "Algeria"      0 0  0 0
"1/5/2020"   "Algeria"      0 0  0 0
"1/6/2020"   "Algeria"      0 0  0 0
"1/7/2020"   "Algeria"      0 0  0 0
"1/8/2020"   "Algeria"      0 0  0 0
"1/9/2020"   "Algeria"      0 0  0 0
"1/10/2020"  "Algeria"      0 0  0 0
"1/11/2020"  "Algeria"      0 0  0 0
"1/12/2020"  "Algeria"      0 0  0 0
"1/13/2020"  "Algeria"      0 0  0 0
"1/14/2020"  "Algeria"      0 0  0 0
end