[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Matching data, Files A &B [Was: Re: st: Picking from a matrix]
On Thu, 28 Nov 2002 09:37:40 -0500 Benoit.Laplante@inrs-ucs.uquebec.ca
> This is not a follow-up to the SAS vs Stata thread, although it may end up
> that way :-)
> I have two files, say File A and File B.
> File A is set for survival analysis with multiple records per individual.
> Among others, it contains three variables: Year, Age and Area. File B
> contains annual aggregated data that describe some higher level
> characteristic that I want to use as a regressor. Each line of B refers to a
> calendar year, each column of B to age (in year) within one area. The value
> of the regressor, for each record, is the element (Year-1, Age in Area) in
> File B. I want to copy the appropriate value from B to the the appropriate
> line of the regressor column in A.
Don't you just need to -merge- File B onto File A using the relevant
year, age, area variables as the keys? And then do the regression.
Or am I missing something?
Professor Stephen P. Jenkins <email@example.com>
Institute for Social and Economic Research (ISER)
University of Essex, Colchester, CO4 3SQ, UK
Tel: +44 (0)1206 873374. Fax: +44 (0)1206 873151.
* For searches and help try: