Hi all,
I have a problem with converting an integer-type date (format %d) to long-type date (%10.0g), or vice versa. They just need to match such that I can create a new column that identifies when two dates match in two different columns or subtract one date column from the other and see when it is equal to 0.
I need to convert an integer date i.e. 14jan1970 to a date format: 700114
I have tried many different methods; however, the main issue is when converting the integer date to a number-type date, it becomes a 4-digit number. Unsure what to do here.
I also tried the below code and it just gave a new column with missing values:
tostring date, gen(datevar)
gen date2 = date(datevar, "YYMMDD")
format date2 %td
Can someone please advise on how to convert the dates such that I can subtract one from the other and find == 0?
Thank you all for your help!!
Related Posts with Convert Integer Date to Date Format
Problems with the Esttab commandDear Stata community, I have currently an issue with the esttab command. I want to run a loop of re…
Subjects with no failure event not in risk pool, StsetHello- I am using the following commands for my set of patients with multiple records and multiple …
Problems with the Esttab commandDear Stata community, I have currently an issue with the esttab command. I want to run a loop of re…
Query in STATAHi, I have values in my variable (tax_threshold) with many "0" values. I want to replace all the "0…
Interaction Term with dummy and continuous variable!Hello all, I have a silly question regarding interaction term. Would appreciate prompt input :-) T…
Subscribe to:
Post Comments (Atom)
0 Response to Convert Integer Date to Date Format
Post a Comment