<>
Actually, I had the same idea as Jeph initially, because Rusell requested
that "... one of the school-level variables (classize) ... have only one
observation per school", but I dismissed it as unlikely. If this is indeed
what Rusell wants, I would be interested to hear what kind of analysis
requires that the variable have only one non-missing value per unit (Schools
in his case).
Furthermore, he could then look at -egen, tag()- which would give him an
indicator variable which he could condition on in subsequent analysis
instead of -drop-ping the remaining cases outright.
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Jeph Herrin
Gesendet: Mittwoch, 16. Dezember 2009 17:04
An: [email protected]
Betreff: Re: st: RE: AW: Creating single values from a nested data file
If I understand correctly,
bys school : replace classize=. if _n>1
hth,
Jeph
Russel Wildeman wrote:
> Thank you Martin
>
> The data look like this
>
> School Student Classize female
> 1 1 35 1
> 1 2 35 0
> 1 3 35 1
> 1 4 35 1
> 2 1 23 0
> 2 2 23 1
> 2 3 23 1
> 3 1 39 0
> 3 2 39 1
>
>
> What I would like is for one of the school-level variables (classize) to
> have only one observation per school. Hope I am a bit clearer.
>
> Many thanks,
> Russell
>
>
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Martin Weiss
> Sent: 16 December 2009 04:03 PM
> To: [email protected]
> Subject: st: AW: Creating single values from a nested data file
>
>
> <>
>
> Could be a case for -reshape- or -collapse-. For further help, you should
> post a meaningful excerpt of your data.
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Marcello
Pagano
> Gesendet: Mittwoch, 16. Dezember 2009 15:04
> An: [email protected]
> Betreff: st: Creating single values from a nested data file
>
> For Russell:
>
> *From:* Russel Wildeman [mailto:[email protected]]
> *Sent:* 15 December 2009 07:36 PM
> *To:* '[email protected]'
> *Subject:* Creating single values from a nested data file
>
> Dear Listers,
>
> I am new to Stata and have the following question.
>
> I have education survey data where the data are ordered by school and
> student and more pertinently the variable ?school.? The data are ordered
> by the variable ?school? and would give 0 0 0 0 1 1 1 1 etc. I have
> created appropriate school-level variables but the problem is that the
> values of the school-level variables are repeated for the same school,
> whereas I want only one record per school for some of the school-level
> variables. I tried various merging file schemes but none work. Any help
> is highly appreciated
>
> Thanks
>
> Russell
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
