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
Exporting Tables from StataHello. I am currently writing my thesis and I have finished all my analysis. However, I am now strug…
Test of difference between meansHi, I have data where I have compared the means and from visualising it I can see that one group ha…
ppml cluster - Gravity on product level with only one importerDear all I am evaluating the effect on american imports of the trade war dispute between China and …
Subgroup analysis in stcoxDear Statalisters, In this first post on Statlist I apologize in advance if the format or details a…
Combining Monthly and Yearly DataI am working on inflation time series data. I have Yearly and Monthly data but cannot do tset becaus…
Subscribe to:
Post Comments (Atom)
0 Response to Import CSV dates
Post a Comment