Defining relative days of week and time in study for panel patient data

[Emily Clair]

I'm working with a data set of BP recordings, taken by different patients at different times. The data set is organised with the variables patientcode, datetime, BP. Each patient's recordings start on a different date and they should have 4 recordings a day for the first week of every month. Before I can perform analysis, I need to identify on which day of the month each recording was made. I then wish to analyse if the first day of each patient's week is different to the rest of the week and if the SD of each week's recordings changes depending on the month in the study. To do this I need to define the variables timeinstudy, dayofpatientweek. Since each patient's week will have a different start date, how can i best define the variables in this panel data?

I'm very new to stata so any advice or suggestions would be welcome! Thanks

[Jared Greathouse]

I may be able to crack this, but I'll need to see your dataset using dataex. Welcome to Statalist!!

I've sort of worked on a similar issue before

[Emily Clair]

That would be great thank you!

clear
input int SUBJECTID float(DATE TIME) int(SYS DIA PULSE) byte(IRREGULAR_HEARTBEAT EXCESSIVE_MOVEMENT MEMO MSCNT1 MSCNT2 MSCNT3 INPUTTYPE MEASURETYPE) str2 COMMENT float patientcode double datetime byte isdup float(dup week weekday)
1 20091 31853000 160 90 51 0 0 0 0 0 0 0 0 "NA" 1 1735894253000 0 0 . .
1 20091 32246000 149 83 48 0 0 0 0 0 0 0 0 "NA" 1 1735894646000 0 0 . .
1 20091 76459000 141 87 59 0 0 0 0 0 0 0 2 "NA" 1 1735938859000 0 0 . .
1 20091 76817000 146 87 64 0 0 0 0 0 0 0 2 "NA" 1 1735939217000 0 0 . .
1 20092 30411000 159 89 50 0 0 0 0 0 0 0 0 "NA" 1 1735979211000 0 0 . .
1 20092 30822000 159 90 49 0 0 0 0 0 0 0 0 "NA" 1 1735979622000 0 0 . .
1 20092 66925000 161 90 55 0 0 0 0 0 0 0 1 "NA" 1 1736015725000 0 0 . .
1 20092 67292000 148 84 57 0 0 0 0 0 0 0 1 "NA" 1 1736016092000 0 0 . .
1 20093 30735000 180 99 54 0 0 0 0 0 0 0 0 "NA" 1 1736065935000 0 0 . .
1 20093 31095000 166 94 52 0 0 0 0 0 0 0 0 "NA" 1 1736066295000 0 0 . .
1 20093 79911000 164 100 69 0 0 0 0 0 0 0 2 "NA" 1 1736115111000 0 0 . .
1 20093 80319000 150 93 65 0 0 0 0 0 0 0 2 "NA" 1 1736115519000 0 0 . .
1 20094 32053000 151 94 52 0 0 0 0 0 0 0 0 "NA" 1 1736153653000 0 0 . .
1 20094 32431000 146 83 51 0 0 0 0 0 0 0 0 "NA" 1 1736154031000 0 0 . .
1 20094 81439000 134 75 57 0 0 0 0 0 0 0 2 "NA" 1 1736203039000 0 0 . .
1 20094 81812000 137 79 60 0 0 0 0 0 0 0 2 "NA" 1 1736203412000 0 0 . .
1 20095 30845000 162 96 51 0 0 0 0 0 0 0 0 "NA" 1 1736238845000 0 0 . .
1 20095 31326000 151 85 50 0 0 0 0 0 0 0 0 "NA" 1 1736239326000 0 0 . .
1 20095 67131000 145 84 52 0 0 0 0 0 0 0 1 "NA" 1 1736275131000 0 0 . .
1 20095 67566000 136 74 53 0 0 0 0 0 0 0 1 "NA" 1 1736275566000 0 0 . .
1 20096 28660000 162 96 55 0 0 0 0 0 0 0 0 "NA" 1 1736323060000 0 0 . .
1 20096 29061000 162 91 54 0 0 0 0 0 0 0 0 "NA" 1 1736323461000 0 0 . .
1 20096 78386000 149 91 68 0 0 0 0 0 0 0 2 "NA" 1 1736372786000 0 0 . .
1 20096 78771000 144 90 65 0 0 0 0 0 0 0 2 "NA" 1 1736373171000 0 0 . .
1 20097 31788000 146 83 56 0 0 0 0 0 0 0 0 "NA" 1 1736412588000 0 0 . .
1 20097 32136000 150 86 55 0 0 0 0 0 0 0 0 "NA" 1 1736412936000 0 0 . .
1 20097 75252000 131 74 69 0 0 0 0 0 0 0 2 "NA" 1 1736456052000 0 0 . .
1 20097 75699000 132 72 65 0 0 0 0 0 0 0 2 "NA" 1 1736456499000 0 0 . .
1 20121 30678000 132 81 59 0 0 0 0 0 0 0 0 "NA" 1 1738485078000 2 1 . .
1 20121 31283000 142 75 54 0 0 0 0 0 0 0 0 "NA" 1 1738485683000 2 1 . .
1 20121 79170000 132 73 54 0 0 0 0 0 0 0 2 "NA" 1 1738533570000 2 1 . .
1 20121 79552000 131 79 58 0 0 0 0 0 0 0 2 "NA" 1 1738533952000 2 1 . .
1 20122 26085000 165 93 57 0 0 0 0 0 0 0 0 "NA" 1 1738566885000 2 1 . .
1 20122 26410000 145 85 58 0 0 0 0 0 0 0 0 "NA" 1 1738567210000 2 1 . .
1 20122 79644000 131 85 61 0 0 0 0 0 0 0 2 "NA" 1 1738620444000 2 1 . .
1 20122 80092000 145 82 61 0 0 0 0 0 0 0 2 "NA" 1 1738620892000 2 1 . .
1 20123 24822000 167 92 54 0 0 0 0 0 0 0 0 "NA" 1 1738652022000 2 1 . .
1 20123 25308000 147 85 55 0 0 0 0 0 0 0 0 "NA" 1 1738652508000 2 1 . .
1 20123 79827000 136 82 56 0 0 0 0 0 0 0 2 "NA" 1 1738707027000 2 1 . .
1 20123 80194000 136 76 57 0 0 0 0 0 0 0 2 "NA" 1 1738707394000 2 1 . .
1 20124 30674000 158 84 51 0 0 0 0 0 0 0 0 "NA" 1 1738744274000 2 1 . .
1 20124 31115000 153 93 55 0 0 0 0 0 0 0 0 "NA" 1 1738744715000 2 1 . .
1 20124 79716000 149 84 56 0 0 0 0 0 0 0 2 "NA" 1 1738793316000 2 1 . .
1 20124 80527000 129 76 58 0 0 0 0 0 0 0 2 "NA" 1 1738794127000 2 1 . .
1 20125 26426000 156 89 52 0 0 0 0 0 0 0 0 "NA" 1 1738826426000 2 1 . .
1 20125 26822000 131 81 51 0 0 0 0 0 0 0 0 "NA" 1 1738826822000 2 1 . .
1 20125 74276000 140 80 59 0 0 0 0 0 0 0 2 "NA" 1 1738874276000 2 1 . .
1 20125 74780000 131 75 57 0 0 0 0 0 0 0 2 "NA" 1 1738874780000 2 1 . .
1 20126 32679000 138 88 54 0 0 0 0 0 0 0 0 "NA" 1 1738919079000 2 1 . .
1 20126 33047000 139 77 56 0 0 0 0 0 0 0 0 "NA" 1 1738919447000 2 1 . .
1 20126 79535000 136 77 58 0 0 0 0 0 0 0 2 "NA" 1 1738965935000 2 1 . .
1 20126 79963000 139 78 60 0 0 0 0 0 0 0 2 "NA" 1 1738966363000 2 1 . .
1 20127 30807000 145 91 52 0 0 0 0 0 0 0 0 "NA" 1 1739003607000 2 1 . .
1 20127 31128000 138 88 56 0 0 0 0 0 0 0 0 "NA" 1 1739003928000 2 1 . .
1 20127 76170000 152 84 64 0 0 0 0 0 0 0 2 "NA" 1 1739048970000 2 1 . .
1 20127 76533000 144 85 67 0 0 0 0 0 0 0 2 "NA" 1 1739049333000 2 1 . .
1 20149 28016000 159 91 54 0 0 0 0 0 0 0 0 "NA" 1 1740901616000 2 1 . .
1 20149 28507000 159 92 50 0 0 0 0 0 0 0 0 "NA" 1 1740902107000 2 1 . .
1 20149 85484000 138 81 51 0 0 0 0 0 0 0 2 "NA" 1 1740959084000 2 1 . .
1 20149 85790000 128 76 54 0 0 0 0 0 0 0 2 "NA" 1 1740959390000 2 1 . .
1 20150 27636000 139 84 51 0 0 0 0 0 0 0 0 "NA" 1 1740987636000 2 1 . .
1 20150 27960000 134 87 49 0 0 0 0 0 0 0 0 "NA" 1 1740987960000 2 1 . .
1 20150 77044000 152 86 53 0 0 0 0 0 0 0 2 "NA" 1 1741037044000 2 1 . .
1 20150 77537000 130 81 54 0 0 0 0 0 0 0 2 "NA" 1 1741037537000 2 1 . .
1 20151 31020000 140 83 48 0 0 0 0 0 0 0 0 "NA" 1 1741077420000 2 1 . .
1 20151 31413000 145 79 50 0 0 0 0 0 0 0 0 "NA" 1 1741077813000 2 1 . .
1 20151 79270000 132 72 62 0 0 0 0 0 0 0 2 "NA" 1 1741125670000 2 1 . .
1 20151 79619000 131 74 61 0 0 0 0 0 0 0 2 "NA" 1 1741126019000 2 1 . .
1 20152 31630000 138 82 54 0 0 0 0 0 0 0 0 "NA" 1 1741164430000 2 1 . .
1 20152 32082000 135 84 50 0 0 0 0 0 0 0 0 "NA" 1 1741164882000 2 1 . .
1 20152 80361000 130 77 54 0 0 0 0 0 0 0 2 "NA" 1 1741213161000 2 1 . .
1 20152 80722000 131 79 54 0 0 0 0 0 0 0 2 "NA" 1 1741213522000 2 1 . .
1 20153 28280000 145 91 49 0 0 0 0 0 0 0 0 "NA" 1 1741247480000 2 1 . .
1 20153 28596000 145 87 48 0 0 0 0 0 0 0 0 "NA" 1 1741247796000 2 1 . .
1 20153 79818000 136 81 53 0 0 0 0 0 0 0 2 "NA" 1 1741299018000 2 1 . .
1 20153 80230000 127 81 56 0 0 0 0 0 0 0 2 "NA" 1 1741299430000 2 1 . .
1 20154 27547000 140 87 51 0 0 0 0 0 0 0 0 "NA" 1 1741333147000 2 1 . .
1 20154 27956000 149 84 49 0 0 0 0 0 0 0 0 "NA" 1 1741333556000 2 1 . .
1 20154 78585000 138 81 55 0 0 0 0 0 0 0 2 "NA" 1 1741384185000 2 1 . .
1 20154 78963000 132 79 55 0 0 0 0 0 0 0 2 "NA" 1 1741384563000 2 1 . .
1 20155 27346000 150 89 51 0 0 0 0 0 0 0 0 "NA" 1 1741419346000 2 1 . .
1 20155 27925000 139 80 51 0 0 0 0 0 0 0 0 "NA" 1 1741419925000 2 1 . .
1 20155 78667000 135 75 54 0 0 0 0 0 0 0 2 "NA" 1 1741470667000 2 1 . .
1 20155 79074000 132 74 53 0 0 0 0 0 0 0 2 "NA" 1 1741471074000 2 1 . .
1 20184 28620000 131 78 61 0 0 0 0 0 0 0 0 "NA" 1 1743926220000 0 0 . .
1 20184 29061000 126 76 57 0 0 0 0 0 0 0 0 "NA" 1 1743926661000 0 0 . .
1 20184 77974000 118 67 62 0 0 0 0 0 0 0 2 "NA" 1 1743975574000 0 0 . .
1 20184 78383000 114 66 61 0 0 0 0 0 0 0 2 "NA" 1 1743975983000 0 0 . .
1 20185 24002000 144 86 62 0 0 0 0 0 0 0 0 "NA" 1 1744008002000 0 0 . .
1 20185 24312000 140 87 65 0 0 0 0 0 0 0 0 "NA" 1 1744008312000 0 0 . .
1 20185 75260000 128 72 58 0 0 0 0 0 0 0 2 "NA" 1 1744059260000 0 0 . .
1 20185 75703000 126 71 61 0 0 0 0 0 0 0 2 "NA" 1 1744059703000 0 0 . .
1 20186 26691000 126 77 53 0 0 0 0 0 0 0 0 "NA" 1 1744097091000 0 0 . .
1 20186 27088000 131 75 50 0 0 0 0 0 0 0 0 "NA" 1 1744097488000 0 0 . .
1 20186 78011000 125 75 62 0 0 0 0 0 0 0 2 "NA" 1 1744148411000 0 0 . .
1 20186 78552000 131 76 59 0 0 0 0 0 0 0 2 "NA" 1 1744148952000 0 0 . .
1 20187 26003000 138 79 56 0 0 0 0 0 0 0 0 "NA" 1 1744182803000 0 0 . .
1 20187 26434000 137 79 54 0 0 0 0 0 0 0 0 "NA" 1 1744183234000 0 0 . .
1 20187 76355000 127 76 56 0 0 0 0 0 0 0 2 "NA" 1 1744233155000 0 0 . .
1 20187 76749000 127 74 55 0 0 0 0 0 0 0 2 "NA" 1 1744233549000 0 0 . .
end
format %tdDD/NN/CCYY DATE
format %tcHH:MM:SS TIME
format %tcDD/NN/CCYY_HH:MM:SS datetime
label values IRREGULAR_HEARTBEAT yn
label values EXCESSIVE_MOVEMENT yn
label values MEMO yn
label def yn 0 "No", modify
[/CODE]

[Nick Cox]

Day of the month is yielded by

gen dom = day(date)

On what precisely is the first (second, ...) week in each month, see e.g. https://www.statalist.org/forums/for...econd-week-etc

The answer there was written up in a note forthcoming in Stata Journal 22(1).