Announcement

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

  • Disappearing observations when plotting data on a graph

    Dear Statalist,

    I have an issue with "disappearing" observations. I'm using the user-contributed -traj- package to plot trajectories of lung function. I have tried using t* (date of participation) on the x axis, and this works fine. But when I try to plot the graph using chronological age (age in years), observations in both ends are dropped. I cannot figure out why, and wonder if anyone have any ideas based on the syntax below?

    Code:
    ** Generate time variables from the first date in our data material (Oct 3 95) **
    gen t1 = PartDat_1 - 13059
    
    gen t2 = PartDat_2 - 13059
    
    gen t3 = PartDat_3 - 13059
    
    gen t4 = PartDat_4 - 13059
    
    gen t5 = PartDat_5 - 13059
    
    forval i = 1/5 {
    replace t`i' = t`i'/365.25
    }

    This one works fine, and creates the graph I'm expecting (using date of participation):

    Code:
    traj, var(FEV1_1 FEV1_2 FEV1_3 FEV1_4 FEV1_5) indep(t1-t5) risk (Sex) model(cnorm) min(-999) max(999) order(2 2 2 2 2 2 2 2 2)
    
    trajplot, xtitle(Time(years)) ytitle(ppFEV1) xlabel(0(1)25) ylabel(50(10)130)
    Click image for larger version

Name:	Statalist1.PNG
Views:	1
Size:	17.7 KB
ID:	1691691




    Whereas this one doesn't (age span should be 13-43 y):

    Code:
    traj, var(FEV1_1 FEV1_2 FEV1_3 FEV1_4 FEV1_5) indep(age1 age2 age3 age4 age5) risk (Sex) model(cnorm) min(-999) max(999) order(2 2 2 2 2 2 2 2 2)
    
    trajplot, xtitle(Age(years)) ytitle(ppFEV1) xlabel(13(1)43) ylabel(50(10)130)

    Click image for larger version

