Calculation within Panel Data

[egill35]

I have a panel data set of metro level real estate returns including the US. I'd like to difference each metro vs. the US to get an alpha for 3yr returns. The issue I have is that the US data is part of the panel stack of data that is imported. Is there a way in eviews for me to isolate the US data in order to do this calculation?

[EViews Gareth]

smpl if country="US"

?

[egill35]

not sure why I did not see this but let me try it to see if it works.

[egill35]

I guess I am having difficulties with the code.

smpl if country="us"
genr tret_alpha=tret-tret


it runs the calculation but returns a 0 for each period. I need it to understand that the second tret in the equation should be "us" because the "US" data is imbedded in the panel.

[startz]

I guess I am having difficulties with the code.

smpl if country="us"
genr tret_alpha=tret-tret


it runs the calculation but returns a 0 for each period. I need it to understand that the second tret in the equation should be "us" because the "US" data is imbedded in the panel.

Code: Select all

series tret_us = 0 smpl if country="us" tret_us = tret smpl @all genr tret_alpha=tret-tret_us

[egill35]

I think this is closer. However, what I am trying to do is isolate the US country returns so that I can difference each metro by the US return. the code provided is creating a series for just the US. I want the US series to be a data point for each country. I want this series below for tret_us to not be 0s but instead be the US return. Does that make sense?

