[Nick Cox]

I don't know what variable or variables are hidden in your example as you don't use dataex. I can't see how 2020, 53 would be sorted after any 2022 date without some quirk in the data that you are not showing us.

Please read and act on https://www.statalist.org/forums/help#stata (and FWIW https://www.statalist.org/forums/help#spelling).

It's hard to proceed unless you tell us the definition of week used by your data provider.


Weeks are quite a thing this week. See also https://www.statalist.org/forums/for...tnightly-rates

[Iris Voncken]

Excuse me for not using dataex and thank you for the help regarding the guidelines.

See my result below:

* Example generated by -dataex-. For more info, type help dataex
clear
input str14 Country str23 Week str8 Weeknumber double(Maxofpeople_fully_vaccinated_ Averageofexcess_mortality Averageofreproduction_rate) byte Interest_in_conspiracytheory float sweek long scountry
"Austria" "09/03/2020 - 15/03/2020" "2020, 11"     .   -.73 2.9828571428571427  66 3130 1
"Austria" "16/03/2020 - 22/03/2020" "2020, 12"     .  13.53  2.475714285714286  72 3131 1
"Austria" "23/03/2020 - 29/03/2020" "2020, 13"     .   6.01 1.7128571428571429  48 3132 1
"Austria" "30/03/2020 - 05/04/2020" "2020, 14"     .  13.92  .8814285714285715  51 3133 1
"Austria" "06/04/2020 - 12/04/2020" "2020, 15"     .  14.54  .6328571428571429  56 3134 1
"Austria" "13/04/2020 - 19/04/2020" "2020, 16"     .  10.46 .47000000000000003  61 3135 1
"Austria" "20/04/2020 - 26/04/2020" "2020, 17"     .   6.62  .5028571428571429  43 3136 1
"Austria" "27/04/2020 - 03/05/2020" "2020, 18"     .   -.26  .5842857142857143  38 3137 1
"Austria" "04/05/2020 - 10/05/2020" "2020, 19"     .   4.21  .7128571428571429  45 3138 1
"Austria" "11/05/2020 - 17/05/2020" "2020, 20"     .    .46  .9757142857142856 100 3139 1
"Austria" "18/05/2020 - 24/05/2020" "2020, 21"     .   2.79  .8371428571428571  71 3140 1
"Austria" "25/05/2020 - 31/05/2020" "2020, 22"     .  -1.09  .7985714285714286  61 3141 1
"Austria" "01/06/2020 - 07/06/2020" "2020, 23"     .   4.08  .9342857142857142  35 3142 1
"Austria" "08/06/2020 - 14/06/2020" "2020, 24"     .   -.11  .9714285714285714  23 3143 1
"Austria" "15/06/2020 - 21/06/2020" "2020, 25"     .   -.97 1.1085714285714285  24 3144 1
"Austria" "22/06/2020 - 28/06/2020" "2020, 26"     .   1.34                1.3  24 3145 1
"Austria" "29/06/2020 - 05/07/2020" "2020, 27"     .   7.33 1.5071428571428573  18 3146 1
"Austria" "06/07/2020 - 12/07/2020" "2020, 28"     .   -.97 1.1985714285714284  14 3147 1
"Austria" "13/07/2020 - 19/07/2020" "2020, 29"     .  -3.09 1.1914285714285715   7 3148 1
"Austria" "20/07/2020 - 26/07/2020" "2020, 30"     .  -3.71 1.1157142857142859  20 3149 1
"Austria" "27/07/2020 - 02/08/2020" "2020, 31"     .     .2 1.0371428571428571  18 3150 1
"Austria" "03/08/2020 - 09/08/2020" "2020, 32"     .   -.86 1.0142857142857145  27 3151 1
"Austria" "10/08/2020 - 16/08/2020" "2020, 33"     .    8.6 1.3900000000000003  23 3152 1
"Austria" "17/08/2020 - 23/08/2020" "2020, 34"     .   1.65 1.3399999999999999  31 3153 1
"Austria" "24/08/2020 - 30/08/2020" "2020, 35"     .   3.73 1.1428571428571428  25 3154 1
"Austria" "31/08/2020 - 06/09/2020" "2020, 36"     .   9.07 1.1742857142857142  21 3155 1
"Austria" "07/09/2020 - 13/09/2020" "2020, 37"     .   8.59 1.4157142857142857  16 3156 1
"Austria" "14/09/2020 - 20/09/2020" "2020, 38"     .   8.79 1.2914285714285714  24 3157 1
"Austria" "21/09/2020 - 27/09/2020" "2020, 39"     .   2.76  1.092857142857143  42 3158 1
"Austria" "28/09/2020 - 04/10/2020" "2020, 40"     .   3.75  1.125714285714286  22 3159 1
"Austria" "05/10/2020 - 11/10/2020" "2020, 41"     .   5.58 1.2328571428571429  26 3160 1
"Austria" "12/10/2020 - 18/10/2020" "2020, 42"     .   6.21  1.292857142857143  52 3161 1
"Austria" "19/10/2020 - 25/10/2020" "2020, 43"     .  16.48 1.4942857142857144  39 3162 1
"Austria" "26/10/2020 - 01/11/2020" "2020, 44"     .  23.74  1.567142857142857  31 3163 1
"Austria" "02/11/2020 - 08/11/2020" "2020, 45"     .  31.23  1.432857142857143  41 3164 1
"Austria" "09/11/2020 - 15/11/2020" "2020, 46"     .  45.52 1.2042857142857142  25 3165 1
"Austria" "16/11/2020 - 22/11/2020" "2020, 47"     .  55.02  .9585714285714284  31 3166 1
"Austria" "23/11/2020 - 29/11/2020" "2020, 48"     .     56  .8271428571428571  33 3167 1
"Austria" "30/11/2020 - 06/12/2020" "2020, 49"     .  57.19  .7585714285714286  32 3168 1
"Austria" "07/12/2020 - 13/12/2020" "2020, 50"     .  52.46  .7842857142857141  22 3169 1
"Austria" "14/12/2020 - 20/12/2020" "2020, 51"     .  35.34  .7985714285714286  44 3170 1
"Austria" "21/12/2020 - 27/12/2020" "2020, 52"     .  21.47  .8271428571428572  33 3171 1
"Austria" "04/01/2021 - 10/01/2021" "2021, 1"      .   6.94  .9985714285714286  44 3172 1
"Austria" "11/01/2021 - 17/01/2021" "2021, 2"      0   4.06  .9342857142857142  47 3173 1
"Austria" "18/01/2021 - 24/01/2021" "2021, 3"    .06  10.87  .8814285714285713  60 3174 1
"Austria" "25/01/2021 - 31/01/2021" "2021, 4"    .25  10.01                .89  31 3175 1
"Austria" "01/02/2021 - 07/02/2021" "2021, 5"   1.13   1.29  .9385714285714286  23 3176 1
"Austria" "08/02/2021 - 14/02/2021" "2021, 6"   2.11  -5.55 1.0157142857142856  27 3177 1
"Austria" "15/02/2021 - 21/02/2021" "2021, 7"   2.55  -6.33 1.1214285714285714  17 3178 1
"Austria" "22/02/2021 - 28/02/2021" "2021, 8"   2.79  -9.67 1.1614285714285713  27 3179 1
"Austria" "01/03/2021 - 07/03/2021" "2021, 9"   2.95 -13.64 1.1457142857142857  18 3180 1
"Austria" "08/03/2021 - 14/03/2021" "2021, 10"   3.3  -1.53 1.1428571428571428  19 3181 1
"Austria" "15/03/2021 - 21/03/2021" "2021, 11"  3.83  -2.48 1.1314285714285712  15 3182 1
"Austria" "22/03/2021 - 28/03/2021" "2021, 12"  4.86   2.24 1.0857142857142859  27 3183 1
"Austria" "29/03/2021 - 04/04/2021" "2021, 13"  5.76   6.38  .9971428571428572  24 3184 1
"Austria" "05/04/2021 - 11/04/2021" "2021, 14"  7.29   3.35  .9114285714285714  32 3185 1
"Austria" "12/04/2021 - 18/04/2021" "2021, 15"  8.38   8.03                 .9  37 3186 1
"Austria" "19/04/2021 - 25/04/2021" "2021, 16"  9.05   9.23                 .9  19 3187 1
"Austria" "26/04/2021 - 02/05/2021" "2021, 17"  9.82  13.65  .8528571428571429  12 3188 1
"Austria" "03/05/2021 - 09/05/2021" "2021, 18" 11.19  11.39  .7385714285714285  26 3189 1
"Austria" "10/05/2021 - 16/05/2021" "2021, 19" 12.44   9.69  .6671428571428571  17 3190 1
"Austria" "17/05/2021 - 23/05/2021" "2021, 20" 14.58   2.38  .6671428571428571  18 3191 1
"Austria" "24/05/2021 - 30/05/2021" "2021, 21" 17.32    3.1  .6928571428571428  21 3192 1
"Austria" "31/05/2021 - 06/06/2021" "2021, 22" 20.56  11.74  .6914285714285714  25 3193 1
"Austria" "07/06/2021 - 13/06/2021" "2021, 23" 24.56   8.83   .687142857142857  18 3194 1
"Austria" "14/06/2021 - 20/06/2021" "2021, 24" 28.51   9.26  .5928571428571427  15 3195 1
"Austria" "21/06/2021 - 27/06/2021" "2021, 25" 33.08  15.48  .6257142857142857  12 3196 1
"Austria" "28/06/2021 - 04/07/2021" "2021, 26" 38.04   6.01  .7557142857142857  21 3197 1
"Austria" "05/07/2021 - 11/07/2021" "2021, 27" 42.16     .7 1.2714285714285716  11 3198 1
"Austria" "12/07/2021 - 18/07/2021" "2021, 28" 45.84   4.06 1.6214285714285714   8 3199 1
"Austria" "19/07/2021 - 25/07/2021" "2021, 29" 49.13   5.92 1.3471428571428572  20 3200 1
"Austria" "26/07/2021 - 01/08/2021" "2021, 30" 52.06   1.36 1.2457142857142856  15 3201 1
"Austria" "02/08/2021 - 08/08/2021" "2021, 31" 54.55  -4.53 1.2057142857142857  10 3202 1
"Austria" "09/08/2021 - 15/08/2021" "2021, 32" 56.25  12.27 1.3585714285714288  23 3203 1
"Austria" "16/08/2021 - 22/08/2021" "2021, 33" 57.57   9.27 1.3299999999999998  15 3204 1
"Austria" "23/08/2021 - 29/08/2021" "2021, 34" 58.27   7.99 1.2285714285714284   6 3205 1
"Austria" "30/08/2021 - 05/09/2021" "2021, 35" 58.85   7.06               1.17  17 3206 1
"Austria" "06/09/2021 - 12/09/2021" "2021, 36" 59.36  16.34 1.2028571428571428  35 3207 1
"Austria" "13/09/2021 - 19/09/2021" "2021, 37" 59.89   9.21 1.0757142857142858  21 3208 1
"Austria" "20/09/2021 - 26/09/2021" "2021, 38" 60.41   9.14  .9614285714285715  24 3209 1
"Austria" "27/09/2021 - 03/10/2021" "2021, 39" 60.88  11.94               1.01   7 3210 1
"Austria" "04/10/2021 - 10/10/2021" "2021, 40" 61.37   4.62 1.0214285714285714  13 3211 1
"Austria" "11/10/2021 - 17/10/2021" "2021, 41" 61.82   5.92 1.1428571428571428  12 3212 1
"Austria" "18/10/2021 - 24/10/2021" "2021, 42" 62.26  12.82 1.3285714285714285  22 3213 1
"Austria" "25/10/2021 - 31/10/2021" "2021, 43" 62.63  23.55 1.3842857142857141  16 3214 1
"Austria" "01/11/2021 - 07/11/2021" "2021, 44" 63.04  26.48 1.4614285714285715  14 3215 1
"Austria" "08/11/2021 - 14/11/2021" "2021, 45" 63.54   34.4 1.3857142857142857  22 3216 1
"Austria" "15/11/2021 - 21/11/2021" "2021, 46" 64.15  34.28  1.247142857142857  53 3217 1
"Austria" "22/11/2021 - 28/11/2021" "2021, 47" 64.85  38.01  .9842857142857142  46 3218 1
"Austria" "29/11/2021 - 05/12/2021" "2021, 48" 65.86  40.54   .732857142857143  28 3219 1
"Austria" "06/12/2021 - 12/12/2021" "2021, 49" 66.95  30.97                 .6  33 3220 1
"Austria" "13/12/2021 - 19/12/2021" "2021, 50" 68.11  18.66  .6114285714285714  17 3221 1
"Austria" "20/12/2021 - 26/12/2021" "2021, 51" 68.78  10.35  .7085714285714287  17 3222 1
"Austria" "27/12/2021 - 02/01/2022" "2021, 52" 69.35    5.8 1.1528571428571428  21 3223 1
"Austria" "03/01/2022 - 09/01/2022" "2022, 1"  70.08  -4.94                1.7  21 3224 1
"Austria" "10/01/2022 - 16/01/2022" "2022, 2"  70.78 -11.75 1.6557142857142857  24 3225 1
"Austria" "17/01/2022 - 23/01/2022" "2022, 3"   71.2   -.41 1.5214285714285716  21 3226 1
"Austria" "24/01/2022 - 30/01/2022" "2022, 4"  71.55  -1.46 1.3828571428571428  27 3227 1
"Austria" "31/01/2022 - 06/02/2022" "2022, 5"   71.9  -4.25 1.1214285714285714  17 3228 1
"Austria" "07/02/2022 - 13/02/2022" "2022, 6"  72.16      . 1.0085714285714287   5 3229 1
"Austria" "14/02/2022 - 20/02/2022" "2022, 7"      .      .  .9739999999999999   7 3230 1
"Austria" "21/02/2022 - 24/02/2022" "2022, 8"      .      .                  .  21 3231 1
"Austria" "28/12/2020 - 03/01/2021" "2020, 53"     .  14.23  .9485714285714285  38    . 1
"Belgium" "09/03/2020 - 15/03/2020" "2020, 11"     .  -4.51 2.5742857142857143  55 3130 2
"Belgium" "16/03/2020 - 22/03/2020" "2020, 12"     .  10.22 2.3771428571428572 100 3131 2
"Belgium" "23/03/2020 - 29/03/2020" "2020, 13"     .  43.94               2.04  55 3132 2
"Belgium" "30/03/2020 - 05/04/2020" "2020, 14"     .  90.16 1.5642857142857143  70 3133 2
"Belgium" "06/04/2020 - 12/04/2020" "2020, 15"     . 105.35  1.237142857142857  44 3134 2
"Belgium" "13/04/2020 - 19/04/2020" "2020, 16"     .  80.96 1.0371428571428571  53 3135 2
"Belgium" "20/04/2020 - 26/04/2020" "2020, 17"     .  49.92  .8628571428571429  51 3136 2
end
format %tw sweek
label values scountry scountry
label def scountry 1 "Austria", modify
label def scountry 2 "Belgium", modify

