Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Problems with date format
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
RE: st: Problems with date format
Date
Tue, 7 Jun 2011 14:38:39 +0100
Should be mdy(1,1,1993)
Nick
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
Sent: 07 June 2011 12:30
To: [email protected]
Subject: Re: st: Problems with date format
Stata understands 01011993 just as an integer 1011993 or 1,011,993. So
all your daily dates are in practice less than that. I don't know why
you thought Stata would know that you meant a date equivalent, but it
does not read minds in that way.
gem disability92= exit2 < mdy(11, 1, 1993)
should be closer to what you want. Note that the two statements, one
-generate-, the second -replace-, can be reduced to one as above.
Nick
On Tue, Jun 7, 2011 at 12:13 PM, Morten Støver <[email protected]> wrote:
> I'm trying to make dummy-variables for whether people has received
> disability pension up to a certain date. If the respondents have received it
> before 1993, before 1994, etc.
>
> I'm trying with this code, where "exit2" is the date of disability pension:
>
> gen disability92=0
> replacedisability92=1 if exit2<01011993
> gen disability93=0
> replace disability93=1 if exit2<01011994
>
> This code makes all my respondents with disability pension in the follow
> up-period have value 1, instead of only the respondents before the dates
> 01011993, 01011994, etc.
>
> So I guess there have to be a problem with the date format, and when I run
> "codebook exit2" I get:
>
> type: numeric daily date (int)
>
> range: [10958,17623] units: 1
> or equivalently: [01jan1990,01apr2008] units: days
> unique values: 295 missing .: 0/2784
>
> I guess there is a quite simple solution to this, but now I'm just stuck. I
> hope someone can help. I'm running Stata 11.
*
* 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/