Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: how to create pair-wise within the same data

From   Jianan Li <[email protected]>
To   "[email protected]" <[email protected]>
Subject   st: how to create pair-wise within the same data
Date   Tue, 13 Mar 2012 11:43:48 +0000


Now I have one panel time series data about grain price and weather data: 40 cities and 80 years.

I want to run this regression: P(i,t) – P(j,t) = B1*(w(i,t) – w(j,t)) + B2 *(Distance (i,j)) + e  (1)

i and j are two cities so that (i,j) is one pair-wise. P is price and W is weather. Distance(i,j) is the distance between i and j.

Question (1): how to construct the panel data from my original panel time series data for regression (1)?
Question (2): how to merge the distance variable into the new constructed panel data. I have the distance for each pair-wise.

Best wishes

Jianan Li

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment
may still contain software viruses which could damage your computer system:
you are advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index