Announcement

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

  • #16
    Now, I'm completely confused. You already have the purchase cost in nominal dollars for the year of purchase in the original data set. That doesn't require any indexing or adjustments at all: it's in the data set as fatb, fatc, and fatp.

    The usual application of price indices that I am accustomed to is to convert from those nominal prices to prices in some reference year (typically the current year or something fairly recent) so that comparisons can be made at constant value. Moreover, that is what I understood you to mean in #1 when you said
    So to basically if the building was bought pre 1975 I would use the CPI index ratio to inflate the real estate value at cost to 1975 and from then I would inflate it by the real estate index.
    That is what the code in #12 does.

    Apparently you are being asked to do something else, and I can't make any sense of itl. I'm sorry I have nothing more to offer here. There are a number of econometricians on the forum, and perhaps one of them will recognize what you are trying to do and can help.

    Comment


    • #17
      Well I guess what is asked here is that CPIt0 measures the CPI index at time of purchase and REIt measures the REI index at time t, based on the fiscal year (fyear). So basically you can measure the RE value at a certain t.

      Comment


      • #18
        Hi Clyde Schechter, I want to convert monthly data to quarterly data. I am using panel data. Previously, I used the following command to get their average value:

        foreach var of varlist x1-x10 {
        egen avg_q_`var' = mean(`var'), by(id tq)
        }


        Now I want to take their multiplied values to convert from monthly to quarterly. For example, for x1

        x1 id tm tq x1_q
        0.25 1 2001m1 2001q1 -0.01
        0.36 1 2001m2 2001q1 -0.01
        -0.16 1 2001m3 2001q1 -0.01
        0.89 1 2001m4 2001q2 0.46
        0.69 1 2001m5 2001q2 0.46
        0.75 1 2001m6 2001q2 0.46
        0.32 2 2001m1 2001q1 -0.13
        0.45 2 2001m2 2001q1 -0.13
        -0.89 2 2001m3 2001q1 -0.13
        0.23 2 2001m4 2001q2 0.05
        0.36 2 2001m5 2001q2 0.05
        0.56 2 2001m6 2001q2 0.05

        How can I revise my above command to get such a result? Please let me know. I really appreciate any help you can provide.

        Comment


        • #19
          #18 is a repetition of https://www.statalist.org/forums/for...iple-variables

          Please don't post the same question in different threads. We know you want an answer, but posting in two or more threads doesn't help you or us and it can lead to wasted duplication.

          Comment

          Working...
          X