Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: AW: RE: AW: Creating single values from a nested data file
Date   Wed, 16 Dec 2009 16:49:14 +0100

<> 

For the case of missings in the first observation, you may even want to use
-firstnm- when -collapse-ing:



*************
clear*

inp byte(School Student Classize female) 
1	1		.	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
end

collapse (firstnm) Classize, by(School)

li, noo sepby(School)
*************



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Martin Weiss
Gesendet: Mittwoch, 16. Dezember 2009 16:45
An: statalist@hsphsun2.harvard.edu
Betreff: st: AW: RE: AW: Creating single values from a nested data file


<> 

Looks like a case for -collapse- to me:

*************
clear*

inp byte(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
end

collapse (first) Classize, by(School)

list, noo sepby(School)
*************



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Russel Wildeman
Gesendet: Mittwoch, 16. Dezember 2009 16:43
An: statalist@hsphsun2.harvard.edu
Betreff: st: RE: AW: Creating single values from a nested data file

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index