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
Label variable over multiple linesI want to label multiple variables in my dataset in one command, like below: lab var /// id "ID" //…
XTABOND2 and unit root test and measure of structural breakDear Professors, I am using xtabond2 for my research (System GMM) My questions are the following; 1.…
Is it possible to "export delimited" with variable labels instead of variable names?Dear Statalisters, I'm quite new to Stata and I've run into what seems like a very "basic" problem.…
filling missing data per id from cells below.Dear Stata Community, I am working with long panel data. I have multiple observations per id. In m…
Event Study - Loop for calculating CARsHello everyone. I am trying to do a loop to calculate CARs (Cumulative Abnormal returns) for an Eve…
Subscribe to:
Post Comments (Atom)
0 Response to Import CSV dates
Post a Comment