I want to drop only certain observations of l_growth for each naic that are between 1997Q1 and 2009Q3 ( so between ts 148 and 197) yet keep other values of l_growth for each naic in the range of ts values 198-210. This is done for the first naic yet I want the same for all other naic values.
I have a range of other variables of which I want to keep the values of in all periods/all ts.
thanks!
I have a range of other variables of which I want to keep the values of in all periods/all ts.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input double naic float year double(ts l wage) float(lnl l_growth) 311111 1997 148 19.329999923706055 789.5714111328125 2.961658 . 311111 1997 149 19.320999145507813 745.7142944335938 2.9611926 . 311111 1997 150 19.489999771118164 765.2857055664063 2.9699016 . 311111 1997 151 19.672666549682617 801.2857055664063 2.97923 . 311111 2001 164 19.290000915527344 963 2.959587 . 311111 2001 165 19.306665420532227 869 2.9604504 . 311111 2001 166 19.30699920654297 941 2.9604676 . 311111 2001 167 19.410999298095703 1731 2.96584 . 311111 2002 168 18.031333923339844 923 2.892111 . 311111 2002 169 17.89900016784668 920 2.884745 . 311111 2002 170 17.991334915161133 988 2.88989 . 311111 2002 171 18.222000122070313 995 2.9026296 . 311111 2003 172 17.95333480834961 1126 2.887776 . 311111 2003 173 18.000333786010742 941 2.8903904 . 311111 2003 174 17.992666244506836 956 2.889964 . 311111 2003 175 18.002334594726563 1045 2.8905015 . 311111 2004 176 17.69933319091797 1036 2.873527 . 311111 2004 177 17.59000015258789 925 2.8673306 . 311111 2004 178 17.657665252685547 986 2.87117 . 311111 2004 179 17.56999969482422 1038 2.866193 . 311111 2005 180 17.893665313720703 1044 2.884447 . 311111 2005 181 17.94499969482422 946 2.8873115 . 311111 2005 182 17.93899917602539 1002 2.886977 . 311111 2005 183 18.209665298461914 1050 2.9019525 . 311111 2006 184 18.33966636657715 1288 2.909066 . 311111 2006 185 18.463666915893555 1001 2.915805 . 311111 2006 186 18.743999481201172 981 2.9308736 . 311111 2006 187 18.8613338470459 1073 2.937114 . 311111 2007 188 18.56533432006836 1154 2.921296 . 311111 2007 189 18.441665649414063 987 2.9146125 . 311111 2007 190 18.736000061035156 978 2.930447 . 311111 2007 191 19.071334838867188 1106 2.9481864 . 311111 2008 192 18.977333068847656 1192 2.943245 . 311111 2008 193 18.920000076293945 1012 2.9402196 . 311111 2008 194 18.89433479309082 996 2.938862 . 311111 2008 195 18.94499969482422 1160 2.94154 . 311111 2009 196 19.645666122436523 1277 2.977857 . 311111 2009 197 19.806333541870117 1042 2.986002 . 311111 2009 198 19.895999908447266 1022 2.990519 .02886057 311111 2009 199 20.117000579833984 1187 3.001565 .04037261 311111 2010 200 20.121999740600586 1161 3.001814 .03191209 311111 2010 201 20.454666137695313 1144 3.018211 .03898096 311111 2010 202 20.538665771484375 1070 3.022309 .06542182 311111 2010 203 20.645334243774414 1176 3.0274894 .06005383 311111 2011 204 20.581666946411133 1281 3.024401 .06386399 311111 2011 205 20.526334762573242 1102 3.021709 .07907844 311111 2011 206 20.444334030151367 1102 3.017706 .04785538 311111 2011 207 20.64266586303711 1184 3.02736 .06188107 311111 2012 208 21.030000686645508 1443 3.04595 .03557539 311111 2012 209 21.009666442871094 1077 3.044983 .07675862 311111 2012 210 21.57699966430664 1121 3.071628 .0964384 311119 1997 148 36.12666702270508 469.1666564941406 3.5870314 .611995 311119 1997 149 36.03233337402344 474.75 3.5844166 .6192467 311119 1997 150 35.87900161743164 473.5833435058594 3.580152 .6450727 311119 1997 151 35.802669525146484 577 3.5780225 .6184356 311119 1998 152 35.25699996948242 505 3.562664 .6022136 311119 1998 153 35.147666931152344 546.75 3.559558 .5990906 311119 1998 154 35.37166976928711 547.75 3.565911 .6000714 311119 1998 155 35.2946662902832 563.75 3.563732 .6716208 311119 1999 156 35.012332916259766 629.076904296875 3.5557 .6709554 311119 1999 157 35.249332427978516 552.1538696289063 3.5624466 .6725564 311119 1999 158 35.25299835205078 577 3.5625505 .6599209 311119 1999 159 35.36600112915039 646.6923217773438 3.565751 .6779749 311119 2000 160 34.41033172607422 684.8461303710938 3.538357 .6479664 311119 2000 161 34.75199890136719 598.1538696289063 3.548237 .6582727 311119 2000 162 34.74066925048828 546.3076782226563 3.547911 .6574094 311119 2000 163 34.36899948120117 696.1538696289063 3.537155 .6636279 311119 2001 164 33.9913330078125 693 3.5261056 .6587751 311119 2001 165 33.94900131225586 673 3.5248594 .6536894 311119 2001 166 33.83266830444336 699 3.521427 .6552341 311119 2001 167 33.39033126831055 737 3.5082664 .6238196 311119 2002 168 32.8736686706543 725 3.492672 .6053605 311119 2002 169 33.0629997253418 700 3.498415 .6114378 311119 2002 170 32.67166519165039 714 3.486508 .5845556 311119 2002 171 32.72200012207031 742 3.4880476 .5789814 311119 2003 172 31.927000045776367 745 3.463452 .54764724 311119 2003 173 31.743000030517578 705 3.457672 .5267985 311119 2003 174 31.352333068847656 767 3.445289 .50817466 311119 2003 175 31.140666961669922 779 3.4385145 .51721835 311119 2004 176 31.832666397094727 742 3.460493 .54588056 311119 2004 177 31.476999282836914 732 3.449257 .5188103 311119 2004 178 31.314334869384766 759 3.444076 .4958897 311119 2004 179 31.217666625976563 843 3.440984 .4977391 311119 2005 180 30.5049991607666 752 3.4178905 .4776709 311119 2005 181 30.557334899902344 768 3.419605 .4807427 311119 2005 182 30.54666519165039 779 3.4192555 .4777155 311119 2005 183 30.645334243774414 829 3.42248 .4446235 311119 2006 184 30.569000244140625 790 3.4199865 .4339848 311119 2006 185 30.676334381103516 796 3.4234915 .4329727 311119 2006 186 30.516000747680664 771 3.418251 .4166861 311119 2006 187 30.665666580200195 838 3.4231436 .42133 311119 2007 188 31.040000915527344 802 3.435277 .4170656 311119 2007 189 31.49566650390625 819 3.44985 .4275408 311119 2007 190 31.513999938964844 779 3.450432 .4229424 311119 2007 191 31.836666107177734 876 3.460619 .436218 311119 2008 192 32.09866714477539 829 3.4688146 .4471059 311119 2008 193 32.03266525268555 809 3.466756 .4490504 311119 2008 194 31.94099998474121 848 3.4638906 .43653035 311119 2008 195 31.758333206176758 951 3.458155 .4122052 311119 2009 196 31.666000366210938 844 3.4552436 .4102609 end
Comment