Dear Statalisters,
I have information about the number of number of stocks bought by company and date (daily). I need to create a variable that counts all the stocks bought during a time period between 7 and 13 days before the current date (row where the sum is generated).
This is an example:
and so on.
Thank you so much!
I have information about the number of number of stocks bought by company and date (daily). I need to create a variable that counts all the stocks bought during a time period between 7 and 13 days before the current date (row where the sum is generated).
This is an example:
Code:
date company_id num_bstocks week2 01jan2020 001 0 - 02jan2020 001 1 - 03jan2020 001 0 - 04jan2020 001 0 - 05jan2020 001 0 - 06jan2020 001 2 - 07jan2020 001 0 - 08jan2020 001 0 0 09jan2020 001 0 1 10jan2020 001 1 1 11jan2020 001 1 1 12jan2020 001 2 1 13jan2020 001 0 3 14jan2020 001 1 3 15jan2020 001 2 3 16jan2020 001 1 3 17jan2020 001 1 3 18jan2020 001 2 4 19jan2020 001 0 6 20jan2020 001 0 4 21jan2020 001 0 5 22jan2020 001 1 7 23jan2020 001 2 8 24jan2020 001 1 8 01jan2020 002 0 - 02jan2020 002 0 - 03jan2020 002 0 - 04jan2020 002 0 - 05jan2020 002 1 - 06jan2020 002 1 - 07jan2020 002 0 - 08jan2020 002 0 0 09jan2020 002 3 0 10jan2020 002 4 0 11jan2020 002 0 0 12jan2020 002 0 1 13jan2020 002 1 2 14jan2020 002 2 2 15jan2020 002 2 2 16jan2020 002 2 5 17jan2020 002 1 9 18jan2020 002 1 9 . . .
Thank you so much!
Comment