Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: generating a variable


From   Grafstein <[email protected]>
To   [email protected]
Subject   st: generating a variable
Date   Wed, 07 Aug 2002 06:21:39 -0500

Hi,

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.

Bob

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index