[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: generating a variable
I have a pooled cross-sectional data set with thousands of
individual-level observations including a variable that indicates each
individual's state of residence (RES) for the particular year of that
observation. For each of those years I also have a two-variable data
set. One variable, with fifty observations, is a list of the states
(STATE). The other (AGG), with fifty observations, provides aggregate
data for those states. Is there a way to generate a new variable
appropriate to the year, assigns each individual the aggregate datum
based on the individual's residence? That is, is there a way short of
the obvious brute-force method? Thanks.
>>> Use -append- to get the aggregate data into one file.
You can probably do it in a loop over years using -forval-.
Either RES or STATE will need to be renamed.
* For searches and help try: