EViews.com

Posted: **Tue Oct 08, 2024 2:10 pm**

Hi,

I am trying to create a weekly series (with 52 observations) where each week's obs is the median of the same week during the past 20 years.
I can do it in monthly as below:

for !i=1 to 12
series s1{!i}=@recode(@month={!i},s1,na) 'create 12 parallel series dropping all values but a specific month, for all years
next

for !i= 1 to 12
series output=@recode(@month={!i},@median(s1{!i}), output)
next

Is there anything similar (or any other suggestions) for weekly?

Posted: **Tue Oct 08, 2024 3:12 pm**

What frequency is your workfile?

Posted: **Tue Oct 08, 2024 4:33 pm**

I am in a weekly workfile.

Posted: **Tue Oct 08, 2024 4:48 pm**

Code: Select all


'monthly
series output_m = @mediansby(s1, @month)

'weekly
series output_w = @mediansby(s1, @datepart(@date, "ww"))

(in answer to your question, since weeks aren't really defined in any frequency other than weekly, the @datepart(@date, "ww") function represents "@week")

Posted: **Wed Oct 09, 2024 8:21 am**

Never used @mediansby before.
Thank you. Very helpful!

EViews.com

@month but for weekly?

@month but for weekly?

Re: @month but for weekly?

Re: @month but for weekly?

Re: @month but for weekly?

Re: @month but for weekly?