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: converting weekly to monthly data
From
j maleii <[email protected]>
To
<[email protected]>
Subject
RE: st: converting weekly to monthly data
Date
Thu, 28 Jun 2012 18:20:13 +0000
thanks,i am going to have a go at this method, but i dont know yet.
----------------------------------------
> Date: Thu, 28 Jun 2012 20:17:03 +0200
> Subject: Re: st: converting weekly to monthly data
> From: [email protected]
> To: [email protected]
>
> I have a similar question. I want to convert values that represent 4
> weeks averages to montly averages. Is there a way to do that?
>
> thanks
>
> On 6/28/12, tashi lama <[email protected]> wrote:
> > there isn't a machinery to change weekly to monthly directly. However, you
> > could change weekly into daily first and then montly from daily. May be sth
> > like this...
> >
> >
> >
> > gen daily=dofw(tw)
> >
> > format daily %td
> >
> > gen monthly=mofd(td)
> >
> > format monthly %tm
> >
> >
> >
> > Alternatively, you could also do
> >
> >
> >
> > gen monthly=mofd(dofw(tw))
> >
> > format monthly %tm
> >
> >
> >
> > The codes aren't tested. For more on stata data.... help date in command
> > window
> >
> >
> >
> > Hope it helps,
> >
> > Tashi
> >
> > ----------------------------------------
> >> From: [email protected]
> >> To: [email protected]
> >> Subject: st: converting weekly to monthly data
> >> Date: Thu, 28 Jun 2012 17:37:27 +0000
> >>
> >> hii all i got weekly sales data that i need to convert to monthly, but iam
> >> not sure how to do this, as the number of weeks in a month is not exactly
> >> 4
> >> can any one help
> >> my data looks like this
> >>
> >> 2010 week 1 7677
> >> 2010 week 2 5466
> >> 2010 week 3 6776
> >> ..
> >> 2010 week 53 7774
> >>
> >>
> >>
> >> 2011 week 1 4567
> >> ...
> >> 2011 wek 52 4990
> >>
> >> thanks inadvance
> >>
> >> *
> >> * 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/
> >
> *
> * 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/