Creating the Dummy Variables

[sudharsan reddy]

Dear All

I have a panel dataset with the variables trip_id, date_only, hour, Minute, and seconds and the dependent variable is alert, and the independent variables are aar, bar, and cct. Now, I have to generate three different dummy variables based on the time and alert, which is 15 seconds before and after the alert.

1) before the alert ==0
2) during the alert == 1
3) after the alert == 2

Could anyone help?

* Example generated by -dataex-. For more info, type help dataex
clear
input str34 trip_id str9 date_only byte(hour minute second alert) float(aar bar cct)
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  0 0 .20162995  .04260506   431
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  1 0 .16719356  .05624989 429.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  2 0  .1674138  .08249592 433.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  3 0 .19701643  .07580585 437.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  4 0 .20516405  .06666745 437.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  5 0 .14018941  .06387276 438.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  6 0 .09170595  .15080187 436.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  7 0 .11421962   .6173893 433.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  8 0  .1097358   .5896134 424.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  9 0 .08595602   .5171338 419.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 10 0 .09839484   .1326193 421.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 11 0 .11376492 .009647326   424
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 12 0 .09372236 .018008037 424.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 13 1 .10492887  .03765412 429.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 14 1 .12774761 .024693193 438.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 15 1  .0777294 .011911814 441.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 16 1 .09645145  .02902692   442
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 17 1  .0999199   .0318046   443
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 18 1 .07859822 .010034223 451.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 19 1 .08624128 .023670966   457
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 20 1 .16520786  .05103593 455.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 21 0 .08799438 .008044196   453
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 22 0  .1244134 .035368662 453.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 23 1 .08864965  .05807037   458
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 24 1 .16638355   .0685453   461
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 25 0 .11574279  .05181787 461.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 26 0 .12310397   .1470303 463.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 27 0 .15871197  .09303033 462.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 28 0 .17397007  .09428933 458.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 29 0 .19201784  .13814032 453.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 30 0 .21083596  .06707024 443.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 31 0 .06125252  .05421273 441.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 32 0 .10629333  .06610985   444
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 33 0  .1511041  .06177737 443.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 34 0  .1929069   .0454968 442.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 35 0  .2569058  .03125316 436.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 36 0  .1495269 .065860316   432
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 37 0 .14967504  .06347345   432
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 38 0 .15980107  .06372144 431.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 39 0 .17556715  .06438817 431.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 40 0 .16668437  .06492964 433.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 41 0 .15992224  .07937814 434.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 42 0  .1705421  .10644616   433
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 43 0 .15192135  .05132644 431.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 44 0 .20728523  .04138765 427.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 45 0  .2180869  .05178387 418.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 46 0 .13485567  .06152795 416.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 47 0 .16922466  .07246478 415.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 48 0  .1477594  .06227433 414.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 49 0  .1310007  .02980627 410.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 50 0 .14637494  .04522794 407.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 51 0 .17402603  .05784023 408.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 52 0  .1879326  .05905496 412.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 53 0 .19642372  .05652686   408
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 54 0 .18656853  .05157323 403.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 55 0  .1952264  .06814119 400.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 56 0 .18981753  .05688233 396.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 57 0 .20137605  .05549818 388.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 58 0  .2116627  .05092048 381.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 59 0  .2135155 .062635474 375.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  0 0 .16630025  .05073537 379.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  1 0  .1872496  .06246997 377.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  2 0 .19010487  .05265779 371.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  3 0 .19033025   .0557759 370.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  4 0  .1678069  .05109582 373.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  5 0 .07718182  .04872619 375.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  6 0 .11885254  .05330583 381.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  7 0 .18585426  .05388808 387.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  8 0 .18987246  .05842852 391.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  9 0 .17033966   .0671186 394.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 10 0 .16276267  .05360997 391.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 11 0 .10173102  .04097588   390
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 12 0 .18751426  .05063716 386.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 13 0  .1859354  .05747353 380.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 14 0  .1583601  .13125043 374.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 15 0  .1798508   .2230529 370.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 16 0  .2012501  .12296326 365.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 17 0 .24051525  .13038579 355.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 18 0 .18539083   .2309613   349
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 19 0  .1383848  .11634454 344.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 20 0 .16838303  .05812683 344.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 21 0 .18745138  .06731383 340.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 22 0 .19416724  .07267884 333.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 23 0 .18316504  .04920232 326.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 24 0  .1537071  .07747173   325
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 25 0 .19131565  .06176441   322
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 26 0 .17569813  .05742519 316.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 27 0  .1738239  .06673444 314.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 28 0 .18894957  .05520717 314.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 29 0 .17769504  .06286362 316.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 30 0 .16147284  .06446955   322
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 31 0   .167842  .08130982   322
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 32 0 .15805635  .06034185 318.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 33 0 .14275943  .05660106 317.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 34 0  .1832341  .07235386 318.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 35 0  .1713953  .05577983 320.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 36 0 .14620057  .03801242 323.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 37 0  .1709788  .05350199 321.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 38 0 .18252565  .05074655 316.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 39 0  .1720477  .05731092 313.1
end

[sudharsan reddy]

Sorry for the confusion in the above query.

When the alert was 1(True alert),
I had to create a variable before 15 seconds as 0 (i.e., 15 observations have to be labeled as 0) and during the alert as 1 (i.e., one observation has to be labeled as 1 ), and after the alert as 2 (i.e., 15 observation has to be labeled as 2 ) so totally three variables have to updated simultaneously which is related to alert was 1.

[Nick Cox]

I didn't understand this fully when I first read it but it is a bit clearer now.

Why or indeed whether you need three dummy variables rather than one variable with three distinct values I wasn't clear. In any case dummy (I say indicator) variables are usually defined with values 0 and 1, but your code makes your intent a bit clearer. More at https://journals.sagepub.com/doi/pdf...36867X19830921 -- which among other details explains how to avoid the two step as

gen foo = 0
replace foo = 1 if condition

is just

gen foo =condition

But you'll make the problem more difficult unless you work with combined date-time variables. The problem is that 15 seconds later can mean one or more or even all of a new minute, hour, or day.

Here I show how to get a date-time variable but note that the units are milliseconds.

But questions still remain for me:

1. I imagine that you want to do this separately for each trip but your code doesn't spell that out.

2. There are no variables alert_hour etc. in your data example but you need a date-time for that.

3. In your example there are repeated episodes of alert. So, after the first such episode, all observations are after that, and so on. In short, what precisely do before or after mean with repeated episodes? Perhaps the answer to #2 just above will answer that.

Note that I drop some variables purely because I want a simple list to show but you shouldn't do that.

