I am not clear whether your numbering of
grant types is by size, by time, arbitrary
or what. But in any event you need a -reshape-
of your second dataset from long to wide.
-collapse- in particular will not do what you
want.
Nick
[email protected]
Jennifer Delaney
> 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?
*
* 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/