Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: database manipulation


From   Eric Booth <ebooth@ppri.tamu.edu>
To   "<statalist@hsphsun2.harvard.edu>" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: database manipulation
Date   Thu, 7 Oct 2010 21:03:43 +0000

<>


*************!

**input some fake data**
clear
inp str12(date site)
"12/3/1979" "Dallas, TX"
"1/1/1975" "Houston,TX"
end

**dates**
g date2 = date(date, "MDY")
format date2 %td
help dates_and_times

**sep city and state**
split site, p(",")
help split

**use trim() function to get rid of extra spaces**
replace site1 = trim(site1)
replace site2 = trim(site2)
help f_trim

**************!

- Eric

__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754




On Oct 7, 2010, at 3:40 PM, Michael Eisenberg wrote:

> Colleagues,
> 
> I have what I hope are a few simple questions regarding a fragmented
> database I'm trying to manipulate in stata.
> 
> 1. Is there a way to convert the following date format (1/1/1975) into
> a date form that stata will recognize?
> 
> 2.  Is it possible to separate a single string field separated by
> commas into 2 separate fields (i.e. Dallas, TX into Dallas in one
> field and TX in another)?  What about if a space was between the two
> fields (i.e. Dallas TX into two fields - one with Dallas and the other
> with TX)?
> 
> Thank you in advance.
> 
> Mike
> *
> *   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/




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