Calculating median by year

[John Vourdas]

Hi,
I'm trying calculate a median for each year in my sample, but it just gives me an overall median for the whole sample. What am I missing here?

Command:
bys year: egen medianTEST5 = median(cet1rd)

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year float cet1rd
2007    6.319787
2007    .8103518
2007    5.568301
2007    2.931166
2007    .0833132
2007   2.0697572
2007    1.835691
2007   1.8721465
2007    5.056508
2007       .9624
2007   2.3189352
2007   1.2594864
2007   1.9739136
2007  .007285868
2007   -.3173395
2007    3.085304
2007   2.2035706
2007    1.141719
2007    .3166947
2007    1.269084
2007           .
2007   2.6409075
2007   4.4947634
2007     .299351
2007    .9638934
2007    6.919998
2007    8.392946
2007   .52218056
2007    5.475002
2007  -2.6311014
2007    7.638823
2007    .2047386
2007   -.3716923
2007    .2277451
2007    7.063793
2007    3.456966
2007    3.605492
2007   -1.744603
2007   3.7386444
2007 -.013395297
2007    1.271706
2007    .9598436
2007    .9711722
2007           .
2007   2.3113792
2007   1.7022617
2007    .9037073
2007   4.2362847
2007  -.51972854
2007   1.8965033
2007    2.738862
2007   1.7962303
2007    3.277766
2007   1.3684353
2007  -1.5806698
2007    5.040575
2007   2.8463655
2007    5.175626
2007   1.1320717
2007  -1.0535102
2007   4.1478977
2007   .22367565
2007    3.129998
2007    2.974845
2007   .13270764
2007  -1.0844218
2007  -1.2206705
2007   1.5743947
2007   1.0277989
2007    9.680799
2007    .7968943
2007   1.1658322
2007   2.6951914
2007   1.3212745
2007   2.3283744
2007     1.71138
2007    2.426625
2007   .07527084
2007  -1.9530985
2007    .7230127
2007   1.2397583
2007           .
2007   4.1660347
2007    2.567915
2007        5.09
2007    5.203857
2007   3.6039736
2007   2.3880186
2007   1.5631795
2007   .11058354
2007    4.192075
2007    .3720328
2007    .6965938
2007      1.4504
2007   1.3559792
2007   1.1291096
2007     3.20364
2007  -.14818779
2007   2.3280053
2007  -.08839706
end

[Nick Cox]

Should work. I note that in your data example only one year is represented any way, so that is what you should expect.

[John Vourdas]

Hi, sorry for the poor example. Here is a longer one. As you can see the year varies within the sample. Any ideas?

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year float cet1rd
2007      6.319787
2007      .8103518
2007      5.568301
2007      2.931166
2007      .0833132
2007     2.0697572
2007      1.835691
2007     1.8721465
2007      5.056508
2007         .9624
2007     2.3189352
2007     1.2594864
2007     1.9739136
2007    .007285868
2007     -.3173395
2007      3.085304
2007     2.2035706
2007      1.141719
2007      .3166947
2007      1.269084
2007             .
2007     2.6409075
2007     4.4947634
2007       .299351
2007      .9638934
2007      6.919998
2007      8.392946
2007     .52218056
2007      5.475002
2007    -2.6311014
2007      7.638823
2007      .2047386
2007     -.3716923
2007      .2277451
2007      7.063793
2007      3.456966
2007      3.605492
2007     -1.744603
2007     3.7386444
2007   -.013395297
2007      1.271706
2007      .9598436
2007      .9711722
2007             .
2007     2.3113792
2007     1.7022617
2007      .9037073
2007     4.2362847
2007    -.51972854
2007     1.8965033
2007      2.738862
2007     1.7962303
2007      3.277766
2007     1.3684353
2007    -1.5806698
2007      5.040575
2007     2.8463655
2007      5.175626
2007     1.1320717
2007    -1.0535102
2007     4.1478977
2007     .22367565
2007      3.129998
2007      2.974845
2007     .13270764
2007    -1.0844218
2007    -1.2206705
2007     1.5743947
2007     1.0277989
2007      9.680799
2007      .7968943
2007     1.1658322
2007     2.6951914
2007     1.3212745
2007     2.3283744
2007       1.71138
2007      2.426625
2007     .07527084
2007    -1.9530985
2007      .7230127
2007     1.2397583
2007             .
2007     4.1660347
2007      2.567915
2007          5.09
2007      5.203857
2007     3.6039736
2007     2.3880186
2007     1.5631795
2007     .11058354
2007      4.192075
2007      .3720328
2007      .6965938
2007        1.4504
2007     1.3559792
2007     1.1291096
2007       3.20364
2007    -.14818779
2007     2.3280053
2007    -.08839706
2007             .
2007     -.6093275
2007      2.934478
2007       1.25353
2007             .
2007      .4105972
2007     .28382847
2007      .4484091
2007      1.295408
2007    -2.2643864
2007     -.4762305
2007        1.5352
2007      1.895921
2007     1.9490935
2007      .4149244
2007      10.15815
2007      2.645009
2007             .
2007    -2.2008739
2007     1.6524187
2007     -4.385074
2007      .8352641
2007      2.325083
2007     2.1140282
2007     3.6648636
2007    -1.0054283
2007    -1.6027547
2007    -2.3523188
2007      3.010156
2007      2.722979
2007     -.8592931
2007         .2704
2007      1.842749
2007      1.269389
2007    -1.2726885
2007             .
2007       5.66301
2007       3.33332
2007     1.4084498
2007      3.216428
2007       .872651
2007     1.7000134
2007     4.7578206
2007      .4375353
2007     1.8718238
2007      1.769101
2007     -.4956007
2007      .4342911
2007     4.2842655
2007     .56434524
2007    -3.6421394
2007      3.115186
2007    -2.3145254
2007     1.1679612
2007     1.7456052
2007         1.392
2007     3.5019374
2007      .8123947
2007      2.992866
2007     -5.683846
2007      -.825901
2007      3.878626
2007      2.799712
2007   -.000797524
2007      2.791826
2007    -.13069431
2007      .3118964
2007      6.945047
2007      7.066714
2007    -2.3675728
2007      2.609969
2007      3.680375
2007      2.671981
2007             .
2007     2.2793586
2007      1.534008
2007     1.0609447
2007     2.3364513
2007          .844
2007     -.4860979
2007     2.5876546
2007      2.840353
2007      1.391154
2007     2.6137674
2007      .7716444
2007     -.4462008
2007       .777845
2007     2.2254083
2007     -.1550653
2007       .661284
2007      6.602004
2007      3.333217
2007      .9394879
2007      2.778943
2007      2.860666
2007      7.330688
2007      1.581908
2007     -.9703912
2007      .6400002
2007     .13738707
2007     4.1195874
2007    -.18784145
2007      1.924708
2007      8.363158
2007     2.9760334
2007      .8290684
2007     .24797003
2007     2.1884906
2007     -2.578479
2007             .
2007     .19516107
2007     2.0257013
2007      2.474344
2007       .228227
2007             .
2007     -.9829432
2007      10.93157
2007     1.3329145
2007     1.9041795
2007       3.40528
2007      4.491939
2007      1.905882
2007      1.393778
2007    -12.817767
2007     1.3994987
2007     -.4674485
2007     1.6196407
2007      1.751227
2007    -.24712306
2007      2.836956
2007     1.5069437
2007      2.784218
2007     -.3368199
2007      .7109377
2007     4.4723005
2007      4.280196
2007      4.158896
2007     2.0804403
2007      1.521996
2007      6.546309
2007      5.202943
2007     2.3043098
2007      .6900622
2007       3.98168
2007     2.2611077
2007     1.1072738
2007      .9862443
2007     .18294723
2007      .7139474
2007     2.2181077
2007      .2118563
2007      2.822371
2007    -1.3400776
2007       3.20748
2007          1.16
2007      2.436004
2007     1.1439642
2007      .8712595
2007     -.9745273
2007     .13882042
2007         .8456
2007       .425487
2007   .0007334376
2007    -3.3688195
2007      2.841049
2007      .8483968
2007     1.9791965
2007    -1.2543534
2007     3.3919075
2007      8.395713
2007     2.9177444
2007      4.125553
2007      .8334274
2007     3.4627206
2007     3.0907626
2007      5.013237
2007    -.25973332
2007     2.5399196
2007     .16086277
2007      7.141382
2007             .
2007     -1.592446
2007        1.9144
2007     2.3798769
2007     -8.323855
2007    -.14484128
2007     4.6373906
2007    -2.5115266
2007     2.4430215
2007      4.804813
2007     -.7946438
2007      7.078093
2007      2.172003
2007     1.3373044
2007     1.9289957
2007     -7.929905
2007      1.802485
2007      2.995805
2007      .7253714
2007    -1.5215364
2007      3.446034
2007             .
2007       1.83366
2007          7.08
2007     4.0554924
2007     1.5327213
2007     2.3349965
2007        1.1392
2007     1.5343963
2007     -.9892627
2007     2.5636814
2007      5.318158
2007      2.479683
2007     1.4397113
2007     -.7909437
2007     1.0560967
2007     2.2116218
2007      .4324204
2007      2.149703
2007     1.9289652
2007     2.2770617
2007     -4.068598
2007      5.683889
2007      3.671296
2007      .8131152
2007         .6504
2007        1.2672
2007     .13619344
2007     1.1120955
2007     4.7435126
2007     4.3187475
2007             .
2007      4.777544
2007      .3818639
2007       .436863
2007     2.3694239
2007      3.223405
2007     4.6607876
2007      3.898397
2007     2.3823597
2007        3.0839
2007      1.253368
2007     4.2764997
2007     1.1066835
2007     .26531458
2007          .844
2007     .13581772
2007     .49012595
2007      .6046868
2007    -.08914767
2007      .9399178
2007      1.800389
2007    .007458616
2007     2.1183367
2007       .852244
2007      3.629029
2007     3.1570764
2007     -.9821445
2007         .4152
2007      6.739518
2007          .352
2007     2.9477735
2007      8.498193
2007      5.157678
2007     .04339978
2007     1.9634846
2007      1.931485
2007      -.882592
2007        2.4136
2007     1.8801588
2007   -.009236888
2007             .
2007       .644102
2007     4.6627374
2007      6.299322
2007     1.8652806
2007     -.8357254
2007      .9299308
2007  .00022470225
2007      3.693021
2007     -.7642062
2007      .6931032
2007     -.5419742
2007      5.019024
2007     -2.212071
2007      5.695998
2007      4.476565
2007      6.854537
2007    -2.1311216
2007     1.8887633
2007     2.1318052
2007     -1.386762
2007     1.0075796
2007        1.5864
2007       3.13962
2007      .7513637
2007      -.708152
2007     1.3907193
2007      1.996245
2007      2.015733
2007      7.581142
2007      4.115984
2007     -6.068182
2007             .
2007      .0977357
2007      .3242212
2007      7.208864
2007      2.468591
2007      .7908612
2007       2.74585
2007     1.9346358
2007     3.5947006
2007      6.085577
2007     2.6406126
2007     -1.366947
2007      3.491037
2007     1.1049538
2007      2.578718
2007     1.9830207
2007     1.5109074
2007      3.477055
2007         .8344
2007     2.2448313
2007     2.3844924
2007     .01235613
2007     2.2214153
2007      8.568006
2007     -.1581905
2007     -.1388895
2007      2.805988
2007      .6195235
2007     2.3608644
2007      2.950135
2007      1.892061
2007     -.2341859
2007             .
2007    -.50152993
2007      1.875979
2007      .2758261
2007          2.35
2007         1.144
2007    -2.1086092
2007      -.638163
2007      .4457022
2007     1.8949704
2007      3.246759
2007      .5972359
2007          .772
2007    -2.3663638
2007     .02011111
2007      5.454744
2007      .8322968
2007    -1.0069019
2007     1.6437773
2007     1.8592384
2007      .4699922
2007      9.137698
2007     3.9109426
2007      8.232503
2007      .6741974
2007     2.5866466
2007     -3.066989
2007           1.1
2007      4.894318
2007   -.020022787
2007     -.9075156
2007      .8139092
2007      .8332478
2007      .9884458
2007      .5301501
2007      7.042929
2007     -.7748598
2007      6.543886
2007     .21848933
2007     2.2710369
2007     -3.704522
2007     2.2870114
2007      2.520662
2007         .7104
2007     -.7180216
2007       .799966
2007      .8175453
2007      2.420436
2007      1.182757
2007     -.2469981
2007      5.846848
2007             .
2007    -1.1648467
2007     4.1190524
2007      .4653068
2007      1.209835
2007      2.238358
2007     2.1823423
2007       3.10919
2007     -.4796276
2007             .
2007     1.0873196
2007      2.264105
2007     -.4732472
2007     1.7678173
2007     -.9574634
2007     1.4690777
2007      3.228307
2007     -2.219121
2007     1.6903194
2007       2.71238
2007    -.21278495
2007             .
2007      1.355039
2007     1.4792496
2007      -.373007
2007      3.100061
2007      4.863777
2007     -.8855178
2007      5.063611
2007     4.0445204
2007     2.2887988
2007        1.6072
2007    -1.0273843
2007      3.768876
2007      5.558958
2007      2.737326
2007     -1.489159
2007   -.006124852
2007     1.0260056
2007   .0015809563
2007      .6280941
2007     3.7575605
2007    -2.9847636
2007     .11099841
2007      1.407197
2007       .737929
2007     2.8105686
2007     -.9216654
2007     2.3259842
2007      6.869234
2007      .7418511
2007     1.5673622
2007    -1.5561224
2007      .3996634
2007      .0900818
2007     2.6047235
2007      .6372141
2007      3.968358
2007       8.59904
2007     1.2336192
2007     1.0912967
2007     1.7534312
2007     -1.432513
2007      2.027679
2007     2.9426234
2007             .
2007     4.6778007
2007     1.7553884
2007     .08605974
2007     -6.325215
2007     1.9020954
2007      1.120644
2007      .8164954
2007      2.797457
2007      2.566546
2007    -2.2935524
2007     4.5679083
2007    -1.1350503
2007       3.10101
2007     3.6538706
2007      1.249369
2007      3.131844
2007      .9161769
2007         .8456
2007      3.122344
2007      .3818999
2007       2.86134
2007      2.874027
2007    -.28438693
2007      3.027821
2007     1.0010908
2007      2.523503
2007             .
2007     2.3543475
2007     -1.745189
2007             .
2007     1.0019543
2007     -6.056791
2007     -.3245967
2007      3.720536
2007      1.264428
2007      3.698771
2007      1.689043
2007    -2.0328057
2007      .4691058
2007         .6176
2007     3.0723245
2007        2.2349
2007     2.7053244
2007      3.085619
2007     1.1903727
2007      1.720654
2007     -3.224976
2007    -1.1557847
2007      6.454612
2007     -.2387446
2007     .11334502
2007     .34004995
2007      1.002768
2007     4.6037517
2007    -.20743133
2007     -2.675461
2007    -.54623437
2007     1.6681135
2007      7.794127
2007      1.673249
2007     1.5715635
2007             .
2007     1.6659898
2007       .421328
2007      5.544168
2007      4.533603
2007     1.2895753
2007     1.1805774
2007     -.7115706
2007     2.2692323
2007      1.362492
2007     -2.106306
2007          7.44
2007      .4217863
2007    -1.6003283
2007     2.0758357
2007    -2.2239835
2007     1.8044016
2007      .6676053
2007     2.1245086
2007             .
2007      1.220056
2007      1.623464
2007     -.5696237
2007      2.671126
2007     -.6596759
2007     3.7779014
2007    -1.0253563
2007     -.0369413
2007     2.2254448
2007     1.7152134
2007      6.995798
2007      4.539597
2007   -.018211007
2007         1.448
2007        1.2992
2007             .
2007    -.03108914
2007      .3198016
2007             .
2007      1.306677
2007    -1.1107581
2007           1.6
2007      6.889152
2007      3.188994
2007    -.08388687
2007      .9477652
2007     .05092772
2007      2.499854
2007      8.806178
2007      .5928414
2007     1.5433158
2007      .8242354
2007      2.689083
2007     1.5504524
2007             .
2007     4.4373612
2007       2.86134
2007     .02054455
2007    -.29481882
2007         1.424
2007      .6280107
2007      .8021154
2007     1.7439774
2007      3.087513
2007     1.9497504
2007    -1.7189227
2007     2.1550922
2007     1.2288833
2007     -.7556577
2007      3.112719
2007    -1.3024513
2007     -3.195568
2007      5.694438
2007      -7.35957
2007     2.5098004
2007     1.4379227
2007      2.657043
2007      .8443393
2007     1.4377457
2007      .6337448
2007      2.679611
2007             .
2007         1.596
2007      3.438076
2007    -4.4019804
2007     2.0127463
2007     1.1662353
2007             .
2007      3.827055
2007      2.790797
2007      4.691727
2007     .26505747
2007      5.323905
2007     -2.307258
2007     .19801016
2007      6.750077
2007      2.626332
2007        3.2528
2007      2.960061
2007      .1919577
2007     .09156482
2007     -.3383683
2007       .991313
2007      .4799165
2007    -.12405241
2007      1.567507
2007     -.7480698
2007     .02863425
2007        1.6024
2007     1.7273173
2007      .5737147
2007      3.401628
2007     4.5492454
2007     .14227779
2007       2.90719
2007     3.3545134
2007    -1.8815278
2007    -.26661474
2007     1.0564002
2007     2.1365433
2007     -.9774858
2007     .07421177
2007     2.1344354
2007     1.6989614
2007     1.9591004
2007       .702977
2007      2.511241
2007     .15417373
2007      .9129339
2007             .
2007    -1.0648925
2007         1.325
2007     .15536276
2007             .
2007    -1.9580673
2007     3.8792584
2007      2.632904
2007     2.6142116
2007     -4.976941
2007     1.8099145
2007             .
2007             .
2007     4.3575535
2007        1.3496
2007      1.774123
2007   .0040385555
2007    -.05798725
2007   -.002716705
2007      .7452797
2007      2.706754
2007      2.565286
2007      6.917716
2007             .
2007       .140089
2007         1.452
2007      3.535529
2007    -.27448472
2007          2.44
2007     1.3809905
2007      .3897496
2007     11.830365
2007  -.0006772414
2007      4.097826
2007      2.925878
2007          2.46
2007    -1.5437486
2007      1.143363
2007      2.670454
2007      .4329402
2007      5.204256
2007        2.5256
2007      -.968906
2007     1.6931462
2007      5.619008
2007        1.1232
2007      1.007669
2007      2.660467
2007      .3547329
2007     -3.493638
2007      5.481191
2007     4.2820253
2007     .12074541
2007     -.4135605
2007      5.435274
2007     2.0187166
2007     1.9343318
2007      5.592807
2007     1.7899665
2007             .
2007      3.380378
2007     1.3743664
2007     10.791933
2007      2.972742
2007     .44368255
2007      3.094307
2007      .8383109
2007    -.29414004
2007     -.3019502
2007     3.3499074
2007     1.7803445
2007      .8626537
2007      3.286674
2007     2.7142015
2007      1.944497
2007     4.2201424
2007     1.8034015
2007     .17505635
2007     1.5362046
2007    -.12710738
2007    -2.3019104
2007     1.6781355
2007      .7163491
2007     1.8558793
2007     -.6134676
2007      1.562301
2007     1.6970944
2007     1.5270452
2007      7.827407
2007      5.034879
2007      4.032757
2007    -.19320375
2007      2.727071
2007     1.7141287
2007     1.2368008
2007     1.2671304
2007 -.00019960676
2007       2.27746
2007     1.0133638
2007       2.61725
2007      4.715005
2007      5.240203
2007    -.04071132
2007      6.052392
2007             .
2007     4.7430706
2007      .9922013
2007      2.384491
2007      .7149752
2007      5.543725
2007     2.2467933
2007      2.674318
2007     .10468306
2007     4.2529883
2007      .8835992
2007     4.1090345
2007     1.7762403
2007    -1.6245662
2007      5.482752
2007    -1.8494247
2007        1.0192
2007      2.623099
2007      2.707265
2007     1.1698225
2007      .9021999
2007        2.6488
2007     -5.918653
2007      .8252808
2007         .7552
2007       2.86144
2007     1.5045033
2007    -1.0949948
2007      9.530328
2007         2.544
2007     .44067025
2007      .9125272
2007      5.116704
2007     .08598953
2007     .19205765
2007      4.411118
2007      .6226715
2007     -3.893681
2007     -.9448809
2007      6.168139
2007     -2.681378
2007      3.704086
2007     1.3054882
2007     2.2311437
2007     2.1785684
2007      4.252647
2007     -1.249364
2007      2.684491
2007     .11564754
2007      2.615024
2007      .9564692
2007       .330456
2007     1.3202022
2007     23.153915
2007      3.544477
2007      1.969986
2007             .
2007      1.310255
2007     1.1936673
2007     .17763437
2007      6.673887
2007     2.2237039
2007      1.598172
2007      1.259578
2007     -.6951827
2007    -.21648525
2007      .3442528
2007     2.2218962
2007      3.335716
2007      .5640705
2007     1.2715192
2007     1.2642412
2007       .740891
2007      .5439512
2007      .6436318
2007     -1.200192
2007     1.5281477
2007      4.785796
2007      .9962386
2007      .4705747
2007     -.2879181
2007      1.273137
2007     .10082707
2007      5.682035
2007    -.05590178
2007     .11380275
2007    -1.0574039
2007    -1.4619837
2007      1.084238
2007     .09776682
2007    -4.2688274
2007      .3220279
2007    -.42630395
2007     1.6225244
2007    -1.8638272
2008     1.4397113
2008     1.9739136
2008     1.3329145
2008     .13581772
2008     2.7142015
2008      2.840353
2008     1.6781355
2008      .8334274
2008      .6280107
2008      1.306677
2008     4.6607876
2008      4.115984
2008     -.4956007
2008             .
2008     1.6196407
2008    -.21278495
2008         .8456
2008     -.0369413
2008      .8164954
2008     2.6047235
2008      1.220056
2008     -3.224976
2008     1.7962303
2008      4.715005
2008      .3220279
2008     -.4674485
2008       2.86134
2008    -.08839706
2008         1.392
2008     1.9289652
2008      5.204256
2008     2.8463655
2008     .02054455
2008      2.722979
2008     1.8652806
2008             .
2008      6.889152
2008      .8175453
2008      3.671296
2008      4.158896
2008     -.6134676
2008      .4217863
2008        1.5352
2008     2.2710369
2008      3.286674
2008      2.841049
2008      .8712595
2008      .3547329
2008    -.26661474
2008     1.8044016
2008             .
2008      4.411118
2008     1.5673622
2008      .3720328
2008     2.3880186
2008      2.684491
2008     2.3349965
2008      .3818999
2008      4.863777
2008      8.498193
2008      5.116704
2008     4.2529883
2008      3.491037
2008        1.1392
2008     4.1190524
2008      4.539597
2008     1.2397583
2008     2.1183367
2008          7.08
2008     1.0019543
2008      .8483968
2008      1.143363
2008      1.249369
2008       .228227
2008      .8322968
2008     .19801016
2008          .844
2008     2.2448313
2008     1.7678173
2008     4.6778007
2008      3.544477
2008     .13882042
2008     2.2214153
2008      6.299322
2008     1.0010908
2008      2.706754
2008      5.013237
2008      2.874027
2008      2.790797
2008      7.141382
2008     .11380275
2008     1.6931462
2008     2.6137674
2008      4.192075
2008     2.0257013
2008     .07421177
2008     3.5019374
2008      3.087513
2008      2.860666
2008   -.018211007
2008   -.013395297
2008      4.476565
2008     2.3113792
2008   .0007334376
2008      3.446034
2008     1.3202022
2008     2.3364513
2008     -3.195568
2008      5.694438
2008    -.14818779
2008      5.175626
2008    -1.5437486
2008     1.8887633
2008      .4324204
2008      3.535529
2008      .6195235
2008     2.3043098
2008      2.149703
2008      .6372141
2008     .52218056
2008      2.925878
2008             .
2008     2.9177444
2008      .8443393
2008      2.689083
2008      5.619008
2008     -.4135605
2008      1.295408
2008    -2.9847636
2008     .02011111
2008      2.995805
2008      .7452797
2008     .17763437
2008     1.2642412
2008         1.452
2008     3.5947006
2008     2.2611077
2008     2.3694239
2008      5.318158
2008     -4.385074
2008      .2758261
2008     .13619344
2008     4.5492454
2008           1.1
2008     4.2764997
2008     1.0260056
2008      8.395713
2008      .5640705
2008      1.835691
2008             .
2008      3.131844
2008     2.2793586
2008     .15536276
2008      .6931032
2008      1.269084
2008      .6226715
2008       2.61725
2008      .7139474
2008    -.12710738
2008    -1.1350503
2008      .3198016
2008      .8835992
2008      .7908612
2008     -.7642062
2008         .4152
2008     -1.366947
2008      2.468591
2008     2.3844924
2008    -2.3145254
2008      3.122344
2008      4.804813
2008      3.027821
2008     1.3212745
2008      2.578718
2008      .2118563
2008      9.530328
2008      1.802485
2008      .6280941
2008     4.5679083
2008    -.27448472
2008     1.5504524
2008     1.6524187
2008     -8.323855
2008        2.6488
2008      5.482752
2008      .3996634
2008      .7716444
2008      .9862443
2008          .772
2008      -.825901
2008     1.7553884
2008     .17505635
2008      8.392946
2008      1.800389
2008   -.006124852
2008      2.805988
2008     3.7575605
2008      .4342911
2008      4.777544
2008      1.769101
2008     .09156482
2008     2.1344354
2008      -.373007
2008     1.4792496
2008    -2.1311216
2008   -.009236888
2008     -.4732472
2008     .19205765
2008      5.056508
2008     -.7115706
2008     -.3368199
2008    -1.3024513
2008     1.7762403
2008      .3897496
2008     3.9109426
2008      2.727071
2008     -.9703912
2008     .26531458
2008       .299351
2008      2.566546
2008      10.93157
2008     2.2692323
2008     .11564754
2008      .8626537
2008     1.7899665
2008     -4.976941
2008      6.168139
2008      6.454612
2008     .56434524
2008     1.9791965
2008      2.738862
2008     -.3019502
2008      -.638163
2008     3.3545134
2008      .7253714
2008    -1.3400776
2008      .9711722
2008      .8252808
2008    -.24712306
2008      .6900622
2008        1.4504
2008             .
2008     2.5876546
2008     3.4627206
2008        1.5864
2008      1.310255
2008      .5737147
2008      .9884458
2008     -.7946438
2008     1.3054882
2008      2.972742
2008      5.682035
2008       .777845
2008      .9598436
2008     .11099841
2008     -.3245967
2008     4.1660347
2008     1.1049538
2008             .
2008     4.1090345
2008     -1.592446
2008     -1.489159
2008             .
2008      6.750077
2008     1.1936673
2008     -.7480698
2008     -2.219121
2008    -.21648525
2008    -12.817767
2008     1.3994987
2008      10.15815
2008     -2.681378
2008     -.9216654
2008      .4329402
2008     .05092772
2008      .4105972
2008     2.0187166
2008     .49012595
2008      1.567507
2008         1.424
2008      .8290684
2008    -1.0574039
2008        1.0192
2008     -.3173395
2008      2.836956
2008      6.602004
2008       3.10101
2008      .5928414
2008      6.052392
2008     -2.578479
2008      1.273137
2008     -.7909437
2008     1.9343318
2008     2.3543475
2008     .02863425
2008      1.751227
2008             .
2008     -1.200192
2008      5.683889
2008      3.094307
2008    -.13069431
2008     1.9591004
2008      3.401628
2008      1.689043
2008          .352
2008     1.8718238
2008     4.1478977
2008     2.6406126
2008     .13738707
2008       .852244
2008     -.9892627
2008    -.20743133
2008     2.0697572
2008      1.892061
2008    .007285868
2008      1.521996
2008     .14227779
2008             .
2008    -1.7189227
2008     1.6681135
2008    -1.6027547
2008             .
2008     -.4860979
2008      1.895921
2008     2.3798769
2008      2.960061
2008     3.7386444
2008     2.6142116
2008      1.141719
2008    -2.2935524
2008      2.931166
2008     2.2181077
2008      5.846848
2008      .2277451
2008     1.5743947
2008    -.29481882
2008     1.7803445
2008     -6.056791
2008     1.9020954
2008      5.034879
2008      1.271706
2008     1.0912967
2008     -2.212071
2008    -1.0535102
2008     2.9760334
2008     .10468306
2008      2.436004
2008       3.13962
2008     .15417373
2008             .
2008     1.0564002
2008      4.252647
2008     -.3383683
2008      8.363158
2008      5.592807
2008             .
2008      1.598172
2008    -4.2688274
2008     2.0758357
2008      3.115186
2008      2.499854
2008             .
2008     .07527084
2008      3.605492
2008             .
2008      2.511241
2008      2.520662
2008     2.2237039
2008     1.1662353
2008      1.924708
2008     1.5045033
2008    -.51972854
2008    -1.0054283
2008             .
2008     1.7022617
2008      5.568301
2008      .9962386
2008     1.3373044
2008     1.1120955
2008     3.0723245
2008     .11058354
2008      3.112719
2008     1.3809905
2008  -.0006772414
2008      3.720536
2008    -2.3019104
2008      2.657043
2008      2.950135
2008       .740891
2008      1.084238
2008      6.543886
2008      7.330688
2008     .44067025
2008     .01235613
2008        1.1232
2008      .9394879
2008      7.638823
2008    -1.1107581
2008     2.5098004
2008     .26505747
2008         .7104
2008      2.426625
2008      2.934478
2008     -.6093275
2008     -.9574634
2008     -.2469981
2008      .3442528
2008       .702977
2008    -4.4019804
2008     1.8034015
2008     23.153915
2008             .
2008          2.35
2008      3.223405
2008    -1.0949948
2008     1.8558793
2008      .6965938
2008     -1.745189
2008             .
2008     1.6225244
2008      5.475002
2008         1.596
2008      2.384491
2008      .8131152
2008          5.09
2008     1.3907193
2008      7.208864
2008      6.945047
2008      5.558958
2008     4.7578206
2008     1.1439642
2008             .
2008       2.74585
2008    .007458616
2008      7.042929
2008      -.708152
2008       .991313
2008     4.4723005
2008    -3.6421394
2008     2.2218962
2008     -1.249364
2008      .8021154
2008    -1.6003283
2008     2.1140282
2008      5.481191
2008      3.335716
2008    -.04071132
2008     1.1698225
2008      2.325083
2008             .
2008     1.0609447
2008     -.5419742
2008      1.182757
2008      2.679611
2008      3.693021
2008     1.5362046
2008     -5.918653
2008        1.2992
2008     -5.683846
2008    -.19320375
2008     .28382847
2008     -4.068598
2008      3.477055
2008      9.680799
2008      2.660467
2008    -.05590178
2008    -1.0253563
2008     2.9426234
2008     -.5696237
2008         .6504
2008             .
2008      1.931485
2008      5.019024
2008      1.842749
2008      .9299308
2008      .6676053
2008      .0833132
2008      8.232503
2008             .
2008     -.9075156

end

[Nick Cox]

OK, so now two years in the sample, so you will get different results.

. egen n = count(cet1rd), by(year)

. egen median = median(cet1rd), by(year)

. tabdisp year, c(n median)

----------------------------------
     year |          n      median
----------+-----------------------
     2007 |        904      1.4492
     2008 |        458    1.359147
----------------------------------

Using a by() option rather than a prefix is immaterial here; otherwise what did you do or get differently? (No egen code and no results in #3).