I am completely new to Stata. I have imported a dataset of approximately 50 columns by 500,000 rows. About eight of the columns are dates in the format YMD , eg 2015-05-14. The dataset imports nicely but all of the dates are in red, I assume this means they are strings.
From the manual I have tried
generate eventdate = date(admidate, "YMD")
format eventdate %td
I am not sure if I am on the right track here, - I assumed that I need to convert the string to a date format that Stata understood?. This comment seems to go through but the data remains the same.
When I look at the date it is still red, – and when I look at the variable properties under format it says it is still %10s.
Can anyone get me on the right track please.
Related Posts with Import CSV dates
Marginal effect and confidence interval of the model with an interaction termDear all, I am reading a paper that analyses a panel data model with an interaction term. I wonder …
Why does my logistic regression model fail the Homer and Lemeshow's test?Hello everyone, I apologize in advance if my questions seem incredibly dull. Trying to teach myself …
Exporting results of tabulate to excelHi Statalist, Please consider the following data: Code: * Example generated by -dataex-. To instal…
"Convergence not achieved" - xtlogitHi all, I have a problem when performing an xtlogit regression (I've gone through a couple of threa…
Accounting Research suggestions!Sorry this might be a little bit long post and not related to the forum at all. I do not know. I am …
Subscribe to:
Post Comments (Atom)
0 Response to Import CSV dates
Post a Comment