Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: merging data unique identification problem


From   "Elizabeth Allred" <lizard@hsph.harvard.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: RE: merging data unique identification problem
Date   Tue, 31 Jan 2006 16:20:42 -0500

Your second data set needs to be in "wide" format. See if -reshape-
(specifically,  -reshape wide-) will do what you want.

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu 
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of 
> Jennifer Delaney
> Sent: Tuesday, January 31, 2006 4:08 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: merging data unique identification problem
> 
> 
> I have two datasets that I am trying to merge.  One dataset 
> (A) is uniquely identified by three variables (ID YEAR 
> SEMESTER).  The other dataset is uniquely identified by four 
> variables (ID YEAR SEMESTER GRANTTPYE).  In the second 
> dataset (B) students can get more than one GRANTTYPE in a 
> given semester so it is important to keep this factor.
> 
> What I've been trying to do is to collapse the second dataset 
> (B) so that it is identified by only three variables then I 
> can merge it with dataset A.
> 
> I think it's clearest if I can illustrate with a simple example...
> 
> Current form of dataset B:
> 
> ID  YEAR  SEMESTER  GRANTTYPE AWARDAMT
> 1   1990   Fall         1        500
> 1   1990   Fall         0        200
> 
> 
> Form that I am attempting to convert dataset B into:
> 
> ID  YEAR  SEMESTER  GRANTTYPE1awardamt  GRANTTYPE2awardamt
> 1   1990   Fall          500                200
> 
> 
> The only form that I have been able to achieve so far:
> ID  YEAR  SEMESTER  GRANTTYPE1awardamt  GRANTTYPE2awardamt
> 1   1990   Fall          500                .
> 1   1990   Fall          .                  200
> 
> 
> How do I "squish" the data so that I end up with one entry 
> per kid per year per term?
> 
> Thanks,
> 
> Jennifer
> 
> -- 
> Jennifer Delaney
> PhD candidate in Higher Education
> Stanford University
> delaneyj@stanford.edu
> *
> *   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/
> 


*
*   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–2021 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index