Hello dear community!
I am referring to the attached screenshort where you see two columns containing start and end dates with very hetereogeneous formatting. As of now, both columns are stored as strings since "UnKnown" was inserted everytime no date is given. I am now (1) trying to convert these strings to dates and (2) seeking to extract the year from all these dates. Step 2 is fairly straightforward, but I am struggling with the conversion. There are three different formats: e.g. a.) 18.Jul 14; b.) 1995 and c.) Feb 73. Only the last two digits of the years are shown in cases a.) and c.) so that I would need insert "20" whenever the number are [0,19] and a "19" otherwise. I have been experimenting a lot with date() but failed as of now.
Did someone already encounter a similar problem and could provide me with some insight?
Thanks!
Marie
Related Posts with convert strings into date variables with very heterogeneous formats
Estimating the effects of a shockHi all. I am working on a research project to estimate the respective effects of divorce, jobloss a…
Please help: comparing three average treatment effects (ATE) coefficients to determine if they differ significantlyDear colleagues, I am running an average treatment effects analysis (teffects) for the binary outco…
Time Fixed EffectsDear Stata users, For my analysis, I need to use time fixed effects on my panel data (Country-Year)…
Power analysis for conditional logistic regression with variable ratio matchingDoes anyone know how to do a power analysis for conditional logistic regression on matched case-cont…
Reshape wide to long with multiple groups of variablesHi, I am trying to reshape wide to long with a dataset that has multiple groups of variables, forma…
Subscribe to:
Post Comments (Atom)
0 Response to convert strings into date variables with very heterogeneous formats
Post a Comment