Statalist


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

st: importing and converting dates from Excel .csv file


From   Michael McCulloch <mm@pinest.org>
To   Statalist <statalist@hsphsun2.harvard.edu>
Subject   st: importing and converting dates from Excel .csv file
Date   Wed, 27 Aug 2008 13:42:10 -0700

Hello,
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?


-- 

Best wishes,
Michael McCulloch



Pine Street Foundation
124 Pine St., San Anselmo, CA 94960-2674
Tel:	(415) 407-1357
Fax:	(415) 485-1065
mcculloch@pinestreetfoundation.org
www.pinestreetfoundation.org

*
*   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