Options for Exporting missing values to XLS?
Locked
 
|
I ran this syntax and new variable (var05) is all 0.
I repeated several times and gave same results.
COUNT var05 = ha2 ha4 ha7a(3).
Freq var05. Please help.
regards, Khaing Soe
From: John F Hall <[hidden email]> To: [hidden email] Sent: Wed, April 27, 2011 1:02:08 PM Subject: Re: Question on recoding Just do what I said and you’ll get what you want. You can add labels inside the data editor or use syntax with:
Var labels …. Val lab ….
You can also run a check by:
Crosstabs var01 to var03 by var04 .
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Khaing Soe
Dear Bruce and all,
Thanks and sorry for confusion caused by my first message. What I want to construct is a new variable var04 with 4 response categories, not just counting them. For example, - 1 for all 'yes' to var01 through var03, - 2 for two 'yes' to var01 through var03 - 3 for one 'yes ' to var01 through var03 - 4 for no ‘yes’ at all
Please give some guidance as needed. regards, Khaing Soe
From: John F Hall <[hidden email]> I think you mean “only” rather than “at least”.
From your data editor:
File > new > syntax
Then write:
Count var04 = var01 to var03 (3) . Freq var04 .
. . and press the green triangle.
If you’re new to SPSS, you should look at the tutorials on my site.
John Hall
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Khaing Soe
Dear all,
I have 3 variables as follows; Var01 – yes=1, no=2, don’t know=97 Var02 yes=1, no=2, don’t know=97 Var03 yes=1, no=2, don’t know=97
and, I wish to construct a new variable var04 with - all responses to var01 through var03 are ‘yes’ , - at least two responses to var01 through var03 are ‘yes’ - at least one response to var01 through var03 are ‘yes’ - no ‘yes’ at all
It will be much appreciated if you kindly give me some guidance. regards, Khaing Soe
|
|
It’s not SPSS, it’s you. Are you sure there are any value 3s in ha2 ha4 ha7a ? Did you first run: Freq ha2 ha4 ha7a . Read my tutorials on COMPUTE and COUNT on: http://surveyresearch.weebly.com/block-3-analysing-two-variables-and-sometimes-three.html From: Khaing Soe [mailto:[hidden email]] I ran this syntax and new variable (var05) is all 0. I repeated several times and gave same results. COUNT var05 = ha2 ha4 ha7a(3). Please help. regards, Khaing Soe From: John F Hall <[hidden email]> Just do what I said and you’ll get what you want. You can add labels inside the data editor or use syntax with: Var labels …. Val lab …. You can also run a check by: Crosstabs var01 to var03 by var04 . From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Khaing Soe Dear Bruce and all, Thanks and sorry for confusion caused by my first message. What I want to construct is a new variable var04 with 4 response categories, not just counting them. For example, - 1 for all 'yes' to var01 through var03, - 2 for two 'yes' to var01 through var03 - 3 for one 'yes ' to var01 through var03 - 4 for no ‘yes’ at all Please give some guidance as needed. regards, Khaing Soe From: John F Hall <[hidden email]> I think you mean “only” rather than “at least”. From your data editor: File > new > syntax Then write: Count var04 = var01 to var03 (3) . Freq var04 . . . and press the green triangle. If you’re new to SPSS, you should look at the tutorials on my site. John Hall From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Khaing Soe Dear all, I have 3 variables as follows; Var01 – yes=1, no=2, don’t know=97 Var02 yes=1, no=2, don’t know=97 Var03 yes=1, no=2, don’t know=97 and, I wish to construct a new variable var04 with - all responses to var01 through var03 are ‘yes’ , - at least two responses to var01 through var03 are ‘yes’ - at least one response to var01 through var03 are ‘yes’ - no ‘yes’ at all It will be much appreciated if you kindly give me some guidance. regards, Khaing Soe |
|
|
In reply to this post by Khaing Soe-2
Thank you so much. I've got it. Of course , there is no '3' at all in all three variables.
I changed it into '1' and now it's OK.
Thanks again,
Khaing Soe
From: Khaing Soe <[hidden email]> To: John F Hall <[hidden email]>; [hidden email] Sent: Wed, April 27, 2011 1:50:47 PM Subject: Re: Question on recoding I ran this syntax and new variable (var05) is all 0.
I repeated several times and gave same results.
COUNT var05 = ha2 ha4 ha7a(3).
Freq var05. Please help.
regards, Khaing Soe
From: John F Hall <[hidden email]> To: [hidden email] Sent: Wed, April 27, 2011 1:02:08 PM Subject: Re: Question on recoding Just do what I said and you’ll get what you want. You can add labels inside the data editor or use syntax with:
Var labels …. Val lab ….
You can also run a check by:
Crosstabs var01 to var03 by var04 .
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Khaing Soe
Dear Bruce and all,
Thanks and sorry for confusion caused by my first message. What I want to construct is a new variable var04 with 4 response categories, not just counting them. For example, - 1 for all 'yes' to var01 through var03, - 2 for two 'yes' to var01 through var03 - 3 for one 'yes ' to var01 through var03 - 4 for no ‘yes’ at all
Please give some guidance as needed. regards, Khaing Soe
From: John F Hall <[hidden email]> I think you mean “only” rather than “at least”.
From your data editor:
File > new > syntax
Then write:
Count var04 = var01 to var03 (3) . Freq var04 .
. . and press the green triangle.
If you’re new to SPSS, you should look at the tutorials on my site.
John Hall
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Khaing Soe
Dear all,
I have 3 variables as follows; Var01 – yes=1, no=2, don’t know=97 Var02 yes=1, no=2, don’t know=97 Var03 yes=1, no=2, don’t know=97
and, I wish to construct a new variable var04 with - all responses to var01 through var03 are ‘yes’ , - at least two responses to var01 through var03 are ‘yes’ - at least one response to var01 through var03 are ‘yes’ - no ‘yes’ at all
It will be much appreciated if you kindly give me some guidance. regards, Khaing Soe
|
|
|
In reply to this post by John F Hall
try:
COUNT var05 = ha2 ha4 ha7a (1). Freq var05. On Wed, Apr 27, 2011 at 17:37, John F Hall <[hidden email]> wrote: > It’s not SPSS, it’s you.� Are you sure there are any value 3s in ha2 ha4 > ha7a ?� Did you first run: > > > > Freq ha2 ha4 ha7a . > > > > Read my tutorials on COMPUTE and COUNT on: > > > > http://surveyresearch.weebly.com/block-3-analysing-two-variables-and-sometimes-three.html > > > > From: Khaing Soe [mailto:[hidden email]] > Sent: 27 April 2011 09:21 > To: John F Hall; [hidden email] > > Subject: Re: Question on recoding > > > > I� ran this� syntax and new variable (var05) is all 0. > > I repeated several times and gave same results. > > > > COUNT var05 = ha2 ha4 ha7a(3). > � Freq var05. > > Please help. > > regards, Khaing Soe > > > > ________________________________ > > From: John F Hall <[hidden email]> > To: [hidden email] > Sent: Wed, April 27, 2011 1:02:08 PM > Subject: Re: Question on recoding > > > Just do what I said and you’ll get what you want.� You can add labels inside > the data editor or use syntax with: > > > > Var labels …. > > Val lab …. > > > > You can also run a check by: > > > > Crosstabs var01 to var03 by var04 . > > > > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of > Khaing Soe > Sent: 27 April 2011 04:49 > To: [hidden email] > Subject: Re: Question on recoding > > > > � Dear Bruce and all, > > > > Thanks and sorry for confusion caused by my first message. > > What I want to construct is a new variable var04 with 4 response categories, > not just counting them. > > For example, > > � � � � � � � � � � -� � � � � � � � 1 for all� 'yes' to var01 through var03, > > -� � � � � � � � � 2� � for� two 'yes' to var01 through var03 > > -� � � � � � � � � 3 for one 'yes ' to var01 through var03 > > -� � � � � � � � � 4 for� no ‘yes’ at all > > > > Please give some guidance� as needed. > > regards, Khaing Soe > > > > > > ________________________________ > > From: John F Hall <[hidden email]> > To: Khaing Soe <[hidden email]>; [hidden email] > Sent: Tue, April 26, 2011 4:26:52 PM > Subject: RE: Question on recoding > > I think you mean “only” rather than “at least”. > > > > From your data editor: > > > > File > new > syntax > > > > Then write: > > > > Count var04 = var01 to var03 (3) . > > Freq var04 . > > > > . . and press the green triangle. > > > > If you’re new to SPSS, you should look at the tutorials on my site. > > > > > > John Hall > > [hidden email] > > www.surveyresearch.weebly.com > > > > > > > > > > > > > > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of > Khaing Soe > Sent: 26 April 2011 11:17 > To: [hidden email] > Subject: Question on recoding > > > > Dear all, > > > > I have 3 variables as follows; > > � � � � � � Var01 – yes=1, no=2, don’t know=97 > > � � � � � � Var02� � � yes=1, no=2, don’t know=97 > > � � � � � � Var03� � � yes=1, no=2, don’t know=97 > > > > and, I wish to construct a new variable var04 with > > -� � � � � � � � � all responses to var01 through var03� are ‘yes’ , > > -� � � � � � � � � at least two responses to var01 through var03� are ‘yes’ > > -� � � � � � � � � at least one response to var01 through var03 are� ‘yes’ > > -� � � � � � � � � no ‘yes’ at all > > > > It will be much appreciated if you kindly give me some� guidance. > > regards, Khaing Soe > > > > ________________________________ -- ___________________________________________________________________ Maurice Vergeer Department of communication, Radboud University� (www.ru.nl) PO Box 9104, NL-6500 HE Nijmegen, The Netherlands Visiting Professor Yeungnam University, Gyeongsan, South Korea Recent publications: -Vergeer, M., Hermans, L., & Sams, S. (forthcoming). Online social networks and micro-blogging in political campaigning: The exploration of a new campaign tool and a new campaign style. Party Politics. -Pleijter, A., Hermans, L. & Vergeer, M. (forthcoming). Journalists and journalism in the Netherlands. In D. Weaver & L. Willnat, The Global Journalist in the 21st Century. London: Routledge. -Eisinga, R., Franses, Ph.H., & Vergeer, M. (2010). Weather conditions and daily television use in the Netherlands, 1996–2005. International Journal of Meteorology. Webspace www.mauricevergeer.nl http://blog.mauricevergeer.nl/ www.journalisteninhetdigitaletijdperk.nl maurice.vergeer (skype) ___________________________________________________________________ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
GLM in Complex Samples
|
|
In reply to this post by Khaing Soe-2
Hello to everybody on the list: I have a cluster sample (schools are the clusters) that is stratified using two dicotomous variables: area (urban / rural) and fundings (public / private) I've use this two variables in the complex sample plan becasue I wan't to estime the population mean for a measure of Principal Eficaccy (as percived by the teachers). I also wan't to know if there are diferences in this mean measures considering the area and fundings. So I try to use the GLM module in complex samples, but when I try to put area or funding in the Factors area I get a message: "Plan variables cannot be used in the model." I don't know much abou this module, but I can´t understand why would be incorrect to run this comparitions. I think that a solution could be to create a new straum variable with four values (urban-public / urban-rural / rural-public / rural-private) and a new plan file, Then run the GLM model (in complex samples) using the area and fundings variables. Does it makes sense or I'm missing something that makes imposible to do the analysis I need? Kindly Andrés Mg. Andrés Burga León Coordinador de Análisis e Informática Unidad de Medición de la Calidad Educativa Ministerio de Educación del Perú Calle El Comercio s/n (espalda del Museo de la Nación) Lima 41 Perú Teléfono 615-5840 |
|
|
In reply to this post by Ryan
There is not in MIXED. Note that the category encoding has no effect** on the overall model fit or the tests of model effects, only the parameter estimates. In the case of a main effects fixed effect with two categories, the signs are simply reversed. I wouldn't bother recoding it. Actually, even for a field with more than two categories, I wouldn't bother recoding it and would use EMMEANS to test for differences. Alex ** so long as there aren't numerical problems
Not that I'm aware. Maybe someone else knows of a way to specify a reference category. Ryan On Tue, Apr 26, 2011 at 7:20 PM, Parise, Carol A. <[hidden email]> wrote: > Hi all, > > I am just learning to use linear mixed-effects modeling. While I have many > questions about this procedure and have been slowly working through > tutorials, i have a simple question regarding reference categories. One of > the fixed effects in some sample data i created is coded 0=control > 1=treatement. The estimates of fixed effects table automatically uses the > highest numeric category as the refcat. While I can recode this, is there a > way to tell MIXED which category to use as the refcat? They sytax menu > doesn't appear to show a way to do this except in the EMMEANS > subcommand. Have i missed this? I'm using version 14.0. > > Thanks > Carol > > |
| Free forum by Nabble | Edit this page |