Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    creating the dummy for a particular time interval

    Dear All
    I have a dataset that contains eight variables: date_only, hour, minute, seconds, drowsy_alert, aar, bar, and cct. I had to create a dummy when the drowsy_alert was 1. before 10 seconds as a 1 and after 10 seconds as a 2. Here I attached the dataex also for all your reference.

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str9 date_only byte(hour minute second alert) float(aar bar cct)
"30-Jul-23" 23 30  0 0      .234        .06     91.1
"30-Jul-23" 23 30  1 0      .233       .056     89.5
"30-Jul-23" 23 30  2 0      .262       .059     84.1
"30-Jul-23" 23 30  3 0      .231       .062     82.6
"30-Jul-23" 23 30  4 0      .244       .047     79.1
"30-Jul-23" 23 30  5 0      .258       .055       80
"30-Jul-23" 23 30  6 0      .259 .031999998     77.9
"30-Jul-23" 23 30  7 0      .242       .043     71.8
"30-Jul-23" 23 30  8 0      .269       .036     64.8
"30-Jul-23" 23 30  9 0      .231       .043       62
"30-Jul-23" 23 30 10 0      .259       .048       62
"30-Jul-23" 23 30 11 0      .229       .049     62.3
"30-Jul-23" 23 30 12 0      .248        .04     61.7
"30-Jul-23" 23 30 13 0       .21       .053     56.3
"30-Jul-23" 23 30 14 0      .235       .062     55.6
"30-Jul-23" 23 30 15 0      .239       .062       55
"30-Jul-23" 23 30 16 0      .151       .052     58.6
"30-Jul-23" 23 30 17 0      .172       .048       67
"30-Jul-23" 23 30 18 0      .223       .056       68
"30-Jul-23" 23 30 19 0      .243       .063     63.6
"30-Jul-23" 23 30 20 0      .225       .055     54.5
"30-Jul-23" 23 30 21 0      .197       .055     50.6
"30-Jul-23" 23 30 22 0      .188       .046     54.2
"30-Jul-23" 23 30 23 0      .231       .065     53.5
"30-Jul-23" 23 30 24 0      .255       .047     52.1
"30-Jul-23" 23 30 25 0       .25       .049       51
"30-Jul-23" 23 30 26 0       .17       .047     52.9
"30-Jul-23" 23 30 27 0      .124       .041     61.5
"30-Jul-23" 23 30 28 0       .21       .058       67
"30-Jul-23" 23 30 29 0      .118       .052       70
"30-Jul-23" 23 30 30 0      .233       .068       75
"30-Jul-23" 23 30 31 0      .233       .059       75
"30-Jul-23" 23 30 32 0      .235       .068       75
"30-Jul-23" 23 30 33 0      .207       .052     75.4
"30-Jul-23" 23 30 34 0      .216        .06       75
"30-Jul-23" 23 30 35 0      .218       .057     75.7
"30-Jul-23" 23 30 36 0      .205       .046     76.7
"30-Jul-23" 23 30 37 0      .209        .06     79.2
"30-Jul-23" 23 30 38 1      .233       .071     78.8
"30-Jul-23" 23 30 39 0      .216       .048     76.5
"30-Jul-23" 23 30 40 0      .194       .061     79.2
"30-Jul-23" 23 30 41 0       .21       .067       81
"30-Jul-23" 23 30 42 0      .205       .062     80.2
"30-Jul-23" 23 30 43 0       .25       .059       81
"30-Jul-23" 23 30 44 0      .207       .046       81
"30-Jul-23" 23 30 45 0      .239        .06     80.7
"30-Jul-23" 23 30 46 0      .231       .061       79
"30-Jul-23" 23 30 47 0      .221        .06       78
"30-Jul-23" 23 30 48 0      .163       .037     80.8
"30-Jul-23" 23 30 49 0      .171       .054     87.8
"30-Jul-23" 23 30 50 0       .22       .048       89
"30-Jul-23" 23 30 51 0      .177       .047       90
"30-Jul-23" 23 30 52 0      .148       .044     96.4
"30-Jul-23" 23 30 53 0      .213       .058     94.3
"30-Jul-23" 23 30 54 0      .204       .052     91.6
"30-Jul-23" 23 30 55 0      .205       .051     90.8
"30-Jul-23" 23 30 56 0      .201       .057     90.9
"30-Jul-23" 23 30 57 0       .18       .052     92.3
"30-Jul-23" 23 30 58 0 .19444445  .04777778       95
"30-Jul-23" 23 30 59 0      .189       .059     96.8
"30-Jul-23" 23 31  0 0      .226       .053     96.2
"30-Jul-23" 23 31  1 0       .17       .043     98.8
"30-Jul-23" 23 31  2 0      .214       .065       99
"30-Jul-23" 23 31  3 0       .23       .058     98.9
"30-Jul-23" 23 31  4 0      .213       .058     97.9
"30-Jul-23" 23 31  5 0       .22       .059       97
"30-Jul-23" 23 31  6 1       .23       .053       97
"30-Jul-23" 23 31  7 0      .224       .054       97
"30-Jul-23" 23 31  8 0      .218       .061       97
"30-Jul-23" 23 31  9 0       .24       .055       97
"30-Jul-23" 23 31 10 0      .225       .058       97
"30-Jul-23" 23 31 11 0      .215       .061     96.7
"30-Jul-23" 23 31 12 0      .234       .062       96
"30-Jul-23" 23 31 13 0      .211       .056       96
"30-Jul-23" 23 31 14 0      .219       .064     96.6
"30-Jul-23" 23 31 15 0      .241       .054       97
"30-Jul-23" 23 31 16 0      .227       .056     93.4
"30-Jul-23" 23 31 17 0 .20444444  .06555556 87.77778
"30-Jul-23" 23 31 18 0      .202       .053     87.9
"30-Jul-23" 23 31 19 0      .222       .066     89.9
"30-Jul-23" 23 31 20 0      .209       .059     92.4
"30-Jul-23" 23 31 21 0      .194       .061     93.6
"30-Jul-23" 23 31 22 0      .188       .053     91.5
"30-Jul-23" 23 31 23 0      .205       .053     92.1
"30-Jul-23" 23 31 24 0      .208       .048     93.5
"30-Jul-23" 23 31 25 0      .232       .051       94
"30-Jul-23" 23 31 26 0      .226       .055     91.2
"30-Jul-23" 23 31 27 0      .222       .052       82
"30-Jul-23" 23 31 28 0      .224       .055       77
"30-Jul-23" 23 31 29 0      .238       .048     73.4
"30-Jul-23" 23 31 30 0      .246 .063999996       68
"30-Jul-23" 23 31 31 0  .2277778  .04888889       68
"30-Jul-23" 23 31 32 1      .239        .07       68
"30-Jul-23" 23 31 33 0       .26       .058     67.4
"30-Jul-23" 23 31 34 0      .232       .056       67
"30-Jul-23" 23 31 35 0      .252       .053     66.3
"30-Jul-23" 23 31 36 0      .261       .063     65.3
"30-Jul-23" 23 31 37 0      .233       .056     63.5
"30-Jul-23" 23 31 38 0      .254       .079       63
"30-Jul-23" 23 31 39 0      .229       .061     62.8
"30-Jul-23" 23 31 40 0      .198        .06     60.5
"30-Jul-23" 23 31 41 0      .241       .059       59
"30-Jul-23" 23 31 42 0      .218       .063     58.9
"30-Jul-23" 23 31 43 0        .2       .051     58.8
"30-Jul-23" 23 31 44 0      .224       .067       59
"30-Jul-23" 23 31 45 0      .228       .057       59
"30-Jul-23" 23 31 46 0       .23       .061     59.9
"30-Jul-23" 23 31 47 0      .218       .063     60.6
"30-Jul-23" 23 31 48 0      .225       .059     58.2
"30-Jul-23" 23 31 49 0       .22       .054     50.3
"30-Jul-23" 23 31 50 0      .215        .06     49.9
"30-Jul-23" 23 31 51 0      .195       .051     50.7
"30-Jul-23" 23 31 52 0      .234       .056     44.5
"30-Jul-23" 23 31 53 0      .203       .049     43.6
"30-Jul-23" 23 31 54 0      .226       .057       44
"30-Jul-23" 23 31 55 0  .2211111  .05555556 42.11111
"30-Jul-23" 23 31 56 0      .215       .047     41.1
"30-Jul-23" 23 31 57 0       .19       .046     39.5
"30-Jul-23" 23 31 58 0        .2       .049     37.9
"30-Jul-23" 23 31 59 0      .208       .059     34.7
"30-Jul-23" 23 32  0 1      .203       .051       35
"30-Jul-23" 23 32  1 0      .216       .052     31.7
"30-Jul-23" 23 32  2 0      .189       .056     33.9
"30-Jul-23" 23 32  3 0      .233       .058       34
"30-Jul-23" 23 32  4 0 .22333333  .05555556       34
"30-Jul-23" 23 32  5 0      .233       .053       34
"30-Jul-23" 23 32  6 0      .114       .049     38.5
"30-Jul-23" 23 32  7 0      .195       .056     45.7
"30-Jul-23" 23 32  8 0      .181       .052     48.1
"30-Jul-23" 23 32  9 0      .192       .055     55.4
"30-Jul-23" 23 32 10 0      .229       .052       56
"30-Jul-23" 23 32 11 0      .232       .066       56
"30-Jul-23" 23 32 12 0      .234       .052       56
"30-Jul-23" 23 32 13 0      .224       .069       56
"30-Jul-23" 23 32 14 0        .2       .055     56.1
"30-Jul-23" 23 32 15 0      .225       .062       56
"30-Jul-23" 23 32 16 0      .206       .056     56.2
"30-Jul-23" 23 32 17 0      .215       .066     54.3
"30-Jul-23" 23 32 18 0      .225       .044     53.3
"30-Jul-23" 23 32 19 0 .22222222  .05666666 52.11111
"30-Jul-23" 23 32 20 0      .196       .047     51.1
"30-Jul-23" 23 32 21 0      .227        .05     50.8
"30-Jul-23" 23 32 22 0       .16       .055     50.3
"30-Jul-23" 23 32 23 0      .122       .049     57.2
"30-Jul-23" 23 32 24 0      .208       .053     59.5
"30-Jul-23" 23 32 25 0      .203       .048       59
"30-Jul-23" 23 32 26 0      .213       .065       59
"30-Jul-23" 23 32 27 0      .206       .062     59.1
"30-Jul-23" 23 32 28 0      .203       .058     59.4
"30-Jul-23" 23 32 29 0      .228       .072     60.7
"30-Jul-23" 23 32 30 0      .231       .061     61.2
"30-Jul-23" 23 32 31 0       .23       .064       62
"30-Jul-23" 23 32 32 0       .19       .061       63
"30-Jul-23" 23 32 33 0       .13       .048     71.4
"30-Jul-23" 23 32 34 0      .214       .066     75.2
"30-Jul-23" 23 32 35 0      .211       .059       76
"30-Jul-23" 23 32 36 0      .177       .047     78.6
"30-Jul-23" 23 32 37 0      .224       .059     79.3
"30-Jul-23" 23 32 38 0      .218       .048       79
"30-Jul-23" 23 32 39 0      .219       .041       79
"30-Jul-23" 23 32 40 0      .229       .056     78.3
"30-Jul-23" 23 32 41 0       .22       .056       78
"30-Jul-23" 23 32 42 0       .23       .066       78
"30-Jul-23" 23 32 43 0      .243       .058     77.2
"30-Jul-23" 23 32 44 0      .234       .063       77
"30-Jul-23" 23 32 45 1      .227       .058       77
"30-Jul-23" 23 32 46 0      .245       .061     76.1
"30-Jul-23" 23 32 47 0      .243        .05     75.4
"30-Jul-23" 23 32 48 0      .252       .053       75
"30-Jul-23" 23 32 49 0      .239       .056       75
"30-Jul-23" 23 32 50 0      .149        .05     79.2
"30-Jul-23" 23 32 51 0      .198        .05     83.2
"30-Jul-23" 23 32 52 0      .239       .047       83
"30-Jul-23" 23 32 53 0      .257       .047     82.4
"30-Jul-23" 23 32 54 0      .235       .054       82
"30-Jul-23" 23 32 55 0      .244       .053       82
"30-Jul-23" 23 32 56 0      .239       .052       82
"30-Jul-23" 23 32 57 0      .244        .07     81.6
"30-Jul-23" 23 32 58 1       .25       .066       80
"30-Jul-23" 23 32 59 0      .233       .058       80
"30-Jul-23" 23 33  0 0      .205       .065       79
"30-Jul-23" 23 33  1 0      .258       .066     78.9
"30-Jul-23" 23 33  2 0       .23 .067999996     76.1
"30-Jul-23" 23 33  3 0      .217       .061       76
"30-Jul-23" 23 33  4 0       .23       .066     76.5
"30-Jul-23" 23 33  5 0      .232       .064       77
"30-Jul-23" 23 33  6 0      .217       .084     72.7
"30-Jul-23" 23 33  7 0      .217       .067     66.3
"30-Jul-23" 23 33  8 0      .217 .067999996     63.9
"30-Jul-23" 23 33  9 0      .229       .055     56.6
"30-Jul-23" 23 33 10 0      .183       .033     56.9
"30-Jul-23" 23 33 11 0      .226       .044     60.7
"30-Jul-23" 23 33 12 0      .205       .052       61
"30-Jul-23" 23 33 13 0       .26       .029       61
"30-Jul-23" 23 33 14 0      .232       .025     60.3
"30-Jul-23" 23 33 15 0      .212 .031999998     60.5
"30-Jul-23" 23 33 16 0      .195        .03     63.5
"30-Jul-23" 23 33 17 0      .237       .025       64
"30-Jul-23" 23 33 18 0      .209       .063     64.4
"30-Jul-23" 23 33 19 0      .177        .07     68.8
"30-Jul-23" 23 33 20 0      .154       .053     73.4
"30-Jul-23" 23 33 21 0      .166        .04     77.2
"30-Jul-23" 23 33 22 0      .228       .053     77.1
"30-Jul-23" 23 33 23 0      .237       .052     69.7
"30-Jul-23" 23 33 24 0      .232        .05     66.5
"30-Jul-23" 23 33 25 0       .22       .044       67
"30-Jul-23" 23 33 26 0      .194       .043     67.3
"30-Jul-23" 23 33 27 0      .182       .033     70.4
"30-Jul-23" 23 33 28 0      .202       .045     72.6
"30-Jul-23" 23 33 29 0      .186       .028     72.6
"30-Jul-23" 23 33 30 1      .177       .039     75.3
"30-Jul-23" 23 33 31 0      .215       .047     79.8
"30-Jul-23" 23 33 32 0      .212       .041     79.1
"30-Jul-23" 23 33 33 0      .207       .049     71.6
"30-Jul-23" 23 33 34 0      .218       .042     68.2
"30-Jul-23" 23 33 35 0      .195       .039     68.9
"30-Jul-23" 23 33 36 0      .189 .031999998     69.3
"30-Jul-23" 23 33 37 0      .188        .05     69.2
"30-Jul-23" 23 33 38 0      .212       .049       70
"30-Jul-23" 23 33 39 0      .201       .047       70
"30-Jul-23" 23 33 40 0      .221        .06     70.1
"30-Jul-23" 23 33 41 0      .194       .054     72.7
"30-Jul-23" 23 33 42 0      .236       .056       73
"30-Jul-23" 23 33 43 0      .217       .062     74.2
"30-Jul-23" 23 33 44 0      .197       .055     75.9
"30-Jul-23" 23 33 45 0      .192       .044     77.8
"30-Jul-23" 23 33 46 0      .213       .064     80.3
"30-Jul-23" 23 33 47 0      .224       .058       81
"30-Jul-23" 23 33 48 0      .231        .06       81
"30-Jul-23" 23 33 49 0      .224       .053     81.2
"30-Jul-23" 23 33 50 0      .292       .025     76.9
"30-Jul-23" 23 33 51 0      .222       .049     71.1
"30-Jul-23" 23 33 52 0      .199       .065     71.3
"30-Jul-23" 23 33 53 0      .178       .044       75
"30-Jul-23" 23 33 54 0      .208        .07     80.7
"30-Jul-23" 23 33 55 0      .205        .06     81.3
"30-Jul-23" 23 33 56 0      .185       .053     82.6
"30-Jul-23" 23 33 57 0      .169       .051     88.5
"30-Jul-23" 23 33 58 0      .131       .051       95
"30-Jul-23" 23 33 59 0      .232 .063999996       99
"30-Jul-23" 23 34  0 0      .206       .048     99.3
"30-Jul-23" 23 34  1 0      .221       .049       99
"30-Jul-23" 23 34  2 0      .159 .063999996    101.8
"30-Jul-23" 23 34  3 0      .173       .051    108.9
"30-Jul-23" 23 34  4 0      .165       .053    115.5
"30-Jul-23" 23 34  5 1       .19        .06    116.3
"30-Jul-23" 23 34  6 0      .112       .049    123.3
"30-Jul-23" 23 34  7 0      .183       .052    129.7
"30-Jul-23" 23 34  8 0      .146       .056    132.8
"30-Jul-23" 23 34  9 0      .198       .049    138.9
"30-Jul-23" 23 34 10 0      .234       .063    138.1
"30-Jul-23" 23 34 11 0      .223 .063999996    134.4
"30-Jul-23" 23 34 12 0      .231       .068    135.9
"30-Jul-23" 23 34 13 0      .217       .063      137
"30-Jul-23" 23 34 14 0      .209       .058      138
"30-Jul-23" 23 34 15 0      .226       .073    138.5
"30-Jul-23" 23 34 16 0      .216       .061    135.3
"30-Jul-23" 23 34 17 0        .2       .054      134
"30-Jul-23" 23 34 18 0       .21       .058    133.4
"30-Jul-23" 23 34 19 0      .229       .058    128.2
"30-Jul-23" 23 34 20 0      .215       .065    122.9
"30-Jul-23" 23 34 21 0      .221       .063    117.8
"30-Jul-23" 23 34 22 0      .229       .069    115.9
"30-Jul-23" 23 34 23 0        .2       .066    116.5
"30-Jul-23" 23 34 24 0      .196       .051    119.3
"30-Jul-23" 23 34 25 0      .221       .056      119
"30-Jul-23" 23 34 26 0      .237       .069    118.7
"30-Jul-23" 23 34 27 0      .233        .06      115
"30-Jul-23" 23 34 28 0      .225       .065      112
"30-Jul-23" 23 34 29 0       .22       .058    110.7
"30-Jul-23" 23 34 30 0      .226       .057    107.5
"30-Jul-23" 23 34 31 0      .193        .06    102.5
"30-Jul-23" 23 34 32 0      .217       .065    103.9
"30-Jul-23" 23 34 33 0      .217       .064      103
"30-Jul-23" 23 34 34 0      .232       .062    102.6
"30-Jul-23" 23 34 35 0      .222       .058    101.1
"30-Jul-23" 23 34 36 0      .225        .06     98.1
"30-Jul-23" 23 34 37 0      .206       .057     96.8
"30-Jul-23" 23 34 38 0      .226       .074       96
"30-Jul-23" 23 34 39 1      .211       .065     96.8
"30-Jul-23" 23 34 40 0      .233       .067     96.9
"30-Jul-23" 23 34 41 0      .231       .063     94.3
"30-Jul-23" 23 34 42 0      .199       .059     95.1
"30-Jul-23" 23 34 43 0       .21       .058     94.8
"30-Jul-23" 23 34 44 0       .22       .066     93.1
"30-Jul-23" 23 34 45 0      .203       .061     91.2
"30-Jul-23" 23 34 46 0      .216       .064     88.7
"30-Jul-23" 23 34 47 0      .228        .06       88
"30-Jul-23" 23 34 48 0      .231        .07       88
"30-Jul-23" 23 34 49 0      .175       .066     89.9
"30-Jul-23" 23 34 50 0      .167       .055     96.5
"30-Jul-23" 23 34 51 0      .214       .069     98.2
"30-Jul-23" 23 34 52 0      .199        .05     99.3
"30-Jul-23" 23 34 53 0      .155       .044    102.9
"30-Jul-23" 23 34 54 0       .21       .065     99.3
"30-Jul-23" 23 34 55 0      .217 .067999996     98.7
"30-Jul-23" 23 34 56 1      .227       .066     97.4
"30-Jul-23" 23 34 57 0      .229       .056     91.6
"30-Jul-23" 23 34 58 0      .222       .048       86
"30-Jul-23" 23 34 59 0      .211       .051       82
end
    Tags: None
  • #2
    This is simple if you first create a real Stata internal format datetime (clock) variable out of your string date and separate hour, minute, and second variables.
    Code:
    gen date = daily(date_only, "DM20Y")
assert missing(date) == missing(date_only)
format date %td
gen double datetime = cofC(Cdhms(date, hour, minute, second))
format datetime %tc
tsset datetime, delta(1000)

gen byte wanted = F10.alert == 1
replace wanted = 2 if L10.alert == 1
    That said, there is an inherent problem in creating a variable in this way. Suppose there is an alert at 23:32:50, one at 23:33:00 and another alert at 23:33:10. Now consider what happens to our new variable. At 23:33:00 it should be a 1 because it is 10 seconds before the alert at 23:33:10, but it should be a 2 because it is 10 seconds after the one at 23:32:50. In the above code, you will get 2--an arbitrary choice I made. But you need to decide which takes priority, the before or the after condition. Or, perhaps better still, handle all of this with separate variables for before and after.

    Comment

    Previous Next
    Working...
    X