Announcement

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

  • changing the title in loop

    hello dear all,
    I wan to change the title of my charts in the loop.
    Code:
    foreach x in 111 112 122 124 128 132 134 136 137 138 142 144 146 156 158 172 174 176 178 182 184 193 196 542 935 936{
    
        
    foreach v in l_emp_r { 
    forvalues i=0/6{
    
    reghdfe `v'_`i' l(0/2)ldeps_new   l(1/2)`v'  if ifscode!=`x' , absorb(i.NUTS2_ID i.year) vce( cluster NUTS2_ID) 
    
    lincom ldeps_new, level(90) 
    
    
    replace bh_`v' = r(estimate)*sd_sh*100 if _n == `i'+2 
    replace seh_`v' = r(se) if _n == `i'+2    
    replace up90h_`v' = (r(estimate) + 1.645*seh_`v')*sd_sh*100 if _n == `i'+2   
    replace dn90h_`v' = (r(estimate) - 1.645*seh_`v')*sd_sh*100 if _n == `i'+2   
    }
    
     **** chart
    
    
         qui: twoway rarea  dn90h_`v'  up90h_`v' horizon if horizon <7   ,  color(gs10)  xlabel(-1 (1) 6) || ///
                          line bh_`v' horizon if horizon <7  , lcolor(blue) lpattern(solid) lwidth(medthick) xscale(range(-1 ) titleg(1)) || ///                                    
             line a horizon if horizon <7,  lpattern(dash) lwidth(vthin) lcolor(gs0) ///  
        title("`v'", color(black) size(medium)) ///
        ytitle("Change in regional employment (%)" , size(medsmall)) xtitle("Years after Policy Shock", size(medsmall)) ///
        graphregion(color(white)) plotregion(color(white)) ///
        legend(off) ///
        title(" `x''") 
    graph save `x'_mygraph, replace
    
    }
    }
    with this"
    Code:
    title(111 "USA" 112 "GBR" 122 "AUT" 124 "BEL" 128 "DNK" 132 "FRA" 134 "DEU" 136 "" ITA "" 137 "LUX" 138 "NLD" 142 "NOR" 144"SWE" 146"CHE"156"CAN"158"JPN"172"FIN"174"GRC"176"ISL"178"IRL"182"PRT"184"ESP"193"AUS"196"NZL"542"KOR"935"CZE"936"CZK")
    but when I add this line of the code instead of the "`x" in title, it shows all of them as a title foe each of them without removing one country.


    I appreciate any comments you can provide to me.

    best regards,
    Khati111_mygraph.gph

  • #2
    Your question is confusing without a data example. Say you have a numerical variable with value labels, where the labels are the country names. Then you can directly refer to the value label within the loop.

    Code:
    sysuse census, clear
    forval reg=1/4{
        scatter pop marriage if region==`reg', title("`:lab (region) `reg' '") saving(gr`reg', replace)
    }
    gr combine gr1.gph gr2.gph gr3.gph gr4.gph
    Click image for larger version

Name:	Graph.png
Views:	1
Size:	62.9 KB
ID:	1748647

    Comment


    • #3
      @Andrew Musau thank you so much for you reply. this is a part of my dataset. they are different variable name in my dataset. the Country is as str but the ifscode is as a float. in my regression, I want to run the regression by removing one country at the time.

      . dataex Country ifscode eps_new year l_emp_r l_emp_r_0 l_emp_r_1 l_emp_r_2 l_emp_r_3 l_emp_r_4 l_emp_r_5 l_emp_r_6

      ----------------------- copy starting from the next line -----------------------
      Code:
      * Example generated by -dataex-. For more info, type help dataex
      clear
      input str4 Country float ifscode double(eps_new year) float(l_emp_r l_emp_r_0 l_emp_r_1 l_emp_r_2 l_emp_r_3 l_emp_r_4 l_emp_r_5 l_emp_r_6)
      "AUT" 122    . 1980   11.3544   11.3544 11.363613  11.35029  11.33332  11.33869  11.34107 11.341662
      "AUT" 122    . 1981 11.363613 11.363613  11.35029  11.33332  11.33869  11.34107 11.341662 11.344862
      "AUT" 122    . 1982  11.35029  11.35029  11.33332  11.33869  11.34107 11.341662 11.344862 11.375042
      "AUT" 122    . 1983  11.33332  11.33332  11.33869  11.34107 11.341662 11.344862 11.375042 11.394817
      "AUT" 122    . 1984  11.33869  11.33869  11.34107 11.341662 11.344862 11.375042 11.394817 11.424968
      "AUT" 122    . 1985  11.34107  11.34107 11.341662 11.344862 11.375042 11.394817 11.424968  11.43874
      "AUT" 122    . 1986 11.341662 11.341662 11.344862 11.375042 11.394817 11.424968  11.43874 11.450305
      "AUT" 122    . 1987 11.344862 11.344862 11.375042 11.394817 11.424968  11.43874 11.450305 11.455297
      "AUT" 122    . 1988 11.375042 11.375042 11.394817 11.424968  11.43874 11.450305 11.455297 11.477817
      "AUT" 122    . 1989 11.394817 11.394817 11.424968  11.43874 11.450305 11.455297 11.477817 11.499537
      "AUT" 122 1.39 1990 11.424968 11.424968  11.43874 11.450305 11.455297 11.477817 11.499537 11.498725
      "AUT" 122 1.39 1991  11.43874  11.43874 11.450305 11.455297 11.477817 11.499537 11.498725  11.50338
      "AUT" 122 1.39 1992 11.450305 11.450305 11.455297 11.477817 11.499537 11.498725  11.50338 11.500245
      "AUT" 122 1.39 1993 11.455297 11.455297 11.477817 11.499537 11.498725  11.50338 11.500245 11.508918
      "AUT" 122 1.39 1994 11.477817 11.477817 11.499537 11.498725  11.50338 11.500245 11.508918 11.523866
      "AUT" 122 1.61 1995 11.499537 11.499537 11.498725  11.50338 11.500245 11.508918 11.523866  11.52683
      "AUT" 122 1.61 1996 11.498725 11.498725  11.50338 11.500245 11.508918 11.523866  11.52683 11.537618
      "AUT" 122 1.61 1997  11.50338  11.50338 11.500245 11.508918 11.523866  11.52683 11.537618 11.550221
      "AUT" 122 1.61 1998 11.500245 11.500245 11.508918 11.523866  11.52683 11.537618 11.550221 11.551184
      "AUT" 122 1.61 1999 11.508918 11.508918 11.523866  11.52683 11.537618 11.550221 11.551184 11.557038
      "AUT" 122 1.89 2000 11.523866 11.523866  11.52683 11.537618 11.550221 11.551184 11.557038  11.57025
      "AUT" 122 1.89 2001  11.52683  11.52683 11.537618 11.550221 11.551184 11.557038  11.57025 11.584315
      "AUT" 122 1.89 2002 11.537618 11.537618 11.550221 11.551184 11.557038  11.57025 11.584315 11.595335
      "AUT" 122 2.19 2003 11.550221 11.550221 11.551184 11.557038  11.57025 11.584315 11.595335 11.594505
      "AUT" 122 2.19 2004 11.551184 11.551184 11.557038  11.57025 11.584315 11.595335 11.594505  11.59993
      "AUT" 122 2.31 2005 11.557038 11.557038  11.57025 11.584315 11.595335 11.594505  11.59993 11.631508
      "AUT" 122 2.53 2006  11.57025  11.57025 11.584315 11.595335 11.594505  11.59993 11.631508 11.641318
      "AUT" 122 2.25 2007 11.584315 11.584315 11.595335 11.594505  11.59993 11.631508 11.641318 11.648417
      "AUT" 122 2.67 2008 11.595335 11.595335 11.594505  11.59993 11.631508 11.641318 11.648417 11.664788
      "AUT" 122 2.94 2009 11.594505 11.594505  11.59993 11.631508 11.641318 11.648417 11.664788 11.673342
      "AUT" 122 3.08 2010  11.59993  11.59993 11.631508 11.641318 11.648417 11.664788 11.673342  11.68267
      "AUT" 122 3.06 2011 11.631508 11.631508 11.641318 11.648417 11.664788 11.673342  11.68267  11.70272
      "AUT" 122 2.94 2012 11.641318 11.641318 11.648417 11.664788 11.673342  11.68267  11.70272  11.71505
      "AUT" 122 3.28 2013 11.648417 11.648417 11.664788 11.673342  11.68267  11.70272  11.71505 11.723996
      "AUT" 122 3.11 2014 11.664788 11.664788 11.673342  11.68267  11.70272  11.71505 11.723996 11.699903
      "AUT" 122 2.94 2015 11.673342 11.673342  11.68267  11.70272  11.71505 11.723996 11.699903         .
      "AUT" 122 2.94 2016  11.68267  11.68267  11.70272  11.71505 11.723996 11.699903         .         .
      "AUT" 122 2.94 2017  11.70272  11.70272  11.71505 11.723996 11.699903         .         .         .
      "AUT" 122 3.08 2018  11.71505  11.71505 11.723996 11.699903         .         .         .         .
      "AUT" 122 3.14 2019 11.723996 11.723996 11.699903         .         .         .         .         .
      "AUT" 122 3.31 2020 11.699903 11.699903         .         .         .         .         .         .
      "AUT" 122    . 1980 13.274638 13.274638  13.26733 13.249648 13.243341 13.240182 13.236299 13.240608
      "AUT" 122    . 1981  13.26733  13.26733 13.249648 13.243341 13.240182 13.236299 13.240608 13.237743
      "AUT" 122    . 1982 13.249648 13.249648 13.243341 13.240182 13.236299 13.240608 13.237743 13.256038
      "AUT" 122    . 1983 13.243341 13.243341 13.240182 13.236299 13.240608 13.237743 13.256038 13.272454
      "AUT" 122    . 1984 13.240182 13.240182 13.236299 13.240608 13.237743 13.256038 13.272454  13.29364
      "AUT" 122    . 1985 13.236299 13.236299 13.240608 13.237743 13.256038 13.272454  13.29364   13.3106
      "AUT" 122    . 1986 13.240608 13.240608 13.237743 13.256038 13.272454  13.29364   13.3106 13.315576
      "AUT" 122    . 1987 13.237743 13.237743 13.256038 13.272454  13.29364   13.3106 13.315576 13.310916
      "AUT" 122    . 1988 13.256038 13.256038 13.272454  13.29364   13.3106 13.315576 13.310916  13.31333
      "AUT" 122    . 1989 13.272454 13.272454  13.29364   13.3106 13.315576 13.310916  13.31333 13.306617
      "AUT" 122 1.39 1990  13.29364  13.29364   13.3106 13.315576 13.310916  13.31333 13.306617 13.308943
      "AUT" 122 1.39 1991   13.3106   13.3106 13.315576 13.310916  13.31333 13.306617 13.308943 13.317338
      "AUT" 122 1.39 1992 13.315576 13.315576 13.310916  13.31333 13.306617 13.308943 13.317338 13.326022
      "AUT" 122 1.39 1993 13.310916 13.310916  13.31333 13.306617 13.308943 13.317338 13.326022 13.340567
      "AUT" 122 1.39 1994  13.31333  13.31333 13.306617 13.308943 13.317338 13.326022 13.340567 13.339585
      "AUT" 122 1.61 1995 13.306617 13.306617 13.308943 13.317338 13.326022 13.340567 13.339585  13.34182
      "AUT" 122 1.61 1996 13.308943 13.308943 13.317338 13.326022 13.340567 13.339585  13.34182 13.343136
      "AUT" 122 1.61 1997 13.317338 13.317338 13.326022 13.340567 13.339585  13.34182 13.343136  13.34918
      "AUT" 122 1.61 1998 13.326022 13.326022 13.340567 13.339585  13.34182 13.343136  13.34918 13.354284
      "AUT" 122 1.61 1999 13.340567 13.340567 13.339585  13.34182 13.343136  13.34918 13.354284 13.360782
      "AUT" 122 1.89 2000 13.339585 13.339585  13.34182 13.343136  13.34918 13.354284 13.360782 13.378075
      "AUT" 122 1.89 2001  13.34182  13.34182 13.343136  13.34918 13.354284 13.360782 13.378075 13.394693
      "AUT" 122 1.89 2002 13.343136 13.343136  13.34918 13.354284 13.360782 13.378075 13.394693 13.416182
      "AUT" 122 2.19 2003  13.34918  13.34918 13.354284 13.360782 13.378075 13.394693 13.416182 13.410275
      "AUT" 122 2.19 2004 13.354284 13.354284 13.360782 13.378075 13.394693 13.416182 13.410275 13.411505
      "AUT" 122 2.31 2005 13.360782 13.360782 13.378075 13.394693 13.416182 13.410275 13.411505  13.42724
      "AUT" 122 2.53 2006 13.378075 13.378075 13.394693 13.416182 13.410275 13.411505  13.42724   13.4345
      "AUT" 122 2.25 2007 13.394693 13.394693 13.416182 13.410275 13.411505  13.42724   13.4345  13.43955
      "AUT" 122 2.67 2008 13.416182 13.416182 13.410275 13.411505  13.42724   13.4345  13.43955 13.449924
      "AUT" 122 2.94 2009 13.410275 13.410275 13.411505  13.42724   13.4345  13.43955 13.449924 13.456003
      "AUT" 122 3.08 2010 13.411505 13.411505  13.42724   13.4345  13.43955 13.449924 13.456003 13.465385
      "AUT" 122 3.06 2011  13.42724  13.42724   13.4345  13.43955 13.449924 13.456003 13.465385 13.481715
      "AUT" 122 2.94 2012   13.4345   13.4345  13.43955 13.449924 13.456003 13.465385 13.481715  13.49598
      "AUT" 122 3.28 2013  13.43955  13.43955 13.449924 13.456003 13.465385 13.481715  13.49598  13.50542
      "AUT" 122 3.11 2014 13.449924 13.449924 13.456003 13.465385 13.481715  13.49598  13.50542 13.480863
      "AUT" 122 2.94 2015 13.456003 13.456003 13.465385 13.481715  13.49598  13.50542 13.480863         .
      "AUT" 122 2.94 2016 13.465385 13.465385 13.481715  13.49598  13.50542 13.480863         .         .
      "AUT" 122 2.94 2017 13.481715 13.481715  13.49598  13.50542 13.480863         .         .         .
      "AUT" 122 3.08 2018  13.49598  13.49598  13.50542 13.480863         .         .         .         .
      "AUT" 122 3.14 2019  13.50542  13.50542 13.480863         .         .         .         .         .
      "AUT" 122 3.31 2020 13.480863 13.480863         .         .         .         .         .         .
      "AUT" 122    . 1980 13.602776 13.602776 13.593703  13.57536 13.562256 13.562088 13.568267  13.58147
      "AUT" 122    . 1981 13.593703 13.593703  13.57536 13.562256 13.562088 13.568267  13.58147 13.582658
      "AUT" 122    . 1982  13.57536  13.57536 13.562256 13.562088 13.568267  13.58147 13.582658 13.590854
      "AUT" 122    . 1983 13.562256 13.562256 13.562088 13.568267  13.58147 13.582658 13.590854 13.598474
      "AUT" 122    . 1984 13.562088 13.562088 13.568267  13.58147 13.582658 13.590854 13.598474  13.61912
      "AUT" 122    . 1985 13.568267 13.568267  13.58147 13.582658 13.590854 13.598474  13.61912 13.636958
      "AUT" 122    . 1986  13.58147  13.58147 13.582658 13.590854 13.598474  13.61912 13.636958 13.643333
      "AUT" 122    . 1987 13.582658 13.582658 13.590854 13.598474  13.61912 13.636958 13.643333  13.63526
      "AUT" 122    . 1988 13.590854 13.590854 13.598474  13.61912 13.636958 13.643333  13.63526 13.628084
      "AUT" 122    . 1989 13.598474 13.598474  13.61912 13.636958 13.643333  13.63526 13.628084 13.620335
      "AUT" 122 1.39 1990  13.61912  13.61912 13.636958 13.643333  13.63526 13.628084 13.620335 13.625052
      "AUT" 122 1.39 1991 13.636958 13.636958 13.643333  13.63526 13.628084 13.620335 13.625052 13.627602
      "AUT" 122 1.39 1992 13.643333 13.643333  13.63526 13.628084 13.620335 13.625052 13.627602 13.639358
      "AUT" 122 1.39 1993  13.63526  13.63526 13.628084 13.620335 13.625052 13.627602 13.639358  13.65648
      "AUT" 122 1.39 1994 13.628084 13.628084 13.620335 13.625052 13.627602 13.639358  13.65648 13.667057
      "AUT" 122 1.61 1995 13.620335 13.620335 13.625052 13.627602 13.639358  13.65648 13.667057 13.671756
      "AUT" 122 1.61 1996 13.625052 13.625052 13.627602 13.639358  13.65648 13.667057 13.671756  13.66971
      "AUT" 122 1.61 1997 13.627602 13.627602 13.639358  13.65648 13.667057 13.671756  13.66971 13.666779
      end
      ------------------ copy up to and including the previous line ------------------

      Listed 100 out of 13069 observations
      Use the count() option to list more

      Comment


      • #4
        Code:
        qui levelsof country if ifscode!= `x', local(countries)
        tw ..., title(`countries')
        Last edited by Andrew Musau; 02 Apr 2024, 17:18.

        Comment


        • #5
          @Andrew Musau thank you so much for your reply.
          it works.

          Comment

          Working...
          X