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 which,
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.