* Example generated by -dataex-. For more info, type help dataex
clear
input str34 trip_id str9 date_only byte(hour minute second alert) float(aar bar cct)
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  0 0 .20162995  .04260506   431
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  1 0 .16719356  .05624989 429.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  2 0  .1674138  .08249592 433.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  3 0 .19701643  .07580585 437.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  4 0 .20516405  .06666745 437.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  5 0 .14018941  .06387276 438.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  6 0 .09170595  .15080187 436.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  7 0 .11421962   .6173893 433.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  8 0  .1097358   .5896134 424.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45  9 0 .08595602   .5171338 419.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 10 0 .09839484   .1326193 421.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 11 0 .11376492 .009647326   424
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 12 0 .09372236 .018008037 424.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 13 1 .10492887  .03765412 429.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 14 1 .12774761 .024693193 438.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 15 1  .0777294 .011911814 441.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 16 1 .09645145  .02902692   442
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 17 1  .0999199   .0318046   443
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 18 1 .07859822 .010034223 451.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 19 1 .08624128 .023670966   457
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 20 1 .16520786  .05103593 455.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 21 0 .08799438 .008044196   453
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 22 0  .1244134 .035368662 453.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 23 1 .08864965  .05807037   458
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 24 1 .16638355   .0685453   461
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 25 0 .11574279  .05181787 461.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 26 0 .12310397   .1470303 463.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 27 0 .15871197  .09303033 462.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 28 0 .17397007  .09428933 458.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 29 0 .19201784  .13814032 453.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 30 0 .21083596  .06707024 443.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 31 0 .06125252  .05421273 441.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 32 0 .10629333  .06610985   444
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 33 0  .1511041  .06177737 443.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 34 0  .1929069   .0454968 442.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 35 0  .2569058  .03125316 436.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 36 0  .1495269 .065860316   432
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 37 0 .14967504  .06347345   432
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 38 0 .15980107  .06372144 431.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 39 0 .17556715  .06438817 431.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 40 0 .16668437  .06492964 433.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 41 0 .15992224  .07937814 434.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 42 0  .1705421  .10644616   433
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 43 0 .15192135  .05132644 431.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 44 0 .20728523  .04138765 427.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 45 0  .2180869  .05178387 418.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 46 0 .13485567  .06152795 416.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 47 0 .16922466  .07246478 415.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 48 0  .1477594  .06227433 414.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 49 0  .1310007  .02980627 410.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 50 0 .14637494  .04522794 407.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 51 0 .17402603  .05784023 408.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 52 0  .1879326  .05905496 412.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 53 0 .19642372  .05652686   408
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 54 0 .18656853  .05157323 403.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 55 0  .1952264  .06814119 400.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 56 0 .18981753  .05688233 396.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 57 0 .20137605  .05549818 388.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 58 0  .2116627  .05092048 381.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 45 59 0  .2135155 .062635474 375.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  0 0 .16630025  .05073537 379.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  1 0  .1872496  .06246997 377.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  2 0 .19010487  .05265779 371.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  3 0 .19033025   .0557759 370.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  4 0  .1678069  .05109582 373.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  5 0 .07718182  .04872619 375.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  6 0 .11885254  .05330583 381.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  7 0 .18585426  .05388808 387.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  8 0 .18987246  .05842852 391.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46  9 0 .17033966   .0671186 394.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 10 0 .16276267  .05360997 391.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 11 0 .10173102  .04097588   390
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 12 0 .18751426  .05063716 386.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 13 0  .1859354  .05747353 380.5
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 14 0  .1583601  .13125043 374.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 15 0  .1798508   .2230529 370.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 16 0  .2012501  .12296326 365.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 17 0 .24051525  .13038579 355.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 18 0 .18539083   .2309613   349
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 19 0  .1383848  .11634454 344.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 20 0 .16838303  .05812683 344.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 21 0 .18745138  .06731383 340.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 22 0 .19416724  .07267884 333.2
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 23 0 .18316504  .04920232 326.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 24 0  .1537071  .07747173   325
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 25 0 .19131565  .06176441   322
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 26 0 .17569813  .05742519 316.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 27 0  .1738239  .06673444 314.8
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 28 0 .18894957  .05520717 314.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 29 0 .17769504  .06286362 316.1
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 30 0 .16147284  .06446955   322
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 31 0   .167842  .08130982   322
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 32 0 .15805635  .06034185 318.6
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 33 0 .14275943  .05660106 317.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 34 0  .1832341  .07235386 318.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 35 0  .1713953  .05577983 320.7
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 36 0 .14620057  .03801242 323.4
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 37 0  .1709788  .05350199 321.9
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 38 0 .18252565  .05074655 316.3
"1DC5Ox_1661381100000_1661383500000" "24-Aug-22" 22 46 39 0  .1720477  .05731092 313.1
end

egen simple_id = group(trip_id)
drop ??? trip_id 

order simple_id 

gen double when = clock(date_only, "DM20Y") + hms(hour, minute, second)
format when %tc 

list, sepby(alert)

    +----------------------------------------------------------------------------+
     | simple~d   date_only   hour   minute   second   alert                 when |
     |----------------------------------------------------------------------------|
  1. |        1   24-Aug-22     22       45        0       0   24aug2022 22:45:00 |
  2. |        1   24-Aug-22     22       45        1       0   24aug2022 22:45:01 |
  3. |        1   24-Aug-22     22       45        2       0   24aug2022 22:45:02 |
  4. |        1   24-Aug-22     22       45        3       0   24aug2022 22:45:03 |
  5. |        1   24-Aug-22     22       45        4       0   24aug2022 22:45:04 |
  6. |        1   24-Aug-22     22       45        5       0   24aug2022 22:45:05 |
  7. |        1   24-Aug-22     22       45        6       0   24aug2022 22:45:06 |
  8. |        1   24-Aug-22     22       45        7       0   24aug2022 22:45:07 |
  9. |        1   24-Aug-22     22       45        8       0   24aug2022 22:45:08 |
 10. |        1   24-Aug-22     22       45        9       0   24aug2022 22:45:09 |
 11. |        1   24-Aug-22     22       45       10       0   24aug2022 22:45:10 |
 12. |        1   24-Aug-22     22       45       11       0   24aug2022 22:45:11 |
 13. |        1   24-Aug-22     22       45       12       0   24aug2022 22:45:12 |
     |----------------------------------------------------------------------------|
 14. |        1   24-Aug-22     22       45       13       1   24aug2022 22:45:13 |
 15. |        1   24-Aug-22     22       45       14       1   24aug2022 22:45:14 |
 16. |        1   24-Aug-22     22       45       15       1   24aug2022 22:45:15 |
 17. |        1   24-Aug-22     22       45       16       1   24aug2022 22:45:16 |
 18. |        1   24-Aug-22     22       45       17       1   24aug2022 22:45:17 |
 19. |        1   24-Aug-22     22       45       18       1   24aug2022 22:45:18 |
 20. |        1   24-Aug-22     22       45       19       1   24aug2022 22:45:19 |
 21. |        1   24-Aug-22     22       45       20       1   24aug2022 22:45:20 |
     |----------------------------------------------------------------------------|
 22. |        1   24-Aug-22     22       45       21       0   24aug2022 22:45:21 |
 23. |        1   24-Aug-22     22       45       22       0   24aug2022 22:45:22 |
     |----------------------------------------------------------------------------|
 24. |        1   24-Aug-22     22       45       23       1   24aug2022 22:45:23 |
 25. |        1   24-Aug-22     22       45       24       1   24aug2022 22:45:24 |
     |----------------------------------------------------------------------------|
 26. |        1   24-Aug-22     22       45       25       0   24aug2022 22:45:25 |
 27. |        1   24-Aug-22     22       45       26       0   24aug2022 22:45:26 |
 28. |        1   24-Aug-22     22       45       27       0   24aug2022 22:45:27 |
 29. |        1   24-Aug-22     22       45       28       0   24aug2022 22:45:28 |
 30. |        1   24-Aug-22     22       45       29       0   24aug2022 22:45:29 |
 31. |        1   24-Aug-22     22       45       30       0   24aug2022 22:45:30 |
 32. |        1   24-Aug-22     22       45       31       0   24aug2022 22:45:31 |
 33. |        1   24-Aug-22     22       45       32       0   24aug2022 22:45:32 |
 34. |        1   24-Aug-22     22       45       33       0   24aug2022 22:45:33 |
 35. |        1   24-Aug-22     22       45       34       0   24aug2022 22:45:34 |
 36. |        1   24-Aug-22     22       45       35       0   24aug2022 22:45:35 |
 37. |        1   24-Aug-22     22       45       36       0   24aug2022 22:45:36 |
 38. |        1   24-Aug-22     22       45       37       0   24aug2022 22:45:37 |
 39. |        1   24-Aug-22     22       45       38       0   24aug2022 22:45:38 |
 40. |        1   24-Aug-22     22       45       39       0   24aug2022 22:45:39 |
 41. |        1   24-Aug-22     22       45       40       0   24aug2022 22:45:40 |
 42. |        1   24-Aug-22     22       45       41       0   24aug2022 22:45:41 |
 43. |        1   24-Aug-22     22       45       42       0   24aug2022 22:45:42 |
 44. |        1   24-Aug-22     22       45       43       0   24aug2022 22:45:43 |
 45. |        1   24-Aug-22     22       45       44       0   24aug2022 22:45:44 |
 46. |        1   24-Aug-22     22       45       45       0   24aug2022 22:45:45 |
 47. |        1   24-Aug-22     22       45       46       0   24aug2022 22:45:46 |
 48. |        1   24-Aug-22     22       45       47       0   24aug2022 22:45:47 |
 49. |        1   24-Aug-22     22       45       48       0   24aug2022 22:45:48 |
 50. |        1   24-Aug-22     22       45       49       0   24aug2022 22:45:49 |
 51. |        1   24-Aug-22     22       45       50       0   24aug2022 22:45:50 |
 52. |        1   24-Aug-22     22       45       51       0   24aug2022 22:45:51 |
 53. |        1   24-Aug-22     22       45       52       0   24aug2022 22:45:52 |
 54. |        1   24-Aug-22     22       45       53       0   24aug2022 22:45:53 |
 55. |        1   24-Aug-22     22       45       54       0   24aug2022 22:45:54 |
 56. |        1   24-Aug-22     22       45       55       0   24aug2022 22:45:55 |
 57. |        1   24-Aug-22     22       45       56       0   24aug2022 22:45:56 |
 58. |        1   24-Aug-22     22       45       57       0   24aug2022 22:45:57 |
 59. |        1   24-Aug-22     22       45       58       0   24aug2022 22:45:58 |
 60. |        1   24-Aug-22     22       45       59       0   24aug2022 22:45:59 |
 61. |        1   24-Aug-22     22       46        0       0   24aug2022 22:46:00 |
 62. |        1   24-Aug-22     22       46        1       0   24aug2022 22:46:01 |
 63. |        1   24-Aug-22     22       46        2       0   24aug2022 22:46:02 |
 64. |        1   24-Aug-22     22       46        3       0   24aug2022 22:46:03 |
 65. |        1   24-Aug-22     22       46        4       0   24aug2022 22:46:04 |
 66. |        1   24-Aug-22     22       46        5       0   24aug2022 22:46:05 |
 67. |        1   24-Aug-22     22       46        6       0   24aug2022 22:46:06 |
 68. |        1   24-Aug-22     22       46        7       0   24aug2022 22:46:07 |
 69. |        1   24-Aug-22     22       46        8       0   24aug2022 22:46:08 |
 70. |        1   24-Aug-22     22       46        9       0   24aug2022 22:46:09 |
 71. |        1   24-Aug-22     22       46       10       0   24aug2022 22:46:10 |
 72. |        1   24-Aug-22     22       46       11       0   24aug2022 22:46:11 |
 73. |        1   24-Aug-22     22       46       12       0   24aug2022 22:46:12 |
 74. |        1   24-Aug-22     22       46       13       0   24aug2022 22:46:13 |
 75. |        1   24-Aug-22     22       46       14       0   24aug2022 22:46:14 |
 76. |        1   24-Aug-22     22       46       15       0   24aug2022 22:46:15 |
 77. |        1   24-Aug-22     22       46       16       0   24aug2022 22:46:16 |
 78. |        1   24-Aug-22     22       46       17       0   24aug2022 22:46:17 |
 79. |        1   24-Aug-22     22       46       18       0   24aug2022 22:46:18 |
 80. |        1   24-Aug-22     22       46       19       0   24aug2022 22:46:19 |
 81. |        1   24-Aug-22     22       46       20       0   24aug2022 22:46:20 |
 82. |        1   24-Aug-22     22       46       21       0   24aug2022 22:46:21 |
 83. |        1   24-Aug-22     22       46       22       0   24aug2022 22:46:22 |
 84. |        1   24-Aug-22     22       46       23       0   24aug2022 22:46:23 |
 85. |        1   24-Aug-22     22       46       24       0   24aug2022 22:46:24 |
 86. |        1   24-Aug-22     22       46       25       0   24aug2022 22:46:25 |
 87. |        1   24-Aug-22     22       46       26       0   24aug2022 22:46:26 |
 88. |        1   24-Aug-22     22       46       27       0   24aug2022 22:46:27 |
 89. |        1   24-Aug-22     22       46       28       0   24aug2022 22:46:28 |
 90. |        1   24-Aug-22     22       46       29       0   24aug2022 22:46:29 |
 91. |        1   24-Aug-22     22       46       30       0   24aug2022 22:46:30 |
 92. |        1   24-Aug-22     22       46       31       0   24aug2022 22:46:31 |
 93. |        1   24-Aug-22     22       46       32       0   24aug2022 22:46:32 |
 94. |        1   24-Aug-22     22       46       33       0   24aug2022 22:46:33 |
 95. |        1   24-Aug-22     22       46       34       0   24aug2022 22:46:34 |
 96. |        1   24-Aug-22     22       46       35       0   24aug2022 22:46:35 |
 97. |        1   24-Aug-22     22       46       36       0   24aug2022 22:46:36 |
 98. |        1   24-Aug-22     22       46       37       0   24aug2022 22:46:37 |
 99. |        1   24-Aug-22     22       46       38       0   24aug2022 22:46:38 |
