RE: st: RE: AW: Creating single values from a nested data file

["Russel Wildeman" <rwildeman@idasa.org.za>]

Thank you Jeph-your code has done the trick-thanks to Martin and Nick
also-the help much appreciated. Best, Russell

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Jeph Herrin
Sent: 16 December 2009 06:04 PM
To: statalist@hsphsun2.harvard.edu
Subject: 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: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Martin Weiss
> Sent: 16 December 2009 04:03 PM
> To: statalist@hsphsun2.harvard.edu
> 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: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Marcello
Pagano
> Gesendet: Mittwoch, 16. Dezember 2009 15:04
> An: statalist@hsphsun2.harvard.edu
> Betreff: st: Creating single values from a nested data file
> 
> For Russell:
> 
> *From:* Russel Wildeman [mailto:rwildeman@idasa.org.za]
> *Sent:* 15 December 2009 07:36 PM
> *To:* 'statalist@hsphsun2.harvard.edu'
> *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/