The definition of my weeks is Monday-Sunday.

Thank you

[Iris Voncken]

The following happens when using code:

egen numweek = group(Weeknumber), label

* Example generated by -dataex-. For more info, type help dataex
clear
input str14 Country str23 Week str8 Weeknumber double(Maxofpeople_fully_vaccinated_ Averageofexcess_mortality Averageofreproduction_rate) byte Interest_in_conspiracytheory float sweek long scountry float numweek
"Austria" "09/03/2020 - 15/03/2020" "2020, 11"     .   -.73 2.9828571428571427  66 3130 1   1
"Austria" "16/03/2020 - 22/03/2020" "2020, 12"     .  13.53  2.475714285714286  72 3131 1   2
"Austria" "23/03/2020 - 29/03/2020" "2020, 13"     .   6.01 1.7128571428571429  48 3132 1   3
"Austria" "30/03/2020 - 05/04/2020" "2020, 14"     .  13.92  .8814285714285715  51 3133 1   4
"Austria" "06/04/2020 - 12/04/2020" "2020, 15"     .  14.54  .6328571428571429  56 3134 1   5
"Austria" "13/04/2020 - 19/04/2020" "2020, 16"     .  10.46 .47000000000000003  61 3135 1   6
"Austria" "20/04/2020 - 26/04/2020" "2020, 17"     .   6.62  .5028571428571429  43 3136 1   7
"Austria" "27/04/2020 - 03/05/2020" "2020, 18"     .   -.26  .5842857142857143  38 3137 1   8
"Austria" "04/05/2020 - 10/05/2020" "2020, 19"     .   4.21  .7128571428571429  45 3138 1   9
"Austria" "11/05/2020 - 17/05/2020" "2020, 20"     .    .46  .9757142857142856 100 3139 1  10
"Austria" "18/05/2020 - 24/05/2020" "2020, 21"     .   2.79  .8371428571428571  71 3140 1  11
"Austria" "25/05/2020 - 31/05/2020" "2020, 22"     .  -1.09  .7985714285714286  61 3141 1  12
"Austria" "01/06/2020 - 07/06/2020" "2020, 23"     .   4.08  .9342857142857142  35 3142 1  13
"Austria" "08/06/2020 - 14/06/2020" "2020, 24"     .   -.11  .9714285714285714  23 3143 1  14
"Austria" "15/06/2020 - 21/06/2020" "2020, 25"     .   -.97 1.1085714285714285  24 3144 1  15
"Austria" "22/06/2020 - 28/06/2020" "2020, 26"     .   1.34                1.3  24 3145 1  16
"Austria" "29/06/2020 - 05/07/2020" "2020, 27"     .   7.33 1.5071428571428573  18 3146 1  17
"Austria" "06/07/2020 - 12/07/2020" "2020, 28"     .   -.97 1.1985714285714284  14 3147 1  18
"Austria" "13/07/2020 - 19/07/2020" "2020, 29"     .  -3.09 1.1914285714285715   7 3148 1  19
"Austria" "20/07/2020 - 26/07/2020" "2020, 30"     .  -3.71 1.1157142857142859  20 3149 1  20
"Austria" "27/07/2020 - 02/08/2020" "2020, 31"     .     .2 1.0371428571428571  18 3150 1  21
"Austria" "03/08/2020 - 09/08/2020" "2020, 32"     .   -.86 1.0142857142857145  27 3151 1  22
"Austria" "10/08/2020 - 16/08/2020" "2020, 33"     .    8.6 1.3900000000000003  23 3152 1  23
"Austria" "17/08/2020 - 23/08/2020" "2020, 34"     .   1.65 1.3399999999999999  31 3153 1  24
"Austria" "24/08/2020 - 30/08/2020" "2020, 35"     .   3.73 1.1428571428571428  25 3154 1  25
"Austria" "31/08/2020 - 06/09/2020" "2020, 36"     .   9.07 1.1742857142857142  21 3155 1  26
"Austria" "07/09/2020 - 13/09/2020" "2020, 37"     .   8.59 1.4157142857142857  16 3156 1  27
"Austria" "14/09/2020 - 20/09/2020" "2020, 38"     .   8.79 1.2914285714285714  24 3157 1  28
"Austria" "21/09/2020 - 27/09/2020" "2020, 39"     .   2.76  1.092857142857143  42 3158 1  29
"Austria" "28/09/2020 - 04/10/2020" "2020, 40"     .   3.75  1.125714285714286  22 3159 1  30
"Austria" "05/10/2020 - 11/10/2020" "2020, 41"     .   5.58 1.2328571428571429  26 3160 1  31
"Austria" "12/10/2020 - 18/10/2020" "2020, 42"     .   6.21  1.292857142857143  52 3161 1  32
"Austria" "19/10/2020 - 25/10/2020" "2020, 43"     .  16.48 1.4942857142857144  39 3162 1  33
"Austria" "26/10/2020 - 01/11/2020" "2020, 44"     .  23.74  1.567142857142857  31 3163 1  34
"Austria" "02/11/2020 - 08/11/2020" "2020, 45"     .  31.23  1.432857142857143  41 3164 1  35
"Austria" "09/11/2020 - 15/11/2020" "2020, 46"     .  45.52 1.2042857142857142  25 3165 1  36
"Austria" "16/11/2020 - 22/11/2020" "2020, 47"     .  55.02  .9585714285714284  31 3166 1  37
"Austria" "23/11/2020 - 29/11/2020" "2020, 48"     .     56  .8271428571428571  33 3167 1  38
"Austria" "30/11/2020 - 06/12/2020" "2020, 49"     .  57.19  .7585714285714286  32 3168 1  39
"Austria" "07/12/2020 - 13/12/2020" "2020, 50"     .  52.46  .7842857142857141  22 3169 1  40
"Austria" "14/12/2020 - 20/12/2020" "2020, 51"     .  35.34  .7985714285714286  44 3170 1  41
"Austria" "21/12/2020 - 27/12/2020" "2020, 52"     .  21.47  .8271428571428572  33 3171 1  42
"Austria" "04/01/2021 - 10/01/2021" "2021, 1"      .   6.94  .9985714285714286  44 3172 1  44
"Austria" "11/01/2021 - 17/01/2021" "2021, 2"      0   4.06  .9342857142857142  47 3173 1  55
"Austria" "18/01/2021 - 24/01/2021" "2021, 3"    .06  10.87  .8814285714285713  60 3174 1  66
"Austria" "25/01/2021 - 31/01/2021" "2021, 4"    .25  10.01                .89  31 3175 1  77
"Austria" "01/02/2021 - 07/02/2021" "2021, 5"   1.13   1.29  .9385714285714286  23 3176 1  88
"Austria" "08/02/2021 - 14/02/2021" "2021, 6"   2.11  -5.55 1.0157142857142856  27 3177 1  92
"Austria" "15/02/2021 - 21/02/2021" "2021, 7"   2.55  -6.33 1.1214285714285714  17 3178 1  93
"Austria" "22/02/2021 - 28/02/2021" "2021, 8"   2.79  -9.67 1.1614285714285713  27 3179 1  94
"Austria" "01/03/2021 - 07/03/2021" "2021, 9"   2.95 -13.64 1.1457142857142857  18 3180 1  95
"Austria" "08/03/2021 - 14/03/2021" "2021, 10"   3.3  -1.53 1.1428571428571428  19 3181 1  45
"Austria" "15/03/2021 - 21/03/2021" "2021, 11"  3.83  -2.48 1.1314285714285712  15 3182 1  46
"Austria" "22/03/2021 - 28/03/2021" "2021, 12"  4.86   2.24 1.0857142857142859  27 3183 1  47
"Austria" "29/03/2021 - 04/04/2021" "2021, 13"  5.76   6.38  .9971428571428572  24 3184 1  48
"Austria" "05/04/2021 - 11/04/2021" "2021, 14"  7.29   3.35  .9114285714285714  32 3185 1  49
"Austria" "12/04/2021 - 18/04/2021" "2021, 15"  8.38   8.03                 .9  37 3186 1  50
"Austria" "19/04/2021 - 25/04/2021" "2021, 16"  9.05   9.23                 .9  19 3187 1  51
"Austria" "26/04/2021 - 02/05/2021" "2021, 17"  9.82  13.65  .8528571428571429  12 3188 1  52
"Austria" "03/05/2021 - 09/05/2021" "2021, 18" 11.19  11.39  .7385714285714285  26 3189 1  53
"Austria" "10/05/2021 - 16/05/2021" "2021, 19" 12.44   9.69  .6671428571428571  17 3190 1  54
"Austria" "17/05/2021 - 23/05/2021" "2021, 20" 14.58   2.38  .6671428571428571  18 3191 1  56
"Austria" "24/05/2021 - 30/05/2021" "2021, 21" 17.32    3.1  .6928571428571428  21 3192 1  57
"Austria" "31/05/2021 - 06/06/2021" "2021, 22" 20.56  11.74  .6914285714285714  25 3193 1  58
"Austria" "07/06/2021 - 13/06/2021" "2021, 23" 24.56   8.83   .687142857142857  18 3194 1  59
"Austria" "14/06/2021 - 20/06/2021" "2021, 24" 28.51   9.26  .5928571428571427  15 3195 1  60
"Austria" "21/06/2021 - 27/06/2021" "2021, 25" 33.08  15.48  .6257142857142857  12 3196 1  61
"Austria" "28/06/2021 - 04/07/2021" "2021, 26" 38.04   6.01  .7557142857142857  21 3197 1  62
"Austria" "05/07/2021 - 11/07/2021" "2021, 27" 42.16     .7 1.2714285714285716  11 3198 1  63
"Austria" "12/07/2021 - 18/07/2021" "2021, 28" 45.84   4.06 1.6214285714285714   8 3199 1  64
"Austria" "19/07/2021 - 25/07/2021" "2021, 29" 49.13   5.92 1.3471428571428572  20 3200 1  65
"Austria" "26/07/2021 - 01/08/2021" "2021, 30" 52.06   1.36 1.2457142857142856  15 3201 1  67
"Austria" "02/08/2021 - 08/08/2021" "2021, 31" 54.55  -4.53 1.2057142857142857  10 3202 1  68
"Austria" "09/08/2021 - 15/08/2021" "2021, 32" 56.25  12.27 1.3585714285714288  23 3203 1  69
"Austria" "16/08/2021 - 22/08/2021" "2021, 33" 57.57   9.27 1.3299999999999998  15 3204 1  70
"Austria" "23/08/2021 - 29/08/2021" "2021, 34" 58.27   7.99 1.2285714285714284   6 3205 1  71
"Austria" "30/08/2021 - 05/09/2021" "2021, 35" 58.85   7.06               1.17  17 3206 1  72
"Austria" "06/09/2021 - 12/09/2021" "2021, 36" 59.36  16.34 1.2028571428571428  35 3207 1  73
"Austria" "13/09/2021 - 19/09/2021" "2021, 37" 59.89   9.21 1.0757142857142858  21 3208 1  74
"Austria" "20/09/2021 - 26/09/2021" "2021, 38" 60.41   9.14  .9614285714285715  24 3209 1  75
"Austria" "27/09/2021 - 03/10/2021" "2021, 39" 60.88  11.94               1.01   7 3210 1  76
"Austria" "04/10/2021 - 10/10/2021" "2021, 40" 61.37   4.62 1.0214285714285714  13 3211 1  78
"Austria" "11/10/2021 - 17/10/2021" "2021, 41" 61.82   5.92 1.1428571428571428  12 3212 1  79
"Austria" "18/10/2021 - 24/10/2021" "2021, 42" 62.26  12.82 1.3285714285714285  22 3213 1  80
"Austria" "25/10/2021 - 31/10/2021" "2021, 43" 62.63  23.55 1.3842857142857141  16 3214 1  81
"Austria" "01/11/2021 - 07/11/2021" "2021, 44" 63.04  26.48 1.4614285714285715  14 3215 1  82
"Austria" "08/11/2021 - 14/11/2021" "2021, 45" 63.54   34.4 1.3857142857142857  22 3216 1  83
"Austria" "15/11/2021 - 21/11/2021" "2021, 46" 64.15  34.28  1.247142857142857  53 3217 1  84
"Austria" "22/11/2021 - 28/11/2021" "2021, 47" 64.85  38.01  .9842857142857142  46 3218 1  85
"Austria" "29/11/2021 - 05/12/2021" "2021, 48" 65.86  40.54   .732857142857143  28 3219 1  86
"Austria" "06/12/2021 - 12/12/2021" "2021, 49" 66.95  30.97                 .6  33 3220 1  87
"Austria" "13/12/2021 - 19/12/2021" "2021, 50" 68.11  18.66  .6114285714285714  17 3221 1  89
"Austria" "20/12/2021 - 26/12/2021" "2021, 51" 68.78  10.35  .7085714285714287  17 3222 1  90
"Austria" "27/12/2021 - 02/01/2022" "2021, 52" 69.35    5.8 1.1528571428571428  21 3223 1  91
"Austria" "03/01/2022 - 09/01/2022" "2022, 1"  70.08  -4.94                1.7  21 3224 1  96
"Austria" "10/01/2022 - 16/01/2022" "2022, 2"  70.78 -11.75 1.6557142857142857  24 3225 1  97
"Austria" "17/01/2022 - 23/01/2022" "2022, 3"   71.2   -.41 1.5214285714285716  21 3226 1  98
"Austria" "24/01/2022 - 30/01/2022" "2022, 4"  71.55  -1.46 1.3828571428571428  27 3227 1  99
"Austria" "31/01/2022 - 06/02/2022" "2022, 5"   71.9  -4.25 1.1214285714285714  17 3228 1 100
"Austria" "07/02/2022 - 13/02/2022" "2022, 6"  72.16      . 1.0085714285714287   5 3229 1 101
"Austria" "14/02/2022 - 20/02/2022" "2022, 7"      .      .  .9739999999999999   7 3230 1 102
"Austria" "21/02/2022 - 24/02/2022" "2022, 8"      .      .                  .  21 3231 1 103
"Austria" "28/12/2020 - 03/01/2021" "2020, 53"     .  14.23  .9485714285714285  38    . 1  43
"Belgium" "09/03/2020 - 15/03/2020" "2020, 11"     .  -4.51 2.5742857142857143  55 3130 2   1
"Belgium" "16/03/2020 - 22/03/2020" "2020, 12"     .  10.22 2.3771428571428572 100 3131 2   2
"Belgium" "23/03/2020 - 29/03/2020" "2020, 13"     .  43.94               2.04  55 3132 2   3
"Belgium" "30/03/2020 - 05/04/2020" "2020, 14"     .  90.16 1.5642857142857143  70 3133 2   4
"Belgium" "06/04/2020 - 12/04/2020" "2020, 15"     . 105.35  1.237142857142857  44 3134 2   5
"Belgium" "13/04/2020 - 19/04/2020" "2020, 16"     .  80.96 1.0371428571428571  53 3135 2   6
"Belgium" "20/04/2020 - 26/04/2020" "2020, 17"     .  49.92  .8628571428571429  51 3136 2   7
end
format %tw sweek
label values scountry scountry
label def scountry 1 "Austria", modify
label def scountry 2 "Belgium", modify
label values numweek numweek
label def numweek 1 "2020, 11", modify
label def numweek 2 "2020, 12", modify
label def numweek 3 "2020, 13", modify
label def numweek 4 "2020, 14", modify
label def numweek 5 "2020, 15", modify
label def numweek 6 "2020, 16", modify
label def numweek 7 "2020, 17", modify
label def numweek 8 "2020, 18", modify
label def numweek 9 "2020, 19", modify
label def numweek 10 "2020, 20", modify
label def numweek 11 "2020, 21", modify
label def numweek 12 "2020, 22", modify
label def numweek 13 "2020, 23", modify
label def numweek 14 "2020, 24", modify
label def numweek 15 "2020, 25", modify
label def numweek 16 "2020, 26", modify
label def numweek 17 "2020, 27", modify
label def numweek 18 "2020, 28", modify
label def numweek 19 "2020, 29", modify
label def numweek 20 "2020, 30", modify
label def numweek 21 "2020, 31", modify
label def numweek 22 "2020, 32", modify
label def numweek 23 "2020, 33", modify
label def numweek 24 "2020, 34", modify
label def numweek 25 "2020, 35", modify
label def numweek 26 "2020, 36", modify
label def numweek 27 "2020, 37", modify
label def numweek 28 "2020, 38", modify
label def numweek 29 "2020, 39", modify
label def numweek 30 "2020, 40", modify
label def numweek 31 "2020, 41", modify
label def numweek 32 "2020, 42", modify
label def numweek 33 "2020, 43", modify
label def numweek 34 "2020, 44", modify
label def numweek 35 "2020, 45", modify
label def numweek 36 "2020, 46", modify
label def numweek 37 "2020, 47", modify
label def numweek 38 "2020, 48", modify
label def numweek 39 "2020, 49", modify
label def numweek 40 "2020, 50", modify
label def numweek 41 "2020, 51", modify
label def numweek 42 "2020, 52", modify
label def numweek 43 "2020, 53", modify
label def numweek 44 "2021, 1", modify
label def numweek 45 "2021, 10", modify
label def numweek 46 "2021, 11", modify
label def numweek 47 "2021, 12", modify
label def numweek 48 "2021, 13", modify
label def numweek 49 "2021, 14", modify
label def numweek 50 "2021, 15", modify
label def numweek 51 "2021, 16", modify
label def numweek 52 "2021, 17", modify
label def numweek 53 "2021, 18", modify
label def numweek 54 "2021, 19", modify
label def numweek 55 "2021, 2", modify
label def numweek 56 "2021, 20", modify
label def numweek 57 "2021, 21", modify
label def numweek 58 "2021, 22", modify
label def numweek 59 "2021, 23", modify
label def numweek 60 "2021, 24", modify
label def numweek 61 "2021, 25", modify
label def numweek 62 "2021, 26", modify
label def numweek 63 "2021, 27", modify
label def numweek 64 "2021, 28", modify
label def numweek 65 "2021, 29", modify
label def numweek 66 "2021, 3", modify
label def numweek 67 "2021, 30", modify
label def numweek 68 "2021, 31", modify
label def numweek 69 "2021, 32", modify
label def numweek 70 "2021, 33", modify
label def numweek 71 "2021, 34", modify
label def numweek 72 "2021, 35", modify
label def numweek 73 "2021, 36", modify
label def numweek 74 "2021, 37", modify
label def numweek 75 "2021, 38", modify
label def numweek 76 "2021, 39", modify
label def numweek 77 "2021, 4", modify
label def numweek 78 "2021, 40", modify
label def numweek 79 "2021, 41", modify
label def numweek 80 "2021, 42", modify
label def numweek 81 "2021, 43", modify
label def numweek 82 "2021, 44", modify
label def numweek 83 "2021, 45", modify
label def numweek 84 "2021, 46", modify
label def numweek 85 "2021, 47", modify
label def numweek 86 "2021, 48", modify
label def numweek 87 "2021, 49", modify
label def numweek 88 "2021, 5", modify
label def numweek 89 "2021, 50", modify
label def numweek 90 "2021, 51", modify
label def numweek 91 "2021, 52", modify
label def numweek 92 "2021, 6", modify
label def numweek 93 "2021, 7", modify
label def numweek 94 "2021, 8", modify
label def numweek 95 "2021, 9", modify
label def numweek 96 "2022, 1", modify
label def numweek 97 "2022, 2", modify
label def numweek 98 "2022, 3", modify
label def numweek 99 "2022, 4", modify
label def numweek 100 "2022, 5", modify
label def numweek 101 "2022, 6", modify
label def numweek 102 "2022, 7", modify
label def numweek 103 "2022, 8", modify

[Nick Cox]

The Weeknumber string variable is not fit for your purpose as (for example) the sort order puts "2020, 39" "2020, 4" "2020, 40" in that order, which is wrong. You can see this by looking carefully at the value labels.

You could parse that variable into year and week number but that's no use for defining Stata weekly dates because -- as discussed -- Stata has no concept of week 53.

You have perfectly good information in the Week variable, from which you can create your home-made weeks by

gen betterweek = daily(word(Week, 1), "DMY")
format betterweek %td

thus indexing each week numerically by the day that starts it. And, naturally, enough those daily dates are 7 days apart.

If you need a week number for your own purposes -- but whatever you do don't mix it with Stata's weekly functions or formata --- then it's

gen weekno = real(word(Weeknumber, 2))

and similarly you can extract the year by

gen year =  real(substr(Weeknumber, 1, 4))

(not word 1 as each first word includes the comma).

Stata's week functions and formats are only useful if your data provider uses Stata's definitions.

[Iris Voncken]

Thank you for taking the time to have a look at my dataset. Your suggestions have solved my problem! Thanks again.