如何使用Stata限制时间? [英] How to bound time using Stata?

问题描述

我想将数据集的 TRD_EVENT_TM 变量(时间值)限制在 9:30 t0 11:00 之间.

* 示例由 -dataex- 生成.安装:ssc install dataex清除输入 str8 TRD_EVENT_TM str6 TRD_STCK_CD 双 TRD_PR 长 TRD_EVENT_DT"09:53:17" "BANK1" 909 18293"10:25:40" "HSHM1" 1706 19205"11:32:03" "SIPA1" 2231 18866"11:01:55" "AZAB1" 2283 18916"12:19:56" "SIPA1" 2063 17683"10:48:01" "CHML1" 6048 18672"10:59:49" "DADE1" 3044 18847"11:40:34" "CHML1" 6406 18798"10:54:45" "GOLG1" 7583 18544"11:08:01" "IKCO1" 3942 18743"10:25:35" "ASIA1" 5248 18511"09:41:46" "FOLD1" 4910 19406"11:43:15" "BANK1" 829 18105结尾格式 %tdD_m_Y TRD_EVENT_DT

我该怎么做?

解决方案

虽然是字符串变量，但条件 inrange(TRD_EVENT, "09:30", "11:00") 应该可以美好的.有了你的数据，

<预><代码>.列出 TRD_EVENT_TM 如果 inrange(TRD_EVENT_TM, "09:30", "11:00") , sep(0)+-----------+|TRD_EV~M ||----------|1. |09:53:17 |2. |10:25:40 |6. |10:48:01 |7. |10:59:49 |9. |10:54:45 |11. |10:25:35 |12. |09:41:46 |+-----------+

help inrange() 说明该函数允许字符串参数.另见 https://www.stata-journal.com/sjpdf.html?文章编号=dm0026

I want to restrict TRD_EVENT_TM variable of my dataset, which is time value, between 9:30 t0 11:00.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str8 TRD_EVENT_TM str6 TRD_STCK_CD double TRD_PR long TRD_EVENT_DT
"09:53:17" "BANK1"   909 18293
"10:25:40" "HSHM1"  1706 19205
"11:32:03" "SIPA1"  2231 18866
"11:01:55" "AZAB1"  2283 18916
"12:19:56" "SIPA1"  2063 17683
"10:48:01" "CHML1"  6048 18672
"10:59:49" "DADE1"  3044 18847
"11:40:34" "CHML1"  6406 18798
"10:54:45" "GOLG1"  7583 18544
"11:08:01" "IKCO1"  3942 18743
"10:25:35" "ASIA1"  5248 18511
"09:41:46" "FOLD1"  4910 19406
"11:43:15" "BANK1"   829 18105
end
format %tdD_m_Y TRD_EVENT_DT

How can I do that?

解决方案

Although it's a string variable, the condition inrange(TRD_EVENT, "09:30", "11:00") should work fine. With your data,

. list TRD_EVENT_TM if inrange(TRD_EVENT_TM, "09:30", "11:00") , sep(0) 

     +----------+
     | TRD_EV~M |
     |----------|
  1. | 09:53:17 |
  2. | 10:25:40 |
  6. | 10:48:01 |
  7. | 10:59:49 |
  9. | 10:54:45 |
 11. | 10:25:35 |
 12. | 09:41:46 |
     +----------+

help inrange() documents that the function allows string arguments. See also https://www.stata-journal.com/sjpdf.html?articlenum=dm0026

这篇关于如何使用Stata限制时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！