Your second data set needs to be in "wide" format. See if -reshape-
(specifically, -reshape wide-) will do what you want.
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of
> Jennifer Delaney
> Sent: Tuesday, January 31, 2006 4:08 PM
> To: [email protected]
> 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
> [email protected]
> *
> * 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/
