I am looking to generate some new variables on the dataset listed below, but I'm not quite sure how. I would like to have a variable "px_at_tax" which would equal the "rel_price" value for a certain "prod" anytime that prod==(the good in question). In this case pasted below, the good in question is Alcoholicbeveragesand, but I also have many other goods as well. I want to do this because eventually, I want to create a new variable which takes the rel_price and divides it by that value so that it would be = 1 on March 2016. Rather than using the price data I have, I want to create a "rel_price_adj" variable which is weighted to the time of an exogenous event. Please let me know if you have any suggestions--I've given it a shot, but it only displays the rel_price at the date itself. It did not populate for the whole variable whenever prod==(the good in question).
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str21 prod double rel_price int year byte month float(combined_date combined_date_words) str7 country float px_at_tax "Alcoholicbeveragesand" 98.8 2014 1 648 19724 "Ireland" . "Alcoholicbeveragesand" 96.7 2014 1 648 19724 "UK" . "Alcoholicbeveragesand" 98.4 2014 2 649 19755 "Ireland" . "Alcoholicbeveragesand" 95.8 2014 2 649 19755 "UK" . "Alcoholicbeveragesand" 98.5 2014 3 650 19783 "Ireland" . "Alcoholicbeveragesand" 96.1 2014 3 650 19783 "UK" . "Alcoholicbeveragesand" 98.3 2014 4 651 19814 "Ireland" . "Alcoholicbeveragesand" 96.9 2014 4 651 19814 "UK" . "Alcoholicbeveragesand" 98.3 2014 5 652 19844 "Ireland" . "Alcoholicbeveragesand" 98.4 2014 5 652 19844 "UK" . "Alcoholicbeveragesand" 99 2014 6 653 19875 "Ireland" . "Alcoholicbeveragesand" 98.4 2014 6 653 19875 "UK" . "Alcoholicbeveragesand" 99.4 2014 7 654 19905 "Ireland" . "Alcoholicbeveragesand" 97.7 2014 7 654 19905 "UK" . "Alcoholicbeveragesand" 98.9 2014 8 655 19936 "Ireland" . "Alcoholicbeveragesand" 98.7 2014 8 655 19936 "UK" . "Alcoholicbeveragesand" 99.1 2014 9 656 19967 "Ireland" . "Alcoholicbeveragesand" 99.3 2014 9 656 19967 "UK" . "Alcoholicbeveragesand" 99.3 2014 10 657 19997 "Ireland" . "Alcoholicbeveragesand" 100 2014 10 657 19997 "UK" . "Alcoholicbeveragesand" 99.3 2014 11 658 20028 "Ireland" . "Alcoholicbeveragesand" 98.8 2014 11 658 20028 "UK" . "Alcoholicbeveragesand" 98 2014 12 659 20058 "Ireland" . "Alcoholicbeveragesand" 98.5 2014 12 659 20058 "UK" . "Alcoholicbeveragesand" 100.3 2015 1 660 20089 "Ireland" . "Alcoholicbeveragesand" 99.9 2015 1 660 20089 "UK" . "Alcoholicbeveragesand" 99.5 2015 2 661 20120 "Ireland" . "Alcoholicbeveragesand" 99.5 2015 2 661 20120 "UK" . "Alcoholicbeveragesand" 99.5 2015 3 662 20148 "Ireland" . "Alcoholicbeveragesand" 99.3 2015 3 662 20148 "UK" . "Alcoholicbeveragesand" 99.1 2015 4 663 20179 "Ireland" . "Alcoholicbeveragesand" 99.8 2015 4 663 20179 "UK" . "Alcoholicbeveragesand" 98.8 2015 5 664 20209 "Ireland" . "Alcoholicbeveragesand" 100.5 2015 5 664 20209 "UK" . "Alcoholicbeveragesand" 99.1 2015 6 665 20240 "Ireland" . "Alcoholicbeveragesand" 100.7 2015 6 665 20240 "UK" . "Alcoholicbeveragesand" 98.9 2015 7 666 20270 "Ireland" . "Alcoholicbeveragesand" 99.6 2015 7 666 20270 "UK" . "Alcoholicbeveragesand" 98.8 2015 8 667 20301 "Ireland" . "Alcoholicbeveragesand" 100.7 2015 8 667 20301 "UK" . "Alcoholicbeveragesand" 99.1 2015 9 668 20332 "Ireland" . "Alcoholicbeveragesand" 100.7 2015 9 668 20332 "UK" . "Alcoholicbeveragesand" 99.1 2015 10 669 20362 "Ireland" . "Alcoholicbeveragesand" 100.3 2015 10 669 20362 "UK" . "Alcoholicbeveragesand" 99.9 2015 11 670 20393 "Ireland" . "Alcoholicbeveragesand" 100.1 2015 11 670 20393 "UK" . "Alcoholicbeveragesand" 98.3 2015 12 671 20423 "Ireland" . "Alcoholicbeveragesand" 98.8 2015 12 671 20423 "UK" . "Alcoholicbeveragesand" 101 2016 1 672 20454 "Ireland" . "Alcoholicbeveragesand" 101.2 2016 1 672 20454 "UK" . "Alcoholicbeveragesand" 100.8 2016 2 673 20485 "Ireland" . "Alcoholicbeveragesand" 100.6 2016 2 673 20485 "UK" . "Alcoholicbeveragesand" 99.9 2016 3 674 20514 "Ireland" 99.9 "Alcoholicbeveragesand" 100.3 2016 3 674 20514 "UK" 100.3 "Alcoholicbeveragesand" 100.8 2016 4 675 20545 "Ireland" . "Alcoholicbeveragesand" 101.1 2016 4 675 20545 "UK" . "Alcoholicbeveragesand" 100.1 2016 5 676 20575 "Ireland" . "Alcoholicbeveragesand" 101.5 2016 5 676 20575 "UK" . "Alcoholicbeveragesand" 101 2016 6 677 20606 "Ireland" . "Alcoholicbeveragesand" 101.1 2016 6 677 20606 "UK" . "Alcoholicbeveragesand" 100.6 2016 7 678 20636 "Ireland" . "Alcoholicbeveragesand" 101.4 2016 7 678 20636 "UK" . "Alcoholicbeveragesand" 100.6 2016 8 679 20667 "Ireland" . "Alcoholicbeveragesand" 102.1 2016 8 679 20667 "UK" . "Alcoholicbeveragesand" 100.5 2016 9 680 20698 "Ireland" . "Alcoholicbeveragesand" 102.5 2016 9 680 20698 "UK" . "Alcoholicbeveragesand" 101.1 2016 10 681 20728 "Ireland" . "Alcoholicbeveragesand" 102.4 2016 10 681 20728 "UK" . "Alcoholicbeveragesand" 101.9 2016 11 682 20759 "Ireland" . "Alcoholicbeveragesand" 101.8 2016 11 682 20759 "UK" . "Alcoholicbeveragesand" 100 2016 12 683 20789 "Ireland" . "Alcoholicbeveragesand" 101.3 2016 12 683 20789 "UK" . "Alcoholicbeveragesand" 101.5 2017 1 684 20820 "Ireland" . "Alcoholicbeveragesand" 103.6 2017 1 684 20820 "UK" . "Alcoholicbeveragesand" 100.7 2017 2 685 20851 "Ireland" . "Alcoholicbeveragesand" 103.5 2017 2 685 20851 "UK" . "Alcoholicbeveragesand" 100.4 2017 3 686 20879 "Ireland" . "Alcoholicbeveragesand" 105.2 2017 3 686 20879 "UK" . "Alcoholicbeveragesand" 100.8 2017 4 687 20910 "Ireland" . "Alcoholicbeveragesand" 105.6 2017 4 687 20910 "UK" . "Alcoholicbeveragesand" 102.2 2017 5 688 20940 "Ireland" . "Alcoholicbeveragesand" 106.5 2017 5 688 20940 "UK" . "Alcoholicbeveragesand" 101.6 2017 6 689 20971 "Ireland" . "Alcoholicbeveragesand" 106.3 2017 6 689 20971 "UK" . "Alcoholicbeveragesand" 101.9 2017 7 690 21001 "Ireland" . "Alcoholicbeveragesand" 106.6 2017 7 690 21001 "UK" . "Alcoholicbeveragesand" 101.1 2017 8 691 21032 "Ireland" . "Alcoholicbeveragesand" 106.7 2017 8 691 21032 "UK" . "Alcoholicbeveragesand" 101.3 2017 9 692 21063 "Ireland" . "Alcoholicbeveragesand" 106.9 2017 9 692 21063 "UK" . "Alcoholicbeveragesand" 102.3 2017 10 693 21093 "Ireland" . "Alcoholicbeveragesand" 106.8 2017 10 693 21093 "UK" . "Alcoholicbeveragesand" 101.7 2017 11 694 21124 "Ireland" . "Alcoholicbeveragesand" 106.4 2017 11 694 21124 "UK" . "Alcoholicbeveragesand" 101 2017 12 695 21154 "Ireland" . "Alcoholicbeveragesand" 107 2017 12 695 21154 "UK" . "Alcoholicbeveragesand" 104.3 2018 1 696 21185 "Ireland" . "Alcoholicbeveragesand" 109.4 2018 1 696 21185 "UK" . "Alcoholicbeveragesand" 103.7 2018 2 697 21216 "Ireland" . "Alcoholicbeveragesand" 109.4 2018 2 697 21216 "UK" . end format %tm combined_date format %d combined_date_words
0 Response to Weight and mathematically adjust certain values
Post a Comment