100. |        1   24-Aug-22     22       46       39       0   24aug2022 22:46:39 |
     +----------------------------------------------------------------------------+

[sudharsan reddy]

Hello nick
I am getting your points and ideas on this query.
But if I am generating three different variables, I think I can solve this query. I don't have a problem with 1 to 13 as a 0, and 14 to 21 as a 1, 22 to 23 as a 0, and 24 to 25 as a 1 is not a big problem for me as of now. So once I will get the input in the three separate variables, I can quickly finish my job.

Can you share the coding idea for how to add the values as per "I had to create a variable before 15 seconds as 0 (i.e., lesser than 15 observations (is also fine but not more than 15) have to be labeled as 0) and during the alert as 1 (i.e., one observation has to be labeled as 1 ), and after the alert as 2 (i.e., lesser than 15 observation (is also fine but not more than 15) has to be labeled as 2 ) "

I hope you're getting my point.

[Nick Cox]

Sorry, but I am not really clearer after #4 on what you want. I had questions in #3 and I don't think you've answered them.

You could take the data from #3 and populate them with how you want your new variables to look. You may need to explain the rules too.

[sudharsan reddy]

It's okay, Nick, leave that old part. I will think about these questions.
Right now, I am using a code to find the before and after 15 seconds. But the problem is the code is finding the moving average. I want to see the fixed average of the observations

