Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: importing and converting dates from Excel .csv file


From   Phil Schumm <pschumm@uchicago.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: importing and converting dates from Excel .csv file
Date   Wed, 27 Aug 2008 16:32:38 -0500

On Aug 27, 2008, at 3:42 PM, Michael McCulloch wrote:
I have dates in an Excel *.csv file as:

date
12/12/08
12/02/08
04/14/08
04/04/08

I wrote the following code to convert to Stata date:
gen str date_year = substr(date, -2,.)
gen str date_month = substr(date, 1, 2)
gen str date_day = substr(date, 4, 2)
destring date_year date_month date_day, replace
list date date_month date_day date_year

However, when I import the *.csv file, the leading zeroes are dropped from months 1-9. Is there a way to solve this in Stata, without having to create separate columns for m, d, and y in Excel?

I'm not sure I understand correctly, but if all you want to do is to translate the variable into a Stata date, none of this is necessary. For example:

. di %td date("12/2/08","MD19Y")
02dec1908


-- Phil

*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/




© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index