Convert month, date to Stata format

[Al Bothwell]

I need help with converting the following data to Stata date format. The dates are month and year. For example, the first observation is February 1990. I will like convert it to a "MDY" format where the Day is the 15th of every month. Your help will be appreciated.

dob_m_yr
21990
61999
101983
101987
71949
31979
81957
31980
11985
51995
81988

[Hemanshu Kumar]

clear
input long dob_m_yr
21990
61999
101983
101987
71949
31979
81957
31980
11985
51995
81988
end

gen date_str = string(dob_m_yr,"%06.0f")
replace date_str = "15/" + substr(date_str,1,2) + "/" + substr(date_str,3,4)
gen date = daily(date_str,"DMY")
format %td date

li, sep(0) noobs

  +-----------------------------------+
  | dob_m_yr     date_str        date |
  |-----------------------------------|
  |    21990   15/02/1990   15feb1990 |
  |    61999   15/06/1999   15jun1999 |
  |   101983   15/10/1983   15oct1983 |
  |   101987   15/10/1987   15oct1987 |
  |    71949   15/07/1949   15jul1949 |
  |    31979   15/03/1979   15mar1979 |
  |    81957   15/08/1957   15aug1957 |
  |    31980   15/03/1980   15mar1980 |
  |    11985   15/01/1985   15jan1985 |
  |    51995   15/05/1995   15may1995 |
  |    81988   15/08/1988   15aug1988 |
  +-----------------------------------+

[Al Bothwell]

Thank you, Hemanshu for the solution.

[Nick Cox]

Here's another way to do it.

clear 
input dob_m_yr
21990
61999
101983
101987
71949
31979
81957
31980
11985
51995
81988
end 

gen wanted = mdy(floor(dob/10000), 15, mod(dob, 10000))
format wanted %td 

list 

     +----------------------+
     | dob_m_yr      wanted |
     |----------------------|
  1. |    21990   15feb1990 |
  2. |    61999   15jun1999 |
  3. |   101983   15oct1983 |
  4. |   101987   15oct1987 |
  5. |    71949   15jul1949 |
     |----------------------|
  6. |    31979   15mar1979 |
  7. |    81957   15aug1957 |
  8. |    31980   15mar1980 |
  9. |    11985   15jan1985 |
 10. |    51995   15may1995 |
     |----------------------|
 11. |    81988   15aug1988 |
     +----------------------+

[aid teshome]

I have 3 vdates which i want to join by fron another datasets to determine if AE fell under vdate3 or vdate14 or etc. Can you please lead me how to do this?

---

Data#1
subjid vdate3 vdate14 vdate25
1 20nov2021 18dec2021 14jan2022
2 20nov2021 18dec2021 14jan2022
5 20nov2021 18dec2021 14jan2022
7 20nov2021 18dec2021 14jan2022
8 20nov2021 18dec2021 14jan2022
9 20nov2021 18dec2021 14jan2022
10 04dec2021 01jan2022 29jan2022
13 04dec2021 01jan2022 29jan2022
14 04dec2021 01jan2022 29jan2022
15 04dec2021 01jan2022 29jan2022
16 04dec2021 01jan2022 29jan2022
17 18dec2021 15jan2022 12feb2022
19 04dec2021 01jan2022 29jan2022
20 06jan2022 03feb2022 03mar2022
24 18dec2021 15jan2022 12feb2022
25 18dec2021 15jan2022 12feb2022
26 18dec2021 15jan2022 12feb2022
27 18dec2021 15jan2022 12feb2022
29 18dec2021 15jan2022 12feb2022
30 18dec2021 15jan2022 12feb2022
32 06jan2022 03feb2022 03mar2022
33 06jan2022
37 06jan2022 03feb2022 03mar2022
38 06jan2022 03feb2022 03mar2022
40 07jan2022 04feb2022 04mar2022
41 07jan2022 04feb2022 04mar2022
42 07jan2022 04feb2022 04mar2022
46 06jan2022 03feb2022 03mar2022
47 07jan2022 04feb2022 04mar2022
49 07jan2022 04feb2022 04mar2022
51 07jan2022 04feb2022 04mar2022
54 06jan2022 03feb2022 03mar2022
55 07jan2022 04feb2022 04mar2022
56 06jan2022 03feb2022 03mar2022
57 07jan2022 04feb2022 04mar2022
59 08jan2022 05feb2022 05mar2022
60 06jan2022 03feb2022 03mar2022
62 06jan2022 03feb2022 03mar2022
63 06jan2022 03feb2022 03mar2022
64 06jan2022 03feb2022 03mar2022
65 06jan2022 03feb2022 03mar2022
71 12jan2022 09feb2022 16mar2022
73 06jan2022 03feb2022 03mar2022
74 07jan2022 04feb2022 04mar2022
75 06jan2022 03feb2022 03mar2022
77 06jan2022 03feb2022 03mar2022
78 06jan2022 03feb2022 03mar2022
80 07jan2022 09feb2022 09mar2022
81 06jan2022 03feb2022 03mar2022
82 07jan2022 04feb2022 04mar2022
83 06jan2022 03feb2022 03mar2022
85 06jan2022 03feb2022 03mar2022
87 07jan2022 04feb2022 04mar2022
88 07jan2022 04feb2022 04mar2022
89 07jan2022 04feb2022 04mar2022
90 07jan2022 04feb2022 04mar2022
92 07jan2022 04feb2022 04mar2022
93 06jan2022 03feb2022 03mar2022
98 12jan2022 09feb2022 09mar2022
101 07jan2022 04feb2022 04mar2022
102 07jan2022 04feb2022 04mar2022
105 08jan2022 05feb2022 05mar2022
106 08jan2022 05feb2022 05mar2022
107 08jan2022 05feb2022 05mar2022
108 08jan2022 05feb2022 05mar2022
109 07jan2022 04feb2022 04mar2022
110 08jan2022 05feb2022 05mar2022
111 08jan2022 05feb2022 05mar2022
112 08jan2022 05feb2022 05mar2022
113 08jan2022 05feb2022 05mar2022
114 08jan2022 05feb2022 05mar2022
117 08jan2022 05feb2022 05mar2022
118 07jan2022 04feb2022
119 08jan2022 05feb2022 05mar2022
120 08jan2022
121 08jan2022 05feb2022 05mar2022
124 08jan2022 05feb2022 09mar2022
125 12jan2022 09feb2022 16mar2022
126 12jan2022 09feb2022 09mar2022