code:
g aar_before_15 = cond(alert==1,(aar[_n-15]+aar[_n-14]+aar[_n-13]+aar[_n-12]+aar[_n-11]+aar[_n-10]+aar[_n-9]+aar[_n-8]+aar[_n-7]+aar[_n-6]+aar[_n-5]+aar[_n-4]+aar[_n-3]+aar[_n-2]+aar[_n-1])/15,.)
g aar_after_15 = cond(alert==1,(aar[_n+15]+aar[_n+14]+aar[_n+13]+aar[_n+12]+aar[_n+11]+aar[_n+10]+aar[_n+9]+aar[_n+8]+aar[_n+7]+aar[_n+6]+aar[_n+5]+aar[_n+4]+aar[_n+3]+aar[_n+2]+aar[_n+1])/15,.)


Can you fix this code to find the fixed average?

[Nick Cox]

I won't try to fix that code because you don't explain what you think is wrong with it and in any case there are much better ways to do it. Further, I understand moving averages but I don't understand what in this context you mean by fixed average.

Importantly, the code is fatally buggy unless you insist on working separately by trips -- which I presume you want to do, although you're still not replying to my question in #3 to confirm that.

rangestat from SSC and tssmooth as an official command can be used to generate running means and so there is little or no point in writing code from scratch to do it.