Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Converting Monthly data to quaterly data

    Dear all,
    I want to convert my data from monthly to quarterly. I am not sure how to format the data. I know how to create a Quarterly time index but how do I take out the data.

    tb3ms time
    2.19 1953m4
    2.16 1953m5
    2.11 1953m6
    2.04 1953m7
    2.04 1953m8
    1.79 1953m9
    1.38 1953m10
    1.44 1953m11
    1.6 1953m12
    1.18 1954m1
    .97 1954m2
    1.03 1954m3
    .97 1954m4
    .76 1954m5
    .64 1954m6
    .72 1954m7
    .92 1954m8
    1.01 1954m9
    .98 1954m10


    thank you

  • #2
    See

    Code:
    help datetime
    with a hint that qofd(dofm()) is likely to feature in your code.

    Comment


    • #3
      That said, you will (presumably) need to collapse somehow too, e.g. take means of up to 3 monthly values in each quarter.

      Comment


      • #4
        Thank you

        Comment

        Working...
        X