Data #2

number patient vdate
301 1 28jan2022
302 1 08mar2022
303 1 26jul2022
304 1 26jul2022
305 1 09oct2022
301 2 23nov2021
302 2 19dec2021
303 2 18dec2021
304 2 14jan2022
305 2 08aug2022
306 2 08aug2022
307 2 07nov2022
301 5 19dec2021
302 5 14jan2022
303 5 01jul2022
304 5 10aug2022
305 5 03sep2022
301 7 19dec2021
302 7 14jan2022
303 7 20nov2021
304 7 10apr2022
305 7 29oct2021
306 7 18aug2022
307 7 18aug2022
308 7 13oct2022
301 8 21nov2021
302 8 19dec2021
303 8 21dec2021
304 8 15jan2022
305 8 21dec2021
306 8 20apr2022
307 8 13oct2022
308 8 11jul2022
301 9 18dec2021
302 9 18dec2021
303 9 05jan2022
304 9 10jan2022
305 9 27oct2021
306 9 26oct2022
301 10 05dec2021
302 10 02jan2022
303 10 30jan2022
304 10 24oct2022
301 13 01jan2022
301 14 05dec2021
302 14 02jan2022
303 14 12feb2022
301 15 01jan2022
302 15 02jan2022
303 15 01jan2022
304 15 01jan2022
305 15 27jan2022
306 15 29jan2022
307 15 07sep2022
308 15 10sep2022
301 16 04dec2021
302 16 14jan2022
303 16 14feb2022
304 16 26mar2022
305 16 19apr2022
306 16 24sep2022
307 16 14nov2022
301 17 09apr2022
302 17 17sep2022
301 19 05dec2021
302 19 05dec2021
303 19 04jan2022
304 19 29jan2022
305 19 04jan2022
306 19 20aug2022
301 20 10jan2022
302 20 18jan2022
303 20 04feb2022
304 20 06mar2022
301 24 21dec2021
302 24 27nov2021
301 25 19feb2022
301 26 16jan2022
302 26 26feb2022
303 26 18aug2022
301 27 16jan2022
302 27 16jan2022
303 27 13feb2022
304 27 19mar2022
305 27 19mar2022
306 27 12aug2022
301 29 25feb2022
302 29 17oct2022
301 30 19dec2021
302 30 16jan2022
303 30 16jan2022
304 30 16jan2022
305 30 15jan2022
306 30 18jan2022
307 30 01feb2022
308 30 13feb2022
309 30 12feb2022
310 30 18jul2022
311 30 01oct2022
301 32 03mar2022
302 32 25jul2022
303 32 13oct2022
304 32 13oct2022
301 37 07jan2022
302 37 07jan2022
303 37 04feb2022
304 37 29aug2022
305 37 12oct2022
301 38 10aug2022
302 38 10aug2022
303 38 13oct2022
304 38 02sep2022
305 38 13nov2022
301 40 05feb2022
301 41 08jan2022
302 41 12mar2022
303 41 06apr2022
301 42 04feb2022
301 46 06jan2022
302 46 06jan2022
303 46 03mar2022
301 47 08jan2022
302 47 19jan2022
303 47 05feb2022
304 47 08feb2022
305 47 12oct2022
301 49 15sep2022
301 51 07feb2022
302 51 19feb2022
303 51 17mar2022
304 51 27may2022
301 54 18aug2022
301 56 06jan2022
302 56 07jan2022
303 56 07jan2022
304 56 03feb2022
305 56 04feb2022
306 56 03feb2022
307 56 19feb2022
308 56 05may2022
309 56 05jul2022
310 56 16aug2022
301 57 05feb2022
302 57 09may2022
303 57 30oct2022
301 59 06feb2022
301 60 07jan2022
302 60 07jan2022
303 60 04feb2022
304 60 27oct2022
301 62 08dec2022
302 62 08dec2022
301 63 03mar2022
301 64 06jan2022
302 64 13jan2022
303 64 04feb2022
304 64 03feb2022
305 64 06feb2022
306 64 04may2022
301 65 30aug2022
301 71 10oct2022
302 71 04nov2022
301 73 04feb2022
302 73 23may2022
303 73 01aug2022
301 74 18feb2022
302 74 31mar2022
303 74 27may2022
304 74 28jul2022
305 74 12oct2022
301 75 04feb2022
302 75 21jul2022
303 75 21jul2022
304 75 21jul2022
301 77 31jan2022
302 77 17mar2022
303 77 03may2022
304 77 31aug2022
305 77 28nov2022
301 78 04feb2022
302 78 04feb2022
303 78 11mar2022
301 80 08jan2022
302 80 08jan2022
303 80 10jan2022
301 81 07jan2022
302 81 04feb2022
303 81 04feb2022
301 82 10jan2022
302 82 15jan2022
303 82 10jan2022
304 82 05feb2022
305 82 05feb2022
301 83 09jan2022
302 83 18jan2022
303 83 06feb2022
301 85 06feb2022
302 85 17feb2022
303 85 03aug2022
304 85 30sep2022
301 89 05feb2022
302 89 07feb2022
303 89 05mar2022
304 89 04mar2022
301 90 06aug2022
302 90 06aug2022
301 92 05feb2022
301 93 09jan2022
302 93 04feb2022
303 93 03feb2022
304 93 17mar2022
305 93 13aug2022
301 98 12jan2022
302 98 10feb2022
303 98 10mar2022
304 98 10mar2022
305 98 25apr2022
306 98 19aug2022
301 101 08jan2022
302 101 08jan2022
303 101 19jan2022
304 101 05feb2022
305 101 05feb2022
301 102 27may2022
301 105 09jan2022
302 105 05feb2022
303 105 12aug2022
301 107 13oct2022
301 108 10aug2022
301 109 07apr2022
302 109 04oct2022
301 110 07may2022
302 110 26sep2022
301 111 08jan2022
302 111 05feb2022
303 111 19feb2022
304 111 08jun2022
305 111 08jun2022
306 111 13jun2022
307 111 19jun2022
308 111 31jul2022
309 111 23sep2022
301 112 19feb2022
302 112 14may2022
303 112 14may2022
304 112 20aug2022
305 112 06sep2022
301 113 05feb2022
302 113 06aug2022
301 114 08jan2022
302 114 08feb2022
303 114 17sep2022
304 114 03nov2022
301 117 20jan2022
302 117 26jan2022
303 117 06feb2022
304 117 30apr2022
305 117 27jun2022
306 117 22feb2022
301 118 05feb2022
302 118 05feb2022
303 118 05feb2022
301 119 06feb2022
301 124 20jan2022
302 124 17oct2022
303 124 08dec2022
301 125 01aug2022
302 125 07sep2022
303 125 07sep2022
301 126 15jan2022
302 126 27jan2022
303 126 10feb2022
304 126 09feb2022
305 126 09feb2022
306 126 12feb2022
307 126 10mar2022
308 126 02jul2022
309 126 01sep2022

[Hemanshu Kumar]

aid teshome Welcome to Statalist!

As your question seems different from the topic of this thread, please start a new discussion thread. Please also review the Statalist FAQ on how to post questions effectively.

I am also not clear what exactly you mean by "to determine if AE fell under vdate3 or vdate14 or etc", so re-phrasing your question more precisely would also be helpful.

[aid teshome]

Thank you...I updated my post....hope it is more clear.

best, Aida