ATL - 78Q1 0
ATL - 78Q2 0
ATL - 78Q3 0
ATL - 78Q4 0
ATL - 79Q1 0
ATL - 79Q2 0
ATL - 79Q3 0
ATL - 79Q4 0
ATL - 80Q1 0
ATL - 80Q2 0
ATL - 80Q3 0
ATL - 80Q4 0
ATL - 81Q1 0
ATL - 81Q2 0
ATL - 81Q3 0
ATL - 81Q4 0
ATL - 82Q1 0
ATL - 82Q2 0
ATL - 82Q3 0
ATL - 82Q4 0
ATL - 83Q1 0
ATL - 83Q2 0
ATL - 83Q3 0
ATL - 83Q4 0
ATL - 84Q1 0
ATL - 84Q2 0
ATL - 84Q3 0
ATL - 84Q4 0
ATL - 85Q1 0
ATL - 85Q2 0
ATL - 85Q3 0
ATL - 85Q4 0
ATL - 86Q1 0
ATL - 86Q2 0
ATL - 86Q3 0
ATL - 86Q4 0
ATL - 87Q1 0
ATL - 87Q2 0
ATL - 87Q3 0
ATL - 87Q4 0
ATL - 88Q1 0
ATL - 88Q2 0
ATL - 88Q3 0
ATL - 88Q4 0
ATL - 89Q1 0
ATL - 89Q2 0
ATL - 89Q3 0
ATL - 89Q4 0
ATL - 90Q1 0
ATL - 90Q2 0
ATL - 90Q3 0
ATL - 90Q4 0
ATL - 91Q1 0
ATL - 91Q2 0
ATL - 91Q3 0
ATL - 91Q4 0
ATL - 92Q1 0
ATL - 92Q2 0
ATL - 92Q3 0
ATL - 92Q4 0
ATL - 93Q1 0
ATL - 93Q2 0
ATL - 93Q3 0
ATL - 93Q4 0
ATL - 94Q1 0
ATL - 94Q2 0
ATL - 94Q3 0
ATL - 94Q4 0
ATL - 95Q1 0
ATL - 95Q2 0
ATL - 95Q3 0
ATL - 95Q4 0
ATL - 96Q1 0
ATL - 96Q2 0
ATL - 96Q3 0
ATL - 96Q4 0
ATL - 97Q1 0
ATL - 97Q2 0
ATL - 97Q3 0
ATL - 97Q4 0
ATL - 98Q1 0
ATL - 98Q2 0
ATL - 98Q3 0
ATL - 98Q4 0
ATL - 99Q1 0
ATL - 99Q2 0
ATL - 99Q3 0
ATL - 99Q4 0
ATL - 00Q1 0
ATL - 00Q2 0
ATL - 00Q3 0
ATL - 00Q4 0
ATL - 01Q1 0
ATL - 01Q2 0
ATL - 01Q3 0
ATL - 01Q4 0
ATL - 02Q1 0
ATL - 02Q2 0
ATL - 02Q3 0
ATL - 02Q4 0
ATL - 03Q1 0
ATL - 03Q2 0
ATL - 03Q3 0
ATL - 03Q4 0
ATL - 04Q1 0
ATL - 04Q2 0
ATL - 04Q3 0
ATL - 04Q4 0
ATL - 05Q1 0
ATL - 05Q2 0
ATL - 05Q3 0
ATL - 05Q4 0
ATL - 06Q1 0
ATL - 06Q2 0
ATL - 06Q3 0
ATL - 06Q4 0
ATL - 07Q1 0
ATL - 07Q2 0
ATL - 07Q3 0
ATL - 07Q4 0
ATL - 08Q1 0
ATL - 08Q2 0
ATL - 08Q3 0
ATL - 08Q4 0
ATL - 09Q1 0
ATL - 09Q2 0
ATL - 09Q3 0
ATL - 09Q4 0
ATL - 10Q1 0
ATL - 10Q2 0
ATL - 10Q3 0
ATL - 10Q4 0
ATL - 11Q1 0
ATL - 11Q2 0
ATL - 11Q3 0
ATL - 11Q4 0
ATL - 12Q1 0
ATL - 12Q2 0
ATL - 12Q3 0
ATL - 12Q4 0
ATL - 13Q1 0
ATL - 13Q2 0
ATL - 13Q3 0
ATL - 13Q4 0
ATL - 14Q1 0
ATL - 14Q2 0
ATL - 78Q1 0
ATL - 78Q2 0
ATL - 78Q3 0
ATL - 78Q4 0
ATL - 79Q1 0
ATL - 79Q2 0
ATL - 79Q3 0
ATL - 79Q4 0
ATL - 80Q1 0
ATL - 80Q2 0
ATL - 80Q3 0
ATL - 80Q4 0
ATL - 81Q1 0
ATL - 81Q2 0
ATL - 81Q3 0
ATL - 81Q4 0
ATL - 82Q1 0
ATL - 82Q2 0
ATL - 82Q3 0
ATL - 82Q4 0
ATL - 83Q1 0
ATL - 83Q2 0
ATL - 83Q3 0
ATL - 83Q4 0
ATL - 84Q1 0
ATL - 84Q2 0
ATL - 84Q3 0
ATL - 84Q4 0
ATL - 85Q1 0
ATL - 85Q2 0
ATL - 85Q3 0
ATL - 85Q4 0
ATL - 86Q1 0
ATL - 86Q2 0
ATL - 86Q3 0
ATL - 86Q4 0
ATL - 87Q1 0
ATL - 87Q2 0
ATL - 87Q3 0
ATL - 87Q4 0
ATL - 88Q1 0
ATL - 88Q2 0
ATL - 88Q3 0
ATL - 88Q4 0
ATL - 89Q1 0
ATL - 89Q2 0
ATL - 89Q3 0
ATL - 89Q4 0
ATL - 90Q1 0
ATL - 90Q2 0
ATL - 90Q3 0
ATL - 90Q4 0
ATL - 91Q1 0
ATL - 91Q2 0
ATL - 91Q3 0
ATL - 91Q4 0
ATL - 92Q1 0
ATL - 92Q2 0
ATL - 92Q3 0
ATL - 92Q4 0
ATL - 93Q1 0
ATL - 93Q2 0
ATL - 93Q3 0
ATL - 93Q4 0
ATL - 94Q1 0
ATL - 94Q2 0
ATL - 94Q3 0
ATL - 94Q4 0
ATL - 95Q1 0
ATL - 95Q2 0
ATL - 95Q3 0
ATL - 95Q4 0
ATL - 96Q1 0
ATL - 96Q2 0
ATL - 96Q3 0
ATL - 96Q4 0
ATL - 97Q1 0
ATL - 97Q2 0
ATL - 97Q3 0
ATL - 97Q4 0
ATL - 98Q1 0
ATL - 98Q2 0
ATL - 98Q3 0
ATL - 98Q4 0
ATL - 99Q1 0
ATL - 99Q2 0
ATL - 99Q3 0
ATL - 99Q4 0
ATL - 00Q1 0
ATL - 00Q2 0
ATL - 00Q3 0
ATL - 00Q4 0
ATL - 01Q1 0
ATL - 01Q2 0
ATL - 01Q3 0
ATL - 01Q4 0
ATL - 02Q1 0
ATL - 02Q2 0
ATL - 02Q3 0
ATL - 02Q4 0
ATL - 03Q1 0
ATL - 03Q2 0
ATL - 03Q3 0
ATL - 03Q4 0
ATL - 04Q1 0
ATL - 04Q2 0
ATL - 04Q3 0
ATL - 04Q4 0
ATL - 05Q1 0
ATL - 05Q2 0
ATL - 05Q3 0
ATL - 05Q4 0
ATL - 06Q1 0
ATL - 06Q2 0
ATL - 06Q3 0
ATL - 06Q4 0
ATL - 07Q1 0
ATL - 07Q2 0
ATL - 07Q3 0
ATL - 07Q4 0
ATL - 08Q1 0
ATL - 08Q2 0
ATL - 08Q3 0
ATL - 08Q4 0
ATL - 09Q1 0
ATL - 09Q2 0
ATL - 09Q3 0
ATL - 09Q4 0
ATL - 10Q1 0
ATL - 10Q2 0
ATL - 10Q3 0
ATL - 10Q4 0
ATL - 11Q1 0
ATL - 11Q2 0
ATL - 11Q3 0
ATL - 11Q4 0
ATL - 12Q1 0
ATL - 12Q2 0
ATL - 12Q3 0
ATL - 12Q4 0
ATL - 13Q1 0
ATL - 13Q2 0
ATL - 13Q3 0
ATL - 13Q4 0
ATL - 14Q1 0
ATL - 14Q2 0

[startz]

Ah, so do you want to create a series that is the average of all the return observations for a particular time period?

[egill35]

Hi there,

My panel stack includes ATL and US. What I want to do is isolate the US so that I can do an alpha analysis that would end up being tret(ATL)-tret(US). Does that make sense?

[EViews Gareth]

You might be better off in a pool workfile rather than a panel.

[egill35]

I could if I could unstack the data in Eviews and then restack it.

[EViews Gareth]

You can. Proc->Reshape->Unstack