Hello,

I have a dataset of firms investments in different states: e.g. Firm A invests $1million in Nevada, which is identified by an unique number (a firm may have multiple investments in different states)
I need to create 0million observations for each neighboring state for each investment.

I have: a unique identifier for the investment, a list of neighboring states (in Excel) for each state

How do I expand my dataset such that for each investment I have the original observation plus n additional rows (one for each of the neighboring states) with the same investment id but with $0 for the added observations and the name of each neighboring state.

I am not sure how to organize my neighboring state data for Stata and how to go about creating such a database.

Any tips will be greatly appreciated!