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
Unable to refer to sreturned varlist outside of programI wrote an sclass program which returns two variable lists in separate macros: Code: capture prog…
Loop Through The Same Procedures with Multiple DatasetsHi all, I have several datasets that I would like to do the same procedures to. I have the same gen…
Tempfile invalid file specification[previous code] foreach q in ca cb cc cd ce { preserve gen var = "`q'" tempfile ``q'' save ``q'', r…
Any alternative to svy: bsqreg ? [Since svy does not support bsqreg]I was wondering if there are any alternatives to using svyset since bsqreg does not support svy and …
Recode returns incorrect codeI am try to execute the following code Code: recode educn (1=0)(2/4=1)(5=3)(6=5)(12=15)(10=12)(8=1…
Subscribe to:
Post Comments (Atom)
0 Response to Import CSV dates
Post a Comment