[Clyde Schechter]

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.

[Mike Trott]

Well I guess what is asked here is that CPI_t0 measures the CPI index at time of purchase and REI_t 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.

[S. M. Woahid Murad]

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.

[Nick Cox]

#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.