How to tsset YYYYWW,weekly?

[Travis Chang]

Hi:
I import the excel spreadsheet and there has a variable "week" where it is showing year and week in the format yyyyww. For example, when the variable takes the value 2022W1 it is week 1 in the year 2022. But all the variable "week" is displayed as red words in data browse. I want to use weekly stock price data for analysis.



Data example for the week variable:[INDENT=3] [/INDENT]

 
week
eg_w
ym_w
wh_w
wisdom_w
uming_w

2022W30
93.06
87.58
103.6
68.1
42.26

2022W29
91.56
87.56
113.5
67.84
41.85

2022W28
89.08
85.54
116.3
65.48
39.16

2022W27
87.42
82.06
116.4
64.88
39.8

2022W26
94.08
84.68
121.2
67.24
41.88

2022W25
103.26
103.3
118
69.38
45.95

2022W24
125.8
120.5
137.7
82.98
54.18

2022W23
142.5
127.2
156.8
97.76
58

2022W22
143.375
126
158.375
100.225
59.825

2022W21
143.1
126.5
160.5
98.06
61.58

2022W20
136.3
117.1
146.7
93.24
59.3

2022W19
144.6
124.4
150.6
97.72
62.2

2022W18
151.125
129.25
149.75
102.025
64.725

2022W17
140.3
122
145
87.78
63.96

2022W16
143.2
123.8
155.2
98.24
66.28

2022W15
138
122.4
154.4
91.4
58.84

2022W14
132.5
122.166667
153.166667
86.9333333
57.1333333

2022W13
135.3
124.2
157.8
86.72
59.3

2022W12
140.7
128.3
160.4
86.72
61.4

2022W11
150.6
130.5
169.4
91.18
63.28

2022W10
154
123.7
175.2
93.06
62.04

2022W9
155.375
124.75
191.875
92.425
61.15

2022W8
143.9
115.4
187.1
90.22
60.66

2022W7
134.1
112.5
183.9
87.1
59.82

2022W6
129.1
111.7
171
81.26
58.52

Thanks for your help.

[Nick Cox]

So week is a string variable. It may be that you can go

gen wdate = weekly(week, "YW") 
format wdate %tw

However, if you have any week 53 values, your weekly definitions are not consistent with Stata's definition of weeks. You can find out by going

count if substr(week, -2, 2) == "53"

and seeing the result.