Name:	Statalist2.PNG
Views:	1
Size:	17.5 KB
ID:	1691692



    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input float(id t1 t2 t3 t4 t5) double(age1 age2 age3 age4 age5 FEV1_1 FEV1_2 FEV1_3 FEV1_4 FEV1_5 Sex)
      1  1.4592744         .         .  12.52019         . 18.1    .    . 29.1    .   86.62      .      .  65.2       . 1
      2   1.155373  5.119781         .  12.12868  22.65024 13.8 17.7    . 24.7 35.3       . 80.422      .  88.2  39.961 1
      3          .         . 12.194387         . 22.288843    .    . 16.1    . 26.2       .      . 88.291     .  56.984 0
      4  1.2046543         .         .         .  22.06434 14.6 18.5    .    . 35.4  97.032      .      .     .   53.89 0
      5  1.3716632         .         . 12.399726 22.056126 17.2    .    . 28.2 37.8  53.001      .      .     .  37.752 1
      6          .         . 11.175907         .  23.37577    .    . 13.3    . 25.5       .      . 96.777     .  65.761 1
      7  1.4373716         .         . 12.670774  23.36208 17.2    .    . 28.5 39.2  82.154      .      .  66.6  47.019 0
      8   .9965777         .         .         .   22.7269 17.3    .    .    . 39.1  75.449      .      .     .  97.719 0
      9  1.5879534   5.28679         . 12.438056         . 14.9 18.5    . 25.8 35.5  76.377  75.55      . 113.8       . 0
     10   .3504449         .         . 11.315537  22.99521 15.8    .    . 26.8 38.4  78.165      .      .  96.7  88.194 0
     11   .6680356 4.4490075         . 11.334702   23.9206 15.3 19.1    .   26 37.4  77.537 84.078      . 102.4  92.486 1
     12   .5722108         .         . 12.706366  23.05818 18.3    .    . 30.4 40.8  75.976      .      .  99.5  97.592 0
     13  .57494867         .         .         .  22.63381 17.3    .    .    . 39.4  75.449      .      .     .  95.047 0
     14   .6160164         .         . 11.419576         . 16.3    .    . 27.1    .  62.951      .      .  98.3       . 0
     15  1.5523614         .         .         .  22.32991 14.2    .    .    .   35  73.775      .      .     .  93.855 0
     16  1.3086927         .         . 12.517454  22.02601 13.2    .    . 24.5   34  69.831      .      .  92.5  92.198 1
     17 .021902807 4.4490075         .  12.06297   23.8193 12.9 17.3    .   25 34.9  68.858 93.152      .     .  91.481 0
     18          .         . 12.073922         .  22.32991    .    . 15.2    . 25.4       .      . 74.233     . 110.357 1
     19    .366872         .         .   12.6872 23.039015 18.2    .    . 30.5 40.9  71.952      .      .  93.2  91.327 0
     20   .9993156  5.034908         . 12.569473   23.9206 13.8 17.9    . 25.4 35.4    72.1 98.985      .     .   95.29 0
     21  1.5550992         .         .         . 23.915127 15.1    .    .    . 35.7  74.257      .      .     .   91.89 0
     22  1.3251197  5.371663         . 11.520876         . 14.6 18.5    . 24.8 36.4  71.706 82.674      .  92.1       . 0
     23  .07392197         .         .         . 22.045174 14.9    .    .    . 36.8   68.34      .      .     .  93.376 1
     24   .6160164         .         . 11.559206   23.8193 15.5    .    . 26.4 37.4  72.439      .      .  90.3  98.769 0
     25   .4435318         .         .  11.24983         . 13.3    .    . 24.1   35  53.786      .      .  99.4       . 0
     26   .3531828         .         . 11.367557 22.899384 14.8   19    . 25.8 37.4    63.7      .      .  92.5  87.243 1
     27   .3832991         .         . 12.503764 23.915127   17    .    . 29.1 39.3  71.727      .      .     .  99.243 0
     28   .3477071         .         . 11.326488         . 14.3    .    . 25.3    .  77.094      .      . 109.2       . 0
     29   .4845996         .         . 11.411362         . 18.4    .    . 29.4    .  73.304      .      . 103.8       . 0
     30  1.1279945         .         .         . 22.540726 15.5    .    .    . 36.9  66.876      .      .     .  103.47 0
     31   .4380561         .         . 11.195072         . 15.4    .    . 26.1   38  78.223      .      . 101.9       . 0
     32   .3531828         .         . 11.329226 23.000685 14.5 18.8    . 25.5 37.2  73.854      .      . 102.1  99.423 0
     33   1.284052 4.7008896         . 12.301164  22.19028 14.7 18.1    . 25.8 35.7  74.802 97.593      . 100.4  98.454 0
     34  .26830938         .         .  11.87132         . 17.7    .    . 29.3    .  70.969      .      . 105.3       . 1
     35   .3449692         .         .         . 23.000685 13.7    .    .    . 36.3  70.349      .      .     . 102.194 0
     36          0         .         . 11.980835 22.017796   15    .    .   27   37  68.786      .      .     .  82.327 1
     37   .3312799  5.371663         . 11.345654  23.79466 13.5 18.4    . 24.5 36.1  72.112 84.447      .  64.3   80.48 1
     38          .         . 11.520876         .  23.79466    .    . 14.4    .   25       .      . 65.736     .  64.925 0
     39  1.1389459         .         .  12.03833         . 13.9    .    . 24.8    .  72.926      .      .  73.7       . 0
     40          .         . 11.545517         . 22.554415    .    . 15.6    . 26.6       .      . 73.362     .  56.341 1
     41   .9774128         .         . 12.147844 22.540726 18.5    .    . 29.7 40.1  69.758      .      .  77.1  73.953 1
     42   .5338809         .         .  11.65503         . 18.2    .    . 29.4    .  69.283      .      .    61       . 0
     43          .         . 12.323067         .  22.21492    .    . 17.5    . 27.4       .      . 64.993     .  76.751 0
     44  1.6646132         .         . 12.339494         . 14.2 17.7    . 24.9    .  69.496      .      .  57.2       . 1
     45   1.629021         .         . 12.588638  23.15674 14.2    .    . 25.2 35.7  64.582      .      .  66.3  61.647 0
     46  .57494867         .         . 11.613963 22.466805   17    .    . 28.1 38.9  68.636      .      .  76.9   77.21 1
     47   .1889117         .         . 11.696098         . 16.3    .    . 27.8 38.2  73.791      .      .    58       . 0
     48  .15331964         .         .         . 23.000685 17.8    .    .    . 40.7  67.654      .      .     .  69.433 1
     49   .4626968         .         .         .  22.72964 18.9    .    .    . 41.1  65.465      .      .     .  91.719 1
     50   .1560575         .         . 12.071184  22.29158 13.9    .    . 25.8   36  62.291      .      .     .  73.904 1
     51   .6132786         .         . 11.561944         . 16.2 20.3    . 27.2    .  64.921      .      .  76.3       . 1
     52   1.155373         .         . 11.983573 23.802876 13.5    .    . 24.3 34.3  68.236      .      .  79.7  79.678 0
     53  1.1307324         .         . 11.994524  22.59822 14.7    .    . 25.5 36.1  67.305      .      .  79.1  68.085 1
     54   1.629021         .         . 11.939767  22.06434 17.4    .    . 27.7 37.8  62.354      .      .  88.9  64.185 1
     55   .4188912         .         .  11.66872  23.93429   17    .    . 28.2 39.1   72.38      .      .    74  92.038 0
     56          .         . 11.055442         .   23.8193    .    . 17.5    . 29.8       .      .  74.27     .   63.18 0
     57          .         .  12.30664         . 22.004107    .    . 16.9    . 26.6       .      . 71.571     .  71.909 0
     58          .         .  11.13484         .  23.79466    .    . 18.7    . 30.1       .      . 74.154     .  74.941 0
     59   .6570842         .         . 11.367557         . 13.9 17.7    . 24.6    .  74.644      .      .  74.2       . 1
     60          .         .  11.05818         . 22.899384    .    . 17.7    .    .       .      . 72.435     .  79.693 0
     61   .9664613         .         . 12.386037  21.94661 17.2    .    . 28.6 38.2  68.462      .      .     .  87.489 0
     62   .3230664         .         .  12.59685 23.915127 16.8    .    .   29   39  73.676      .      .     .  67.027 1
     63   .6351814         .         .         .  23.93429 14.2 18.1    .    . 36.3  68.777      .      .     .  66.715 1
     64          .         . 11.690623         .   21.9603    .    . 15.4    . 25.7       .      . 75.804     .  54.709 1
     65          .         . 11.926078         .  23.93429    .    . 17.4    .   28       .      . 76.166     .  70.158 0
     66  1.4209446         .         .         .  22.32991 19.9    .    .    . 40.8  67.216      .      .     .  87.525 0
     67   .4435318         .         .         . 22.160164 17.8    .    .    . 39.5  61.596      .      .     .  94.963 1
     68  .17522246         .         .         .  21.98768 17.1    .    .    . 38.9   73.42      .      .     .  66.606 0
     69    .476386         .         . 11.383984   23.8193 18.7    .    . 29.6 41.4  68.295      .      .  74.6  80.575 1
     70  .07665982         .         . 12.156057 22.160164 14.6    .    . 26.7 36.6  73.977      .      .     .  63.861 0
     71  1.2073922  5.119781         . 11.074607         .   13 16.8    . 22.8    .    75.9 71.225      .  66.6       . 0
     72   1.557837  5.371663         . 12.626967 23.091034 14.4 18.1    . 25.4 35.9  72.213 69.478      .  73.4  70.619 0
     73  1.3305955         .         . 11.482546         . 15.3   19    . 25.5 37.1  83.972      .      . 104.6       . 1
     74   1.303217   5.28679         .  11.44148  23.34018 15.1   19    . 25.3 37.2 101.927 92.883      .  97.1  93.713 0
     75          .         . 11.460644         . 22.537987    .    .   14    . 25.1       .      . 85.736     .  85.968 0
     76  1.4620123         .         . 12.323067  22.30527   17    .    . 27.8 37.8  93.302      .      .  88.3  84.194 0
     77  .20807666         .         . 11.830254 22.121834 18.2    .    . 29.8 40.1  92.875      .      .  91.4  94.717 0
     78          .         . 11.367557         .  23.78645    .    . 16.9    . 28.6       .      . 84.615     .   93.98 1
     79   .6324435         .         . 11.310061         . 15.5    .    . 26.2    .  95.518      .      .  95.9       . 1
     80   .4380561         .         . 11.611225         . 17.3    .    . 28.5 39.4  96.266      .      .  89.4       . 0
     81  1.6399726         .         . 11.901438 23.791924 17.7    .    .   28 38.2  92.279      .      .  96.2  95.849 0
     82          .         . 11.000685         . 23.868584    .    . 14.2    . 25.8       .      . 86.912     .  86.881 0
     83          0         .         . 12.328542  22.15195 15.5 20.2    . 27.8 37.7  89.528      .      .  95.9  96.193 1
     84          .         . 11.329226         . 23.868584    .    . 14.6    . 26.3       .      . 102.25     .  88.003 0
     85   .3696099         .         .  11.65503 22.540726 18.4    .    . 29.6 40.5   92.39      .      .  92.9  92.887 1
     86    .366872         .         .  11.27173 22.658453 17.2    .    . 28.1 39.5  89.706      .      . 101.8 100.688 1
     87   .4188912         .         .         . 23.304586 17.7    .    .    . 40.6  96.955      .      .     .  92.813 0
     88  1.3661876         .         .         .    22.141 19.5    .    .    . 40.3  90.749      .      .     .  93.446 1
     89  1.0896646         .         .         .  23.93429   14    .    .    . 35.4  87.612      .      .     .  95.821 1
     90   .3613963         .         . 11.419576         . 18.9    .    . 29.9    .  96.941      .      .  96.5       . 1
     91          .         . 11.460644         .  23.79466    .    . 18.3    . 30.1       .      .      .     .  82.598 0
     92  .13689254         .         .  12.09035  23.93429 18.4    .    . 30.4 40.8  87.729      .      .     .  89.458 0
     93          .         .  12.05202         .  22.21766    .    . 15.8    .   26       .      . 93.729     .  91.891 0
     94   .6324435         .         . 11.296372         . 15.8    .    . 26.5    .   86.67      .      .  89.4       . 1
     95  1.0924025         .         .         .  22.58179 13.7    .    .    . 35.2 103.556      .      .     .  83.587 1
     96          .         . 11.997262         . 22.212183    .    . 16.1    . 26.3       .      . 91.751     .  91.357 0
     97          .         . 11.304585         . 22.962355    .    . 13.9    . 25.6       .      . 97.265     .  89.224 1
     98   1.319644 4.4490075         .  12.52293 22.058865   16   19    . 27.2 36.7  89.907 86.437      .  94.4  86.683 0
     99   .4435318         .         . 11.904175         .   17    .    . 28.5    .  88.185      .      . 100.9       . 1
    100   1.190965   5.28679         . 12.210814         . 13.4 17.3    . 24.4    .  78.532  91.04      .  96.6       . 0
    end
    label values Sex Sex
    label def Sex 0 "Kvinne", modify
    label def Sex 1 "Mann", modify

  • #2
    Hi. Thank you for taking time to reply. I have the same problem as you. Have you found the solution?

    Comment


    • #3
      Dear Dr. Irs. I have a question similar to yours. My dataset includes individuals aged from 6 to 10 years old at baseline, with at least two follow-up records over a 4-year period. I’m using age as the time scale, but when I input their ages at each visit into the (indep) option, the trajplot only generates a graph covering the age range from 8 to 12 years old. Ideally, I would like a plot that spans the entire age spectrum. Could you advise me on how to address this issue?”

      Thank you so much for your assistance. Best regards, Fanfan.
      Last edited by Yang Fanfan; 22 Jul 2024, 02:06.

      Comment

      Working...
      X