Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Generate trend line graph by year and different categories

    Dear All,
    Can you help me generate a trend line graph for different education expenditure by area.

    Three variables
    Edu_exp : Total Education Expenditure
    Edu_exp_newentrant: New entrant
    Edu_exp_notnew: New entrant
    Different categories

    How do generate line graph for the year of 2012,2017 and 2022 for different education expenditure in one graph (trend). and then different graph for different Area (urban, Rural)

    Please find below an example of my data set.

    ----------------------- copy starting from the next line -----------------------
    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input float area double(dcode ed8a1 ed8a2 ed8a3 ed8a4 ed8a5 ed8a6 ed8b1 ed8b2 ed8b3 ed8b4 ed8b5 ed8b6 educ_exp educ_expnew_entrant educ_exp_notnew) float year
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   100     0 1500 0   370    0  164.1666717529297                  0  164.1666717529297 2012
    2 1   0 0   0 0    0 0   100     0  500 0  1000    0  133.3333282470703                  0  133.3333282470703 2012
    2 1   0 0   0 0    0 0   100     0  120 0   600    0  68.33333587646484                  0  68.33333587646484 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   200     0  300 0  2300    0 233.33333587646484                  0 233.33333587646484 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   650     0 2400 0     0 5000  670.8333435058594                  0  670.8333435058594 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1  35 0   0 0  800 0     0     0    0 0     0    0  69.58333587646484  69.58333587646484                  0 2012
    2 1   0 0   0 0    0 0  1040     0 2400 0  3000 5000  953.3333587646484                  0  953.3333587646484 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    90     0    0 0  4500    0              382.5                  0              382.5 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    35     0  200 0     0 2000             186.25                  0             186.25 2012
    2 1   0 0   0 0    0 0    70     0    0 0  3500    0 297.49999237060547                  0 297.49999237060547 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   645     0 1800 0  3600    0 503.74998474121094                  0 503.74998474121094 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0  1100     0 2000 0  4000    0  591.6666870117188                  0  591.6666870117188 2012
    2 1 105 0 600 0  900 0   550     0 1600 0  3500    0  604.5833282470703             133.75  470.8333282470703 2012
    2 1   0 0   0 0    0 0   140     0  200 0  1600    0  161.6666717529297                  0  161.6666717529297 2012
    2 1   0 0   0 0    0 0   190     0  500 0  1700    0 199.16666412353516                  0 199.16666412353516 2012
    2 1   0 0   0 0    0 0   780     0 2300 0  6500    0  798.3333435058594                  0  798.3333435058594 2012
    2 1   0 0   0 0    0 0   740     0 1500 0  4000    0  519.9999847412109                  0  519.9999847412109 2012
    2 1   0 0   0 0    0 0   500     0 1500 0  3000    0  416.6666564941406                  0  416.6666564941406 2012
    2 1   0 0   0 0    0 0   290     0 1000 0     0 3000              357.5                  0              357.5 2012
    2 1   0 0   0 0    0 0   285     0 1500 0     0 4200             498.75                  0             498.75 2012
    2 1   0 0   0 0    0 0   290     0  400 0     0 1400  174.1666717529297                  0  174.1666717529297 2012
    2 1   0 0   0 0    0 0   620     0 3000 0  6000    0  801.6666564941406                  0  801.6666564941406 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   150     0  200 0  2500    0              237.5                  0              237.5 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   550     0 2000 0  3000    0              462.5                  0              462.5 2012
    2 1  35 0 300 0  950 0 25000     0  650 0  2450    0   2448.75008392334 107.08333587646484  2341.666748046875 2012
    2 1   0 0   0 0    0 0   270   500  500 0  6500    0              647.5                  0              647.5 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    35     0  100 0   900    0              86.25                  0              86.25 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0 30105     0 1500 0  4300    0  2992.083251953125                  0  2992.083251953125 2012
    2 1   0 0   0 0    0 0   210     0 1100 0  3790    0                425                  0                425 2012
    2 1   0 0   0 0    0 0    30 23300  600 0  3500    0  2285.833251953125                  0  2285.833251953125 2012
    2 1   0 0   0 0    0 0 30500     0 2300 0     0 6500 3275.0000915527344                  0 3275.0000915527344 2012
    2 1   0 0   0 0    0 0   300     0 3800 0  8500    0 1050.0000305175781                  0 1050.0000305175781 2012
    2 1   0 0   0 0    0 0   345   500 3000 0  8500    0 1028.7499923706055                  0 1028.7499923706055 2012
    2 1   0 0   0 0    0 0    70   495    0 0  3000    0  297.0833435058594                  0  297.0833435058594 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    45     0    0 0  1500    0             128.75                  0             128.75 2012
    2 1   0 0   0 0    0 0   590   500 1700 0  4500    0  607.4999847412109                  0  607.4999847412109 2012
    2 1  45 0   0 0 1500 0    45     0  100 0  2500    0  349.1666717529297             128.75  220.4166717529297 2012
    2 1   0 0   0 0    0 0   240     0 1600 0  4000    0  486.6666717529297                  0  486.6666717529297 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   350     0 3600 0  7000 1100 1004.1666564941406                  0 1004.1666564941406 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   205     0 1000 0  1500    0  225.4166717529297                  0  225.4166717529297 2012
    2 1   0 0   0 0    0 0    35     0    0 0   900    0  77.91666412353516                  0  77.91666412353516 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   450     0  500 0  1000    0              162.5                  0              162.5 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   105     0  600 0   515    0 101.66666412353516                  0 101.66666412353516 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    35     0    0 0     0    0 2.9166667461395264                  0 2.9166667461395264 2012
    2 1   0 0   0 0    0 0    70     0    0 0  1150    0 101.66666793823242                  0 101.66666793823242 2012
    2 1   0 0   0 0    0 0    70     0  300 0  1000 1000              197.5                  0              197.5 2012
    2 1   0 0   0 0    0 0    70     0    0 0     0    0  5.833333492279053                  0  5.833333492279053 2012
    2 1   0 0   0 0    0 0   955     0 1000 0     0 6000  662.9166717529297                  0  662.9166717529297 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    35     0    0 0   800    0  69.58333587646484                  0  69.58333587646484 2012
    2 1   0 0   0 0    0 0  5035     0    0 0  1500    0  544.5833206176758                  0  544.5833206176758 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   420     0 1450 0  2000    0  322.4999952316284                  0  322.4999952316284 2012
    2 1   0 0   0 0    0 0     0 68000 3000 0  3500    0   6208.33349609375                  0   6208.33349609375 2012
    2 1   0 0   0 0    0 0   700   100 1450 0  4000    0  520.8333282470703                  0  520.8333282470703 2012
    2 1   0 0   0 0    0 0    70     0    0 0  2000    0              172.5                  0              172.5 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1  30 0   0 0 1500 0    30     0    0 0  1000    0 213.33333587646484              127.5  85.83333587646484 2012
    2 1   0 0   0 0    0 0    50     0  500 0   500    0               87.5                  0               87.5 2012
    2 1   0 0   0 0 1500 0     0     0    0 0     0    0                125                125                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0    30     0  500 0  2000    0  210.8333282470703                  0  210.8333282470703 2012
    2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
    2 1   0 0   0 0    0 0   530     0 2000 0  3000    0  460.8333435058594                  0  460.8333435058594 2012
    2 1   0 0   0 0    0 0   330     0  800 0 13000    0 1177.5000305175781                  0 1177.5000305175781 2012
    end
    label values area area
    label def area 2 "rural", modify
    label values dcode dcode
    label def dcode 1 "Bumthang", modify
    ------------------ copy up to and including the previous line ------------------

    Listed 100 out of 33968 observations



    Thank you in advance

  • #2
    gonna be tricky to help do a time series graph with data from one year.

    Comment


    • #3
      Its data for three years


      ----------------------- copy starting from the next line -----------------------
      Code:
      * Example generated by -dataex-. For more info, type help dataex
      clear
      input double dcode float area double(m_status ed8a1 ed8a2 ed8a3 ed8a4 ed8a5 ed8a6 ed8b1 ed8b2 ed8b3 ed8b4 ed8b5 ed8b6 educ_exp educ_expnew_entrant educ_exp_notnew) float year
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
      1 2 6   0 0   0 0    0 0   100     0 1500 0   370    0  164.1666717529297                  0  164.1666717529297 2012
      1 2 3   0 0   0 0    0 0   100     0  500 0  1000    0  133.3333282470703                  0  133.3333282470703 2012
      1 2 3   0 0   0 0    0 0   100     0  120 0   600    0  68.33333587646484                  0  68.33333587646484 2012
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0   200     0  300 0  2300    0 233.33333587646484                  0 233.33333587646484 2012
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0   650     0 2400 0     0 5000  670.8333435058594                  0  670.8333435058594 2012
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3  35 0   0 0  800 0     0     0    0 0     0    0  69.58333587646484  69.58333587646484                  0 2012
      1 2 6   0 0   0 0    0 0  1040     0 2400 0  3000 5000  953.3333587646484                  0  953.3333587646484 2017
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0    90     0    0 0  4500    0              382.5                  0              382.5 2017
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 6   0 0   0 0    0 0    35     0  200 0     0 2000             186.25                  0             186.25 2017
      1 2 4   0 0   0 0    0 0    70     0    0 0  3500    0 297.49999237060547                  0 297.49999237060547 2012
      1 2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 3   0 0   0 0    0 0   645     0 1800 0  3600    0 503.74998474121094                  0 503.74998474121094 2022
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
      1 2 3   0 0   0 0    0 0  1100     0 2000 0  4000    0  591.6666870117188                  0  591.6666870117188 2012
      1 2 3 105 0 600 0  900 0   550     0 1600 0  3500    0  604.5833282470703             133.75  470.8333282470703 2022
      1 2 3   0 0   0 0    0 0   140     0  200 0  1600    0  161.6666717529297                  0  161.6666717529297 2022
      1 2 3   0 0   0 0    0 0   190     0  500 0  1700    0 199.16666412353516                  0 199.16666412353516 2022
      1 2 3   0 0   0 0    0 0   780     0 2300 0  6500    0  798.3333435058594                  0  798.3333435058594 2022
      1 2 4   0 0   0 0    0 0   740     0 1500 0  4000    0  519.9999847412109                  0  519.9999847412109 2022
      1 2 6   0 0   0 0    0 0   500     0 1500 0  3000    0  416.6666564941406                  0  416.6666564941406 2022
      1 2 3   0 0   0 0    0 0   290     0 1000 0     0 3000              357.5                  0              357.5 2022
      1 2 3   0 0   0 0    0 0   285     0 1500 0     0 4200             498.75                  0             498.75 2022
      1 2 3   0 0   0 0    0 0   290     0  400 0     0 1400  174.1666717529297                  0  174.1666717529297 2022
      1 2 3   0 0   0 0    0 0   620     0 3000 0  6000    0  801.6666564941406                  0  801.6666564941406 2022
      1 2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 3   0 0   0 0    0 0   150     0  200 0  2500    0              237.5                  0              237.5 2022
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 3   0 0   0 0    0 0   550     0 2000 0  3000    0              462.5                  0              462.5 2012
      1 2 3  35 0 300 0  950 0 25000     0  650 0  2450    0   2448.75008392334 107.08333587646484  2341.666748046875 2022
      1 2 3   0 0   0 0    0 0   270   500  500 0  6500    0              647.5                  0              647.5 2022
      1 2 4   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0    35     0  100 0   900    0              86.25                  0              86.25 2007
      1 2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0 30105     0 1500 0  4300    0  2992.083251953125                  0  2992.083251953125 2012
      1 2 3   0 0   0 0    0 0   210     0 1100 0  3790    0                425                  0                425 2012
      1 2 3   0 0   0 0    0 0    30 23300  600 0  3500    0  2285.833251953125                  0  2285.833251953125 2007
      1 2 3   0 0   0 0    0 0 30500     0 2300 0     0 6500 3275.0000915527344                  0 3275.0000915527344 2007
      1 2 1   0 0   0 0    0 0   300     0 3800 0  8500    0 1050.0000305175781                  0 1050.0000305175781 2007
      1 2 3   0 0   0 0    0 0   345   500 3000 0  8500    0 1028.7499923706055                  0 1028.7499923706055 2007
      1 2 3   0 0   0 0    0 0    70   495    0 0  3000    0  297.0833435058594                  0  297.0833435058594 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0    45     0    0 0  1500    0             128.75                  0             128.75 2007
      1 2 3   0 0   0 0    0 0   590   500 1700 0  4500    0  607.4999847412109                  0  607.4999847412109 2007
      1 2 6  45 0   0 0 1500 0    45     0  100 0  2500    0  349.1666717529297             128.75  220.4166717529297 2007
      1 2 3   0 0   0 0    0 0   240     0 1600 0  4000    0  486.6666717529297                  0  486.6666717529297 2007
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 6   0 0   0 0    0 0   350     0 3600 0  7000 1100 1004.1666564941406                  0 1004.1666564941406 2007
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
      1 2 6   0 0   0 0    0 0   205     0 1000 0  1500    0  225.4166717529297                  0  225.4166717529297 2007
      1 2 3   0 0   0 0    0 0    35     0    0 0   900    0  77.91666412353516                  0  77.91666412353516 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 1   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0   450     0  500 0  1000    0              162.5                  0              162.5 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0   105     0  600 0   515    0 101.66666412353516                  0 101.66666412353516 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 4   0 0   0 0    0 0    35     0    0 0     0    0 2.9166667461395264                  0 2.9166667461395264 2007
      1 2 3   0 0   0 0    0 0    70     0    0 0  1150    0 101.66666793823242                  0 101.66666793823242 2007
      1 2 1   0 0   0 0    0 0    70     0  300 0  1000 1000              197.5                  0              197.5 2007
      1 2 3   0 0   0 0    0 0    70     0    0 0     0    0  5.833333492279053                  0  5.833333492279053 2007
      1 2 3   0 0   0 0    0 0   955     0 1000 0     0 6000  662.9166717529297                  0  662.9166717529297 2007
      1 2 4   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0    35     0    0 0   800    0  69.58333587646484                  0  69.58333587646484 2007
      1 2 3   0 0   0 0    0 0  5035     0    0 0  1500    0  544.5833206176758                  0  544.5833206176758 2012
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 3   0 0   0 0    0 0   420     0 1450 0  2000    0  322.4999952316284                  0  322.4999952316284 2012
      1 2 1   0 0   0 0    0 0     0 68000 3000 0  3500    0   6208.33349609375                  0   6208.33349609375 2012
      1 2 6   0 0   0 0    0 0   700   100 1450 0  4000    0  520.8333282470703                  0  520.8333282470703 2012
      1 2 6   0 0   0 0    0 0    70     0    0 0  2000    0              172.5                  0              172.5 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2007
      1 2 3  30 0   0 0 1500 0    30     0    0 0  1000    0 213.33333587646484              127.5  85.83333587646484 2007
      1 2 6   0 0   0 0    0 0    50     0  500 0   500    0               87.5                  0               87.5 2022
      1 2 6   0 0   0 0 1500 0     0     0    0 0     0    0                125                125                  0 2022
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2022
      1 2 6   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2017
      1 2 6   0 0   0 0    0 0    30     0  500 0  2000    0  210.8333282470703                  0  210.8333282470703 2012
      1 2 3   0 0   0 0    0 0     0     0    0 0     0    0                  0                  0                  0 2012
      1 2 6   0 0   0 0    0 0   530     0 2000 0  3000    0  460.8333435058594                  0  460.8333435058594 2012
      1 2 6   0 0   0 0    0 0   330     0  800 0 13000    0 1177.5000305175781                  0 1177.5000305175781 2012
      end
      label values dcode dcode
      label def dcode 1 "Bumthang", modify
      label values area area
      label def area 2 "rural", modify
      label values m_status d4
      label def d4 1 "never married", modify
      label def d4 3 "married", modify
      label def d4 4 "divorced", modify
      label def d4 6 "widow/widower", modify
      ------------------ copy up to and including the previous line ------------------

      Listed 100 out of 33968 observations

      SOrry forgot the year variable

      Comment


      • #4
        This might get you started.
        Code:
        lgraph educ_exp year , alsocollapse(educ_expnew_entrant educ_exp_notnew) addplot((connected educ_expnew_entrant year , sort) (connected educ_exp_notnew year, sort))

        Comment

        Working...
        X