Re: st: FW: Help with filling in dates in a dataset

["Martin Weiss" <martin.weiss1@gmx.de>]

<>


Hmm, running the code I posted, I get exactly

 +------------------+
 |    Month   Value |
 |------------------|
 |  January       0 |
 | February       . |
 |    March       4 |
 |    April       2 |
 |      May       . |
 |------------------|
 |     June       3 |


which coincides with what you originally requested...

There is no way a -replace- "...ends up deleting month altogether". It 
merely substitutes one value for another. It all makes me wonder what is 
going on in your computer... Anything special about it that the list should 
know?


HTH
Martin
_______________________
----- Original Message ----- 
From: "Ariel Linden, DrPH" <ariel.linden@gmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Saturday, April 04, 2009 6:06 PM
Subject: RE: st: FW: Help with filling in dates in a dataset


> Hi Martin,
>
> Not all of your code seems to work:
>
> This section of code works:
> --------------------------------------
> gen newmonths=.
> tokenize `c(Months)'
> forvalues i = 1/12 {
> replace newmonths=  `i' if Month== "``i''"
> }
>
> *Resulting in:
>
> Month Value newmonths
> January 0 1
> March 4 3
> April 2 4
> June 3 6
> ------------------------------------
> This section of tsfills, but the newmonths starts at month 2 instead of
> month 1:
> --------------------------------------------------------
> tsset newmonths, monthly
> tsfill
>
> *Resulting in:
>
> Month Value newmonths
> January 0 1960m2
> 1960m3
> March 4 1960m4
> April 2 1960m5
> 1960m6
> June 3 1960m7
> --------------------------------------------------------
>
> This section of code ends up deleting month altogether:
>
> forvalues i = 1/12 {
> replace Month= "``i''" if newmonths== `i'
> }
>
> *Results:
> Month Value newmonths
> 0 1960m2
> 1960m3
> 4 1960m4
> 2 1960m5
> 1960m6
> 3 1960m7
> ---------------------------------------------------------------
> Then, of course dropping newmonths takes away all measurement of time:
>
> drop newmonths
>
> *resulting in
> Month Value
> 0
>
> 4
> 2
>
> 3
>
> Thanks!
>
> Ariel
>
> *
> *   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/