counting frequencies of 30 columns of children who are a certain age range AND going to school.
Locked
counting frequencies of 30 columns of children who are a certain age range AND going to school.
 
|
Dear all, I sent an email on needing to count how many children there are in 30 columns that are between the ages of 3 to 18 AND are going to school. Thanks for your response. I picked the following and it seemed to work. This is what I went with. IT worked for 3to18 and going to school, but then I adapted it to age range 7to15 AND going to school, but for some reason it is only picking up the part on those that are going to school, so if someone is NOT 7to15 years old, but are going to school, it is counting that. Any insight on why? Also how would you shorten this syntax? FILTER OFF. USE ALL. EXECUTE. If ((b5_age$01 > 6 | b5_age$01 < 16) & (B8_CURATSCH$01 = 1)) v1 = 1. If ((b5_age$02 > 6 | b5_age$02 <16) & (B8_CURATSCH$02 = 1)) v2 = 1. If ((b5_age$03 > 6 | b5_age$03 < 16) & (B8_CURATSCH$03 = 1)) v3 = 1. If ((b5_age$04 > 6 | b5_age$04 < 16) & (B8_CURATSCH$04 = 1)) v4 = 1. If ((b5_age$05 > 6 | b5_age$05 < 16) & (B8_CURATSCH$05 = 1)) v5 = 1. If ((b5_age$06 > 6 | b5_age$06 < 16) & (B8_CURATSCH$06 = 1)) v6 = 1. If ((b5_age$07 > 6 | b5_age$07 < 16) & (B8_CURATSCH$07 = 1)) v7 = 1. If ((b5_age$08 > 6 | b5_age$08 < 16) & (B8_CURATSCH$08 = 1)) v8 = 1. If ((b5_age$09 > 6 | b5_age$09 < 16) & (B8_CURATSCH$09 = 1)) v9 = 1. If ((b5_age$10 > 6 | b5_age$10 < 16) & (B8_CURATSCH$10 = 1)) v10 = 1. If ((b5_age$11 > 6 | b5_age$11 < 16) & (B8_CURATSCH$11 = 1)) v11 = 1. If ((b5_age$12 > 6 | b5_age$12 < 16) & (B8_CURATSCH$12 = 1)) v12 = 1. If ((b5_age$13 > 6 | b5_age$13 < 16) & (B8_CURATSCH$13= 1)) v13 = 1. If ((b5_age$14> 6 | b5_age$14 < 16) & (B8_CURATSCH$14= 1)) v14 = 1. If ((b5_age$15 > 6 | b5_age$15 < 16) & (B8_CURATSCH$15= 1)) v15 = 1. If ((b5_age$16 > 6 | b5_age$16 < 16) & (B8_CURATSCH$16= 1)) v16 = 1. If ((b5_age$17 > 6 | b5_age$17 < 16) & (B8_CURATSCH$17= 1)) v17 = 1. If ((b5_age$18> 6 | b5_age$18 < 16) & (B8_CURATSCH$18= 1)) v18 = 1. If ((b5_age$19> 6 | b5_age$19 < 16) & (B8_CURATSCH$19= 1)) v19 = 1. If ((b5_age$20 > 6 | b5_age$20 < 16) & (B8_CURATSCH$20= 1)) v20 = 1. If ((b5_age$21 > 6 | b5_age$21 < 16) & (B8_CURATSCH$21= 1)) v21 = 1. If ((b5_age$22 > 6 | b5_age$22 < 16) & (B8_CURATSCH$22= 1)) v22= 1. If ((b5_age$23> 6 | b5_age$23 < 16) & (B8_CURATSCH$23= 1)) v23 = 1. If ((b5_age$24> 6 | b5_age$24 < 16) & (B8_CURATSCH$24= 1)) v24 = 1. If ((b5_age$25> 6 | b5_age$25 < 16) & (B8_CURATSCH$25= 1)) v25= 1. If ((b5_age$26> 6 | b5_age$26 < 16) & (B8_CURATSCH$26= 1)) v26 = 1. If ((b5_age$27> 6 | b5_age$27 < 16) & (B8_CURATSCH$27= 1)) v27 = 1. If ((b5_age$28> 6 | b5_age$28 < 16) & (B8_CURATSCH$28= 1)) v28 = 1. If ((b5_age$29> 6 | b5_age$29 < 16) & (B8_CURATSCH$29= 1)) v29 = 1. If ((b5_age$30> 6 | b5_age$30 < 16) & (B8_CURATSCH$30= 1)) v30 = 1. COUNT age7to15andschoolfrequency = v1 to v30 (1). EXECUTE. FREQUENCIES VARIABLES=age7to15andschoolfrequency /ORDER=ANALYSIS. |
Re: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
|
Deepa
- In your first set of If statements with the age condition, you use
'|' which is read as 'or'. But you want to use
'&' ('and').
Peter
Link
VA San
Diego Healthcare System
|
Re: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
In reply to this post by Deepa Lakshmi Shanadi
Deepa,
IF is a very expensive way to do this, as SPSS
makes a pass through the data for each IF. Do you really need v1 to
v30?
you can do:
count age3to18 = b5_age$01 to b5_age$30 (3 thru
18)
/age6to15 = b5_age$01 to
b5_age$30 (7 thru 15)
/atschool = B8_CURATSCH$01 to
B8_CURATSCH$30 (1) .
freq age3to18 to atschool .
If you need the columns paired (untested) something
like:
do repeat
x = b5_age$01 to b5_age$30
/y = b5_age$01 to b5_age$30
/z = B8_CURATSCH$01 to
B8_CURATSCH$30
/a = v1 to v30
/b = w1 to w30 .
if ((x ge3 and le 18) and (z eq 1)) a = 1
.
if ((y ge 7 and le 15) and (z eq 1)) b =
1 .
end repeat .
count atschool3to18 = v1 to v30 (1)
/atschool7to15 = w1 to w30 (1) .
freq atschool3to18 atschool7to15 .
|
Re: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
|
Dear John, No, I don't need the v1 to v30. I already have enough variables in the dataset. I am trying this and I think I am confusing everyone. Sorry. I just need ages 7 to 15 and going to school. Not the 3 to 18 anymore. But the If statements worked with to 3 to 15. I adapted your syntax to this, but I am not getting the correct frequency because I had computed whether in the 30 columns, someone is age 7 to 15 and if there is noone, it is still giving me a frequency for that row. Make senese?: count age7to15andschoolfrequency = b5_age$01 to b5_age$30 (7 thru 15) /atschool = B8_CURATSCH$01 to B8_CURATSCH$30 (1) . freq age7to15andschoolfrequency to atschool . From: John F Hall <[hidden email]> To: Deepa Lakshmi Shanadi <[hidden email]>; [hidden email] Sent: Tue, September 21, 2010 1:34:49 PM Subject: Re: counting frequencies of 30 columns of children who are a certain age range AND going to school. Deepa,
IF is a very expensive way to do this, as SPSS
makes a pass through the data for each IF. Do you really need v1 to
v30?
you can do:
count age3to18 = b5_age$01 to b5_age$30 (3 thru
18)
/age6to15 = b5_age$01 to
b5_age$30 (7 thru 15)
/atschool = B8_CURATSCH$01 to
B8_CURATSCH$30 (1) .
freq age3to18 to atschool .
If you need the columns paired (untested) something
like:
do repeat
x = b5_age$01 to b5_age$30
/y = b5_age$01 to b5_age$30
/z = B8_CURATSCH$01 to
B8_CURATSCH$30
/a = v1 to v30
/b = w1 to w30 .
if ((x ge3 and le 18) and (z eq 1)) a = 1
.
if ((y ge 7 and le 15) and (z eq 1)) b =
1 .
end repeat .
count atschool3to18 = v1 to v30 (1)
/atschool7to15 = w1 to w30 (1) .
freq atschool3to18 atschool7to15 .
|
Re: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
In reply to this post by Deepa Lakshmi Shanadi
If not please copy the output from the second LIST command that you get and paste it twice in an email. edit the second copy so that it shows the results you are looking for. If it did, just change the arguments in the range function to range(b5,7,15) if range(b5,3,18) kids = kids +1.if range(b5,7,15) kids = kids +1. if range(b5,7,15) and b8 eq 1 kidsinschool = kidsinschool + 1. Art Kendall Social Research Consultants On 9/21/2010 11:54 AM, Deepa Lakshmi Shanadi wrote: ===================== 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
Art Kendall
Social Research Consultants |
Re: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
|
In reply to this post by John F Hall
Jon Peck SPSS, an IBM Company [hidden email] 312-651-3435
Deepa, IF is a very expensive way to do this, as SPSS makes a pass through the data for each IF. Do you really need v1 to v30? >>>No, SPSS will evaluate all of the IF statements on the same pass with either set of code (but do discard that EXECUTE statement). While the code could be more compact as suggested, the efficiency will not be affected -Jon Peck you can do: count age3to18 = b5_age$01 to b5_age$30 (3 thru 18) /age6to15 = b5_age$01 to b5_age$30 (7 thru 15) /atschool = B8_CURATSCH$01 to B8_CURATSCH$30 (1) . freq age3to18 to atschool . If you need the columns paired (untested) something like: do repeat x = b5_age$01 to b5_age$30 /y = b5_age$01 to b5_age$30 /z = B8_CURATSCH$01 to B8_CURATSCH$30 /a = v1 to v30 /b = w1 to w30 . if ((x ge3 and le 18) and (z eq 1)) a = 1 . if ((y ge 7 and le 15) and (z eq 1)) b = 1 . end repeat . count atschool3to18 = v1 to v30 (1) /atschool7to15 = w1 to w30 (1) . freq atschool3to18 atschool7to15 . John Hall johnfhall@... http://surveyresearch.weebly.com ----- Original Message ----- From: Deepa Lakshmi Shanadi To: [hidden email] Sent: Tuesday, September 21, 2010 5:54 PM Subject: counting frequencies of 30 columns of children who are a certain age range AND going to school. Dear all, I sent an email on needing to count how many children there are in 30 columns that are between the ages of 3 to 18 AND are going to school. Thanks for your response. I picked the following and it seemed to work. This is what I went with. IT worked for 3to18 and going to school, but then I adapted it to age range 7to15 AND going to school, but for some reason it is only picking up the part on those that are going to school, so if someone is NOT 7to15 years old, but are going to school, it is counting that. Any insight on why? Also how would you shorten this syntax? FILTER OFF. USE ALL. EXECUTE. If ((b5_age$01 > 6 | b5_age$01 < 16) & (B8_CURATSCH$01 = 1)) v1 = 1. If ((b5_age$02 > 6 | b5_age$02 <16) & (B8_CURATSCH$02 = 1)) v2 = 1. If ((b5_age$03 > 6 | b5_age$03 < 16) & (B8_CURATSCH$03 = 1)) v3 = 1. If ((b5_age$04 > 6 | b5_age$04 < 16) & (B8_CURATSCH$04 = 1)) v4 = 1. If ((b5_age$05 > 6 | b5_age$05 < 16) & (B8_CURATSCH$05 = 1)) v5 = 1. If ((b5_age$06 > 6 | b5_age$06 < 16) & (B8_CURATSCH$06 = 1)) v6 = 1. If ((b5_age$07 > 6 | b5_age$07 < 16) & (B8_CURATSCH$07 = 1)) v7 = 1. If ((b5_age$08 > 6 | b5_age$08 < 16) & (B8_CURATSCH$08 = 1)) v8 = 1. If ((b5_age$09 > 6 | b5_age$09 < 16) & (B8_CURATSCH$09 = 1)) v9 = 1. If ((b5_age$10 > 6 | b5_age$10 < 16) & (B8_CURATSCH$10 = 1)) v10 = 1. If ((b5_age$11 > 6 | b5_age$11 < 16) & (B8_CURATSCH$11 = 1)) v11 = 1. If ((b5_age$12 > 6 | b5_age$12 < 16) & (B8_CURATSCH$12 = 1)) v12 = 1. If ((b5_age$13 > 6 | b5_age$13 < 16) & (B8_CURATSCH$13= 1)) v13 = 1. If ((b5_age$14> 6 | b5_age$14 < 16) & (B8_CURATSCH$14= 1)) v14 = 1. If ((b5_age$15 > 6 | b5_age$15 < 16) & (B8_CURATSCH$15= 1)) v15 = 1. If ((b5_age$16 > 6 | b5_age$16 < 16) & (B8_CURATSCH$16= 1)) v16 = 1. If ((b5_age$17 > 6 | b5_age$17 < 16) & (B8_CURATSCH$17= 1)) v17 = 1. If ((b5_age$18> 6 | b5_age$18 < 16) & (B8_CURATSCH$18= 1)) v18 = 1. If ((b5_age$19> 6 | b5_age$19 < 16) & (B8_CURATSCH$19= 1)) v19 = 1. If ((b5_age$20 > 6 | b5_age$20 < 16) & (B8_CURATSCH$20= 1)) v20 = 1. If ((b5_age$21 > 6 | b5_age$21 < 16) & (B8_CURATSCH$21= 1)) v21 = 1. If ((b5_age$22 > 6 | b5_age$22 < 16) & (B8_CURATSCH$22= 1)) v22= 1. If ((b5_age$23> 6 | b5_age$23 < 16) & (B8_CURATSCH$23= 1)) v23 = 1. If ((b5_age$24> 6 | b5_age$24 < 16) & (B8_CURATSCH$24= 1)) v24 = 1. If ((b5_age$25> 6 | b5_age$25 < 16) & (B8_CURATSCH$25= 1)) v25= 1. If ((b5_age$26> 6 | b5_age$26 < 16) & (B8_CURATSCH$26= 1)) v26 = 1. If ((b5_age$27> 6 | b5_age$27 < 16) & (B8_CURATSCH$27= 1)) v27 = 1. If ((b5_age$28> 6 | b5_age$28 < 16) & (B8_CURATSCH$28= 1)) v28 = 1. If ((b5_age$29> 6 | b5_age$29 < 16) & (B8_CURATSCH$29= 1)) v29 = 1. If ((b5_age$30> 6 | b5_age$30 < 16) & (B8_CURATSCH$30= 1)) v30 = 1. COUNT age7to15andschoolfrequency = v1 to v30 (1). EXECUTE. FREQUENCIES VARIABLES=age7to15andschoolfrequency /ORDER=ANALYSIS. |
Fw: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
|
In reply to this post by John F Hall
Why am I getting this silly error message for the following syntax??? >Error # 4285 in column 2. Text: B5_ >Incorrect variable name: either the name is more than 64 characters, or it is >not defined by a previous command. >This command not executed. EXECUTE. WOULD THIS WORK to calculate those that are aged 7to15 and going to school in my 30 columns from 2 sets of varibles? Sorry, I am having a hard time following
the shortened syntax. Would this work?COMPUTE age7to15andschool = ((B5_AGE$01>6 and B5_AGE$01 < 16) and (B8_CURATSCH$01 = 1)) or (B5_AGE$02>6 and B5_AGE$02 <16 and B8_CURATSCH$02 = 1 ) or (B5_AGE$03>6 and B5_AGE$03 <16 and B8_CURATSCH$03 = 1) or (B5_AGE$04>6 and B5_AGE$04 <16 and B8_CURATSCH$04 = 1 ) or (B5_AGE$05>6 and B5_AGE$05 <16 and B8_CURATSCH$05 = 1) or (B5_AGE$06>6 and B5_AGE$06 <16 and B8_CURATSCH$06 = 1) or (B5_AGE$07>6 and B5_AGE$07 <16 and B8_CURATSCH$07 = 1) or (B5_AGE$08>6 and B5_AGE$08 <16 and B8_CURATSCH$08 = 1) or (B5_AGE$09>6 and B5_AGE$09 <16 and B8_CURATSCH$09 = 1) or (B5_AGE$10>6 and B5_AGE$10<16 and B8_CURATSCH$10 = 1) or (B5_ AGE$11>6 and B5_AGE$11 <16 and B8_CURATSCH$11 = 1) or (B5_AGE$12>6 and B5_AGE$12 <16 and B8_CURATSCH$12 = 1) or (B5_AGE$13>6 and B5_AGE$13 <16 and B8_CURATSCH$13 = 1) or (B5_AGE$14>6 and B5_AGE$14<16 and B8_CURATSCH$14 = 1) or (B5_AGE$15>6 and B5_AGE$15 <16 and B8_CURATSCH$15 = 1) or (B5_AGE$16>6 and B5_AGE$16 <16 and B8_CURATSCH$16 = 1) or (B5_AGE$17>6 and B5_AGE$17 <16 and B8_CURATSCH$17 = 1) or (B5_AGE$18>6 and B5_AGE$18 <16 B8_CURATSCH$18 = 1) or (B5_AGE$19>6 and B5_AGE$19 <16 and B8_CURATSCH$19=1) or (B5_AGE$20>6 and B5_AGE$20<16 and B8_CURATSCH$20 = 1) or (B5_AGE$21>6 and B5_AGE$21<16 and B8_CURATSCH$21 = 1) or (B5_AGE$22>6 and B5_AGE$22<16 and B8_CURATSCH$22 = 1) or (B5_AGE$23>6 and B5_AGE$23<16 and B8_CURATSCH$23 = 1) or (B5_AGE$24<6 and B5_AGE$24<16 and B8_CURATSCH$24 = 1) or (B5_AGE$25>6 and B5_AGE$25<16 and B8_CURATSCH$25 = 1) or (B5_AGE$26>6 and B5_AGE$26<16 and B8_CURATSCH$26 = 1) or (B5_AGE$27>2 and B5_AGE$27<16 and B8_CURATSCH$27 = 1) or (B5_AGE$28>6 and B5_AGE$28<16 and B8_CURATSCH$28 = 1) or (B5_AGE$29>6 and B5_AGE$29<16 and B8_CURATSCH$29=1) or (B5_AGE$30>6 and B5_AGE$30<16 and B8_CURATSCH$30 = 1). EXECUTE. But I get this message: >Error # 4285 in column 2. Text: B5_ >Incorrect variable name: either the name is more than 64 characters, or it is >not defined by a previous command. >This command not executed. EXECUTE. From: John F Hall <[hidden email]> To: Deepa Lakshmi Shanadi <[hidden email]>; [hidden email] Sent: Tue, September 21, 2010 1:34:49 PM Subject: Re: counting frequencies of 30 columns of children who are a certain age range AND going to school. Deepa,
IF is a very expensive way to do this, as SPSS
makes a pass through the data for each IF. Do you really need v1 to
v30?
you can do:
count age3to18 = b5_age$01 to b5_age$30 (3 thru
18)
/age6to15 = b5_age$01 to
b5_age$30 (7 thru 15)
/atschool = B8_CURATSCH$01 to
B8_CURATSCH$30 (1) .
freq age3to18 to atschool .
If you need the columns paired (untested) something
like:
do repeat
x = b5_age$01 to b5_age$30
/y = b5_age$01 to b5_age$30
/z = B8_CURATSCH$01 to
B8_CURATSCH$30
/a = v1 to v30
/b = w1 to w30 .
if ((x ge3 and le 18) and (z eq 1)) a = 1
.
if ((y ge 7 and le 15) and (z eq 1)) b =
1 .
end repeat .
count atschool3to18 = v1 to v30 (1)
/atschool7to15 = w1 to w30 (1) .
freq atschool3to18 atschool7to15 .
|
Re: Fw: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
|
The error message is correct. You have this line in your syntax (B5_ AGE$11>6 and B5_AGE$11 <16 and B8_CURATSCH$11 = 1) or ----------- Jon Peck SPSS, an IBM Company [hidden email] 312-651-3435
Why am I getting this silly error message for the following syntax??? >Error # 4285 in column 2. Text: B5_ >Incorrect variable name: either the name is more than 64 characters, or it is >not defined by a previous command. >This command not executed. EXECUTE. WOULD THIS WORK to calculate those that are aged 7to15 and going to school in my 30 columns from 2 sets of varibles? Sorry, I am having a hard time following the shortened syntax. COMPUTE age7to15andschool = ((B5_AGE$01>6 and B5_AGE$01 < 16) and (B8_CURATSCH$01 = 1)) or (B5_AGE$02>6 and B5_AGE$02 <16 and B8_CURATSCH$02 = 1 ) or (B5_AGE$03>6 and B5_AGE$03 <16 and B8_CURATSCH$03 = 1) or (B5_AGE$04>6 and B5_AGE$04 <16 and B8_CURATSCH$04 = 1 ) or (B5_AGE$05>6 and B5_AGE$05 <16 and B8_CURATSCH$05 = 1) or (B5_AGE$06>6 and B5_AGE$06 <16 and B8_CURATSCH$06 = 1) or (B5_AGE$07>6 and B5_AGE$07 <16 and B8_CURATSCH$07 = 1) or (B5_AGE$08>6 and B5_AGE$08 <16 and B8_CURATSCH$08 = 1) or (B5_AGE$09>6 and B5_AGE$09 <16 and B8_CURATSCH$09 = 1) or (B5_AGE$10>6 and B5_AGE$10<16 and B8_CURATSCH$10 = 1) or (B5_ AGE$11>6 and B5_AGE$11 <16 and B8_CURATSCH$11 = 1) or (B5_AGE$12>6 and B5_AGE$12 <16 and B8_CURATSCH$12 = 1) or (B5_AGE$13>6 and B5_AGE$13 <16 and B8_CURATSCH$13 = 1) or (B5_AGE$14>6 and B5_AGE$14<16 and B8_CURATSCH$14 = 1) or (B5_AGE$15>6 and B5_AGE$15 <16 and B8_CURATSCH$15 = 1) or (B5_AGE$16>6 and B5_AGE$16 <16 and B8_CURATSCH$16 = 1) or (B5_AGE$17>6 and B5_AGE$17 <16 and B8_CURATSCH$17 = 1) or (B5_AGE$18>6 and B5_AGE$18 <16 B8_CURATSCH$18 = 1) or (B5_AGE$19>6 and B5_AGE$19 <16 and B8_CURATSCH$19=1) or (B5_AGE$20>6 and B5_AGE$20<16 and B8_CURATSCH$20 = 1) or (B5_AGE$21>6 and B5_AGE$21<16 and B8_CURATSCH$21 = 1) or (B5_AGE$22>6 and B5_AGE$22<16 and B8_CURATSCH$22 = 1) or (B5_AGE$23>6 and B5_AGE$23<16 and B8_CURATSCH$23 = 1) or (B5_AGE$24<6 and B5_AGE$24<16 and B8_CURATSCH$24 = 1) or (B5_AGE$25>6 and B5_AGE$25<16 and B8_CURATSCH$25 = 1) or (B5_AGE$26>6 and B5_AGE$26<16 and B8_CURATSCH$26 = 1) or (B5_AGE$27>2 and B5_AGE$27<16 and B8_CURATSCH$27 = 1) or (B5_AGE$28>6 and B5_AGE$28<16 and B8_CURATSCH$28 = 1) or (B5_AGE$29>6 and B5_AGE$29<16 and B8_CURATSCH$29=1) or (B5_AGE$30>6 and B5_AGE$30<16 and B8_CURATSCH$30 = 1). EXECUTE. But I get this message: >Error # 4285 in column 2. Text: B5_ >Incorrect variable name: either the name is more than 64 characters, or it is >not defined by a previous command. >This command not executed. EXECUTE. From: John F Hall <[hidden email]> To: Deepa Lakshmi Shanadi <[hidden email]>; [hidden email] Sent: Tue, September 21, 2010 1:34:49 PM Subject: Re: counting frequencies of 30 columns of children who are a certain age range AND going to school. Deepa, IF is a very expensive way to do this, as SPSS makes a pass through the data for each IF. Do you really need v1 to v30? you can do: count age3to18 = b5_age$01 to b5_age$30 (3 thru 18) /age6to15 = b5_age$01 to b5_age$30 (7 thru 15) /atschool = B8_CURATSCH$01 to B8_CURATSCH$30 (1) . freq age3to18 to atschool . If you need the columns paired (untested) something like: do repeat x = b5_age$01 to b5_age$30 /y = b5_age$01 to b5_age$30 /z = B8_CURATSCH$01 to B8_CURATSCH$30 /a = v1 to v30 /b = w1 to w30 . if ((x ge3 and le 18) and (z eq 1)) a = 1 . if ((y ge 7 and le 15) and (z eq 1)) b = 1 . end repeat . count atschool3to18 = v1 to v30 (1) /atschool7to15 = w1 to w30 (1) . freq atschool3to18 atschool7to15 . John Hall johnfhall@... http://surveyresearch.weebly.com ----- Original Message ----- From: Deepa Lakshmi Shanadi To: [hidden email] Sent: Tuesday, September 21, 2010 5:54 PM Subject: counting frequencies of 30 columns of children who are a certain age range AND going to school. Dear all, I sent an email on needing to count how many children there are in 30 columns that are between the ages of 3 to 18 AND are going to school. Thanks for your response. I picked the following and it seemed to work. This is what I went with. IT worked for 3to18 and going to school, but then I adapted it to age range 7to15 AND going to school, but for some reason it is only picking up the part on those that are going to school, so if someone is NOT 7to15 years old, but are going to school, it is counting that. Any insight on why? Also how would you shorten this syntax? FILTER OFF. USE ALL. EXECUTE. If ((b5_age$01 > 6 | b5_age$01 < 16) & (B8_CURATSCH$01 = 1)) v1 = 1. If ((b5_age$02 > 6 | b5_age$02 <16) & (B8_CURATSCH$02 = 1)) v2 = 1. If ((b5_age$03 > 6 | b5_age$03 < 16) & (B8_CURATSCH$03 = 1)) v3 = 1. If ((b5_age$04 > 6 | b5_age$04 < 16) & (B8_CURATSCH$04 = 1)) v4 = 1. If ((b5_age$05 > 6 | b5_age$05 < 16) & (B8_CURATSCH$05 = 1)) v5 = 1. If ((b5_age$06 > 6 | b5_age$06 < 16) & (B8_CURATSCH$06 = 1)) v6 = 1. If ((b5_age$07 > 6 | b5_age$07 < 16) & (B8_CURATSCH$07 = 1)) v7 = 1. If ((b5_age$08 > 6 | b5_age$08 < 16) & (B8_CURATSCH$08 = 1)) v8 = 1. If ((b5_age$09 > 6 | b5_age$09 < 16) & (B8_CURATSCH$09 = 1)) v9 = 1. If ((b5_age$10 > 6 | b5_age$10 < 16) & (B8_CURATSCH$10 = 1)) v10 = 1. If ((b5_age$11 > 6 | b5_age$11 < 16) & (B8_CURATSCH$11 = 1)) v11 = 1. If ((b5_age$12 > 6 | b5_age$12 < 16) & (B8_CURATSCH$12 = 1)) v12 = 1. If ((b5_age$13 > 6 | b5_age$13 < 16) & (B8_CURATSCH$13= 1)) v13 = 1. If ((b5_age$14> 6 | b5_age$14 < 16) & (B8_CURATSCH$14= 1)) v14 = 1. If ((b5_age$15 > 6 | b5_age$15 < 16) & (B8_CURATSCH$15= 1)) v15 = 1. If ((b5_age$16 > 6 | b5_age$16 < 16) & (B8_CURATSCH$16= 1)) v16 = 1. If ((b5_age$17 > 6 | b5_age$17 < 16) & (B8_CURATSCH$17= 1)) v17 = 1. If ((b5_age$18> 6 | b5_age$18 < 16) & (B8_CURATSCH$18= 1)) v18 = 1. If ((b5_age$19> 6 | b5_age$19 < 16) & (B8_CURATSCH$19= 1)) v19 = 1. If ((b5_age$20 > 6 | b5_age$20 < 16) & (B8_CURATSCH$20= 1)) v20 = 1. If ((b5_age$21 > 6 | b5_age$21 < 16) & (B8_CURATSCH$21= 1)) v21 = 1. If ((b5_age$22 > 6 | b5_age$22 < 16) & (B8_CURATSCH$22= 1)) v22= 1. If ((b5_age$23> 6 | b5_age$23 < 16) & (B8_CURATSCH$23= 1)) v23 = 1. If ((b5_age$24> 6 | b5_age$24 < 16) & (B8_CURATSCH$24= 1)) v24 = 1. If ((b5_age$25> 6 | b5_age$25 < 16) & (B8_CURATSCH$25= 1)) v25= 1. If ((b5_age$26> 6 | b5_age$26 < 16) & (B8_CURATSCH$26= 1)) v26 = 1. If ((b5_age$27> 6 | b5_age$27 < 16) & (B8_CURATSCH$27= 1)) v27 = 1. If ((b5_age$28> 6 | b5_age$28 < 16) & (B8_CURATSCH$28= 1)) v28 = 1. If ((b5_age$29> 6 | b5_age$29 < 16) & (B8_CURATSCH$29= 1)) v29 = 1. If ((b5_age$30> 6 | b5_age$30 < 16) & (B8_CURATSCH$30= 1)) v30 = 1. COUNT age7to15andschoolfrequency = v1 to v30 (1). EXECUTE. FREQUENCIES VARIABLES=age7to15andschoolfrequency /ORDER=ANALYSIS. Would this work? |
Re: Fw: counting frequencies of 30 columns of children who are a certain age range AND going to school.
Administrator
|
In reply to this post by Deepa Lakshmi Shanadi
Searching for "B5_ " in your syntax took me to this row: (B5_ AGE$11>6 and B5_AGE$11 <16 and B8_CURATSCH$11 = 1) or You have a space between B5_ and AGE$11. I'm not sure which shortened syntax you were having trouble with, but isn't something like the following a lot easier? * This assumes the Age variables appear in one block, * and the School variables in another block. * If they do not, you'll either have to sort the variables * to make that happen, or list each variable on the DO-REPEAT. * It also assumes there is no missing data. compute #count = 0. do repeat age = b5_age$01 to b5_age$30 / sch = B8_CURATSCH$01 to B8_CURATSCH$30 . - if range(age,7,15) and (sch EQ 1) #count = #count + 1. end repeat. COMPUTE age7to15andschoolfrequency = #count. FREQUENCIES age7to15andschoolfrequency.
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
Re: Fw: counting frequencies of 30 columns of children who are a certain age range AND going to school.
|
|
In reply to this post by Deepa Lakshmi Shanadi
Deepa
-
B5_Age$11 has a space after the underscore and before
Age, in your syntax below. This causes the error.
Peter
Link
VA San
Diego Healthcare System
|
Re: counting frequencies of 30 columns
|
In reply to this post by Deepa Lakshmi Shanadi
I'm repeating some of what has been said, but it looks like the problem's
got a little entangled with the multitude of questions and suggested
solutions.
At 11:54 AM 9/21/2010, Deepa Lakshmi Shanadi wrote: I sent an email on needing to count how many children there are in 30 columns that are between the ages of 3 to 18 AND are going to school. This is what I went with. IT worked for 3to18 and going to school, but then I adapted it to age range 7to15 AND going to school, but for some reason it is only picking up the part on those that are going to school, so if someone is NOT 7to15 years old, but are going to school, it is counting that. Any insight on why?[etc.] As Peter Link <[hidden email]> wrote, In your first set of If statements with the age condition, you use '|' which is read as 'or'. But you want to use '&' ('and'). That is, "(b5_age$01 > 6 | b5_age$01 < 16)" is always true -- if the age isn't greater than 6, it's less than 16, (it may be both); the correct expression is, indeed, "(b5_age$01 > 6 & b5_age$01 < 16)" But as Art Kendall (and perhaps others) wrote, the RANGE function is clearer: If (RANGE(b5_age$01,7,15) AND (B8_CURATSCH$01 EQ 1)) v1 = 1. (I've also followed Art Kendall's good advice, to write "AND" instead of "&" and "EQ" instead of "=".) Also how would you shorten this syntax? If you don't want to unroll the data (the solution I posted yesterday), this is exactly the case for a DO REPEAT (untested): DO REPEAT Age= B5_AGE$01 B5_AGE$02 B5_AGE$03 B5_AGE$04 B5_AGE$05 B5_AGE$06 B5_AGE$07 B5_AGE$08 B5_AGE$09 B5_AGE$10 B5_AGE$11 B5_AGE$12 B5_AGE$13 B5_AGE$14 B5_AGE$15 B5_AGE$16 B5_AGE$17 B5_AGE$18 B5_AGE$19 B5_AGE$20 B5_AGE$21 B5_AGE$22 B5_AGE$23 B5_AGE$24 B5_AGE$25 B5_AGE$26 B5_AGE$27 B5_AGE$28 B5_AGE$29 B5_AGE$30 /In_School=B8_CURATSCH$01 B8_CURATSCH$02 B8_CURATSCH$03 B8_CURATSCH$04 B8_CURATSCH$05 B8_CURATSCH$06 B8_CURATSCH$07 B8_CURATSCH$08 B8_CURATSCH$09 B8_CURATSCH$10 B8_CURATSCH$11 B8_CURATSCH$12 B8_CURATSCH$13 B8_CURATSCH$14 B8_CURATSCH$15 B8_CURATSCH$16 B8_CURATSCH$17 B8_CURATSCH$18 B8_CURATSCH$19 B8_CURATSCH$20 B8_CURATSCH$21 B8_CURATSCH$22 B8_CURATSCH$23 B8_CURATSCH$24 B8_CURATSCH$25 B8_CURATSCH$26 B8_CURATSCH$27 B8_CURATSCH$28 B8_CURATSCH$29 B8_CURATSCH$30 /BothTests=v1 TO v30. . If (RANGE(Age,7,15) AND (B8_CURATSCH$01 EQ 1)) BothTests = 1. END REPEAT. COUNT age7to15andschoolfrequency = v1 to v30 (1). *[Don't use EXECUTE]. FREQUENCIES VARIABLES=age7to15andschoolfrequency /ORDER=ANALYSIS. Depending on the order of variables in your file, you may also be able to simply further, DO REPEAT Age= B5_AGE$01 TO B5_AGE$30 /In_School=B8_CURATSCH$01 TO B8_CURATSCH$30 /BothTests=v1 TO v30. (etc.) At 01:54 PM 9/21/2010, Deepa Lakshmi Shanadi added: No, I don't need the v1 to v30. Then make them scratch variables, by starting their names with "#" -- "#v1" instead of "v1", etc. Still untested: DO REPEAT Age= B5_AGE$01 B5_AGE$02 B5_AGE$03 B5_AGE$04 B5_AGE$05 B5_AGE$06 B5_AGE$07 B5_AGE$08 B5_AGE$09 B5_AGE$10 B5_AGE$11 B5_AGE$12 B5_AGE$13 B5_AGE$14 B5_AGE$15 B5_AGE$16 B5_AGE$17 B5_AGE$18 B5_AGE$19 B5_AGE$20 B5_AGE$21 B5_AGE$22 B5_AGE$23 B5_AGE$24 B5_AGE$25 B5_AGE$26 B5_AGE$27 B5_AGE$28 B5_AGE$29 B5_AGE$30 /In_School=B8_CURATSCH$01 B8_CURATSCH$02 B8_CURATSCH$03 B8_CURATSCH$04 B8_CURATSCH$05 B8_CURATSCH$06 B8_CURATSCH$07 B8_CURATSCH$08 B8_CURATSCH$09 B8_CURATSCH$10 B8_CURATSCH$11 B8_CURATSCH$12 B8_CURATSCH$13 B8_CURATSCH$14 B8_CURATSCH$15 B8_CURATSCH$16 B8_CURATSCH$17 B8_CURATSCH$18 B8_CURATSCH$19 B8_CURATSCH$20 B8_CURATSCH$21 B8_CURATSCH$22 B8_CURATSCH$23 B8_CURATSCH$24 B8_CURATSCH$25 B8_CURATSCH$26 B8_CURATSCH$27 B8_CURATSCH$28 B8_CURATSCH$29 B8_CURATSCH$30 /BothTests=#v1 TO #v30. . If (RANGE(Age,7,15) AND (B8_CURATSCH$01 EQ 1)) BothTests = 1. END REPEAT. COUNT age7to15andschoolfrequency = #v1 to #v30 (1). ===================== 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 |
Re: counting frequencies of 30 columns
|
|
Dear Richard, Ive made your edits and this is my new syntax. The reason I know I'm not getting the right output is I've done a count of all children aged7to15 and sometimes my number here (age7to15 and going to school) is greater than the number of children that are aged 7to15. If ((b5_age$01 > 6 and b5_age$01 < 16) and (B8_CURATSCH$01 EQ 1)) v1 = 1. If ((b5_age$02 > 6 and b5_age$02 <16) and (B8_CURATSCH$02 EQ 1)) v2 = 1. If ((b5_age$03 > 6 and b5_age$03 < 16) and (B8_CURATSCH$03 EQ 1)) v3 = 1. If ((b5_age$04 > 6 and b5_age$04 < 16) and (B8_CURATSCH$04 EQ 1)) v4 = 1. If ((b5_age$05 > 6 and b5_age$05 < 16) and (B8_CURATSCH$05 EQ 1)) v5 = 1. If ((b5_age$06 > 6 and b5_age$06 < 16) and (B8_CURATSCH$06 EQ 1)) v6 = 1. If ((b5_age$07 > 6 and b5_age$07 < 16) and (B8_CURATSCH$07 EQ 1)) v7 = 1. If ((b5_age$08 > 6 and b5_age$08 < 16) and (B8_CURATSCH$08 EQ 1)) v8 = 1. If ((b5_age$09 > 6 and b5_age$09 < 16) and (B8_CURATSCH$09 EQ 1)) v9 = 1. If ((b5_age$10 > 6 and b5_age$10 < 16) and (B8_CURATSCH$10 EQ 1)) v10 = 1. If ((b5_age$11 > 6 and b5_age$11 < 16) and (B8_CURATSCH$11 EQ 1)) v11 = 1. If ((b5_age$12 > 6 and b5_age$12 < 16) and (B8_CURATSCH$12 EQ 1)) v12 = 1. If ((b5_age$13 > 6 and b5_age$13 < 16) and (B8_CURATSCH$13 EQ 1)) v13 = 1. If ((b5_age$14> 6 and b5_age$14 < 16) and (B8_CURATSCH$14 EQ 1)) v14 = 1. If ((b5_age$15 > 6 and b5_age$15 < 16) and (B8_CURATSCH$15 EQ 1)) v15 = 1. If ((b5_age$16 > 6 and b5_age$16 < 16) and (B8_CURATSCH$16 EQ 1)) v16 = 1. If ((b5_age$17 > 6 and b5_age$17 < 16) and (B8_CURATSCH$17 EQ 1)) v17 = 1. If ((b5_age$18> 6 and b5_age$18 < 16) and (B8_CURATSCH$18 EQ 1)) v18 = 1. If ((b5_age$19> 6 and b5_age$19 < 16) and (B8_CURATSCH$19 EQ 1)) v19 = 1. If ((b5_age$20 > 6 and b5_age$20 < 16) and (B8_CURATSCH$20 EQ 1)) v20 = 1. If ((b5_age$21 > 6 and b5_age$21 < 16) and (B8_CURATSCH$21 EQ 1)) v21 = 1. If ((b5_age$22 > 6 and b5_age$22 < 16) and (B8_CURATSCH$22 EQ 1)) v22= 1. If ((b5_age$23> 6 and b5_age$23 < 16) and (B8_CURATSCH$23 EQ 1)) v23 = 1. If ((b5_age$24> 6 and b5_age$24 < 16) and (B8_CURATSCH$24 EQ 1)) v24 = 1. If ((b5_age$25> 6 and b5_age$25 < 16) and (B8_CURATSCH$25 EQ 1)) v25= 1. If ((b5_age$26> 6 and b5_age$26 < 16) and (B8_CURATSCH$26 EQ 1)) v26 = 1. If ((b5_age$27> 6 and b5_age$27 < 16) and (B8_CURATSCH$27 EQ 1)) v27 = 1. If ((b5_age$28> 6 and b5_age$28 < 16) and (B8_CURATSCH$28 EQ 1)) v28 = 1. If ((b5_age$29> 6 and b5_age$29 < 16) and (B8_CURATSCH$29 EQ 1)) v29 = 1. If ((b5_age$30> 6 and b5_age$30 < 16) and (B8_CURATSCH$30 EQ 1)) v30 = 1. COUNT age7to15andschoolfrequency = v1 to v30 (1). EXECUTE. FREQUENCIES VARIABLES=age7to15andschoolfrequency /ORDER=ANALYSIS. From: Richard Ristow <[hidden email]> To: Deepa Lakshmi Shanadi <[hidden email]>; [hidden email] Cc: Peter Link <[hidden email]>; Art Kendall <[hidden email]> Sent: Tue, September 21, 2010 3:38:48 PM Subject: Re: counting frequencies of 30 columns I'm repeating some of what has been said, but it looks like the problem's got a little entangled with the multitude of questions and suggested solutions. At 11:54 AM 9/21/2010, Deepa Lakshmi Shanadi wrote: I sent an email on needing to count how many children there are in 30 columns that are between the ages of 3 to 18 AND are going to school. This is what I went with. IT worked for 3to18 and going to school, but then I adapted it to age range 7to15 AND going to school, but for some reason it is only picking up the part on those that are going to school, so if someone is NOT 7to15 years old, but are going to school, it is counting that. Any insight on why?[etc.] As Peter Link <[hidden email]> wrote, In your first set of If statements with the age condition, you use '|' which is read as 'or'. But you want to use '&' ('and'). That is, "(b5_age$01 > 6 | b5_age$01 < 16)" is always true -- if the age isn't greater than 6, it's less than 16, (it may be both); the correct expression is, indeed, "(b5_age$01 > 6 & b5_age$01 < 16)" But as Art Kendall (and perhaps others) wrote, the RANGE function is clearer: If (RANGE(b5_age$01,7,15) AND (B8_CURATSCH$01 EQ 1)) v1 = 1. (I've also followed Art Kendall's good advice, to write "AND" instead of "&" and "EQ" instead of "=".) Also how would you shorten this syntax? If you don't want to unroll the data (the solution I posted yesterday), this is exactly the case for a DO REPEAT (untested): DO REPEAT Age= B5_AGE$01 B5_AGE$02 B5_AGE$03 B5_AGE$04 B5_AGE$05 B5_AGE$06 B5_AGE$07 B5_AGE$08 B5_AGE$09 B5_AGE$10 B5_AGE$11 B5_AGE$12 B5_AGE$13 B5_AGE$14 B5_AGE$15 B5_AGE$16 B5_AGE$17 B5_AGE$18 B5_AGE$19 B5_AGE$20 B5_AGE$21 B5_AGE$22 B5_AGE$23 B5_AGE$24 B5_AGE$25 B5_AGE$26 B5_AGE$27 B5_AGE$28 B5_AGE$29 B5_AGE$30 /In_School=B8_CURATSCH$01 B8_CURATSCH$02 B8_CURATSCH$03 B8_CURATSCH$04 B8_CURATSCH$05 B8_CURATSCH$06 B8_CURATSCH$07 B8_CURATSCH$08 B8_CURATSCH$09 B8_CURATSCH$10 B8_CURATSCH$11 B8_CURATSCH$12 B8_CURATSCH$13 B8_CURATSCH$14 B8_CURATSCH$15 B8_CURATSCH$16 B8_CURATSCH$17 B8_CURATSCH$18 B8_CURATSCH$19 B8_CURATSCH$20 B8_CURATSCH$21 B8_CURATSCH$22 B8_CURATSCH$23 B8_CURATSCH$24 B8_CURATSCH$25 B8_CURATSCH$26 B8_CURATSCH$27 B8_CURATSCH$28 B8_CURATSCH$29 B8_CURATSCH$30 /BothTests=v1 TO v30. . If (RANGE(Age,7,15) AND (B8_CURATSCH$01 EQ 1)) BothTests = 1. END REPEAT. COUNT age7to15andschoolfrequency = v1 to v30 (1). *[Don't use EXECUTE]. FREQUENCIES VARIABLES=age7to15andschoolfrequency /ORDER=ANALYSIS. Depending on the order of variables in your file, you may also be able to simply further, DO REPEAT Age= B5_AGE$01 TO B5_AGE$30 /In_School=B8_CURATSCH$01 TO B8_CURATSCH$30 /BothTests=v1 TO v30. (etc.) At 01:54 PM 9/21/2010, Deepa Lakshmi Shanadi added: No, I don't need the v1 to v30. Then make them scratch variables, by starting their names with "#" -- "#v1" instead of "v1", etc. Still untested: DO REPEAT Age= B5_AGE$01 B5_AGE$02 B5_AGE$03 B5_AGE$04 B5_AGE$05 B5_AGE$06 B5_AGE$07 B5_AGE$08 B5_AGE$09 B5_AGE$10 B5_AGE$11 B5_AGE$12 B5_AGE$13 B5_AGE$14 B5_AGE$15 B5_AGE$16 B5_AGE$17 B5_AGE$18 B5_AGE$19 B5_AGE$20 B5_AGE$21 B5_AGE$22 B5_AGE$23 B5_AGE$24 B5_AGE$25 B5_AGE$26 B5_AGE$27 B5_AGE$28 B5_AGE$29 B5_AGE$30 /In_School=B8_CURATSCH$01 B8_CURATSCH$02 B8_CURATSCH$03 B8_CURATSCH$04 B8_CURATSCH$05 B8_CURATSCH$06 B8_CURATSCH$07 B8_CURATSCH$08 B8_CURATSCH$09 B8_CURATSCH$10 B8_CURATSCH$11 B8_CURATSCH$12 B8_CURATSCH$13 B8_CURATSCH$14 B8_CURATSCH$15 B8_CURATSCH$16 B8_CURATSCH$17 B8_CURATSCH$18 B8_CURATSCH$19 B8_CURATSCH$20 B8_CURATSCH$21 B8_CURATSCH$22 B8_CURATSCH$23 B8_CURATSCH$24 B8_CURATSCH$25 B8_CURATSCH$26 B8_CURATSCH$27 B8_CURATSCH$28 B8_CURATSCH$29 B8_CURATSCH$30 /BothTests=#v1 TO #v30. . If (RANGE(Age,7,15) AND (B8_CURATSCH$01 EQ 1)) BothTests = 1. END REPEAT. COUNT age7to15andschoolfrequency = #v1 to #v30 (1). |
Re: counting frequencies of 30 columns
|
|
At 04:31 PM 9/21/2010, Deepa Lakshmi Shanadi wrote:
I've made your edits and this is my new syntax. Is there a reason you didn't use DO REPEAT? I think that, in addition to being easier to read and write, syntax with DO REPEAT is more reliable, since it doesn't make you write 30 instances of essentially the same syntax, without making mistakes. Then, you say, I know I'm not getting the right output [because] I've done a count of all children aged7to15 and sometimes my number here (age7to15 and going to school) is greater than the number of children that are aged 7to15. I'm not sure how your data is set up. Each record has 30 'age' variables ("B5_AGE$01" TO "B5_AGE$30") and 30 'in-school' variables ("B8_CURATSCH$01" TO "B8_CURATSCH$30"); is that one child, or 30 children? Your number "(age7to15 and going to school)" -- what number is that, on the FREQUENCIES output? Variable "age7to15andschoolfrequency" gives the number on ONE RECORD, but where do you read the total from? To check for data errors, it'll probably be easier if you first unroll the data as I suggested in my first posting on this thread; but first, help me understand your problem. Do you have a small set of data that doesn't seem to give the right answer when you run the syntax? -Best of luck, Richard ===================== 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 |
THANK YOU to Richard re: unrolling data
|
|
Dear Richard,
I tried unrolling the data as you suggested and it worked. THANK YOU FOR SHARING THIS. It makes the dataset I have more manageable. Once the data is unrolled it is a lot easier to calculate frequencies and crosstabs than adding up 30 columns.
But is there anything I should be careful about to make sure the data is unrolled correctly?
For example, I noticed that if something is blank/missing case, it actually does not include that data in the new dataset. So to take care of that I put '999" in the original dataset so that case is carried over.
Anything else?
Thanks again, Deepa |
Re: counting frequencies of 30 columns
|
|
At 04:28 PM 10/5/2010, Deepa Lakshmi Shanadi wrote (subject "THANK
YOU to Richard re: unrolling data"):
I tried unrolling the data as you suggested and it worked. THANK YOU FOR SHARING THIS. It makes the dataset I have more manageable. Once the data is unrolled it is a lot easier to calculate frequencies and crosstabs than adding up 30 columns. Try using "/NULL = KEEP" instead of "/NULL = DROP" on your VARSTOCASES statement. Otherwise, your code (reproduced below, reformatted from a separate note you sent off-list) looks good to me. -Best of luck to you, Richard VARSTOCASES /MAKE CID FROM ID_CODC$01 ID_CODC$02 ID_CODC$03 ID_CODC$04 ID_CODC$05 ID_CODC$06 ID_CODC$07 ID_CODC$08 ID_CODC$09 ID_CODC$10 ID_CODC$11 ID_CODC$12 ID_CODC$13 ID_CODC$14 ID_CODC$15 ID_CODC$16 ID_CODC$17 ID_CODC$18 ID_CODC$19 ID_CODC$20 ID_CODC$21 ID_CODC$22 ID_CODC$23 ID_CODC$24 ID_CODC$25 ID_CODC$26 ID_CODC$27 ID_CODC$28 ID_CODC$29 ID_CODC$30 /MAKE C2 FROM C2_ATTSCH$01 C2_ATTSCH$02 C2_ATTSCH$03 C2_ATTSCH$04 C2_ATTSCH$05 C2_ATTSCH$06 C2_ATTSCH$07 C2_ATTSCH$08 C2_ATTSCH$09 C2_ATTSCH$10 C2_ATTSCH$11 C2_ATTSCH$12 C2_ATTSCH$13 C2_ATTSCH$14 C2_ATTSCH$15 C2_ATTSCH$16 C2_ATTSCH$17 C2_ATTSCH$18 C2_ATTSCH$19 C2_ATTSCH$20 C2_ATTSCH$21 C2_ATTSCH$22 C2_ATTSCH$23 C2_ATTSCH$24 C2_ATTSCH$25 C2_ATTSCH$26 C2_ATTSCH$27 C2_ATTSCH$28 C2_ATTSCH$29 C2_ATTSCH$30 /MAKE C3 FROM C3_EVERATTSCH$01 C3_EVERATTSCH$02 C3_EVERATTSCH$03 C3_EVERATTSCH$04 C3_EVERATTSCH$05 C3_EVERATTSCH$06 C3_EVERATTSCH$07 C3_EVERATTSCH$08 C3_EVERATTSCH$09 C3_EVERATTSCH$10 C3_EVERATTSCH$11 C3_EVERATTSCH$12 C3_EVERATTSCH$13 C3_EVERATTSCH$14 C3_EVERATTSCH$15 C3_EVERATTSCH$16 C3_EVERATTSCH$17 C3_EVERATTSCH$18 C3_EVERATTSCH$19 C3_EVERATTSCH$20 C3_EVERATTSCH$21 C3_EVERATTSCH$22 C3_EVERATTSCH$23 C3_EVERATTSCH$24 C3_EVERATTSCH$25 C3_EVERATTSCH$26 C3_EVERATTSCH$27 C3_EVERATTSCH$28 C3_EVERATTSCH$29 C3_EVERATTSCH$30 /MAKE C4 FROM C4_AGESTPSC$01 C4_AGESTPSC$02 C4_AGESTPSC$03 C4_AGESTPSC$04 C4_AGESTPSC$05 C4_AGESTPSC$06 C4_AGESTPSC$07 C4_AGESTPSC$08 C4_AGESTPSC$09 C4_AGESTPSC$10 C4_AGESTPSC$11 C4_AGESTPSC$12 C4_AGESTPSC$13 C4_AGESTPSC$14 C4_AGESTPSC$15 C4_AGESTPSC$16 C4_AGESTPSC$17 C4_AGESTPSC$18 C4_AGESTPSC$19 C4_AGESTPSC$20 C4_AGESTPSC$21 C4_AGESTPSC$22 C4_AGESTPSC$23 C4_AGESTPSC$24 C4_AGESTPSC$25 C4_AGESTPSC$26 C4_AGESTPSC$27 C4_AGESTPSC$28 C4_AGESTPSC$29 C4_AGESTPSC$30 /MAKE C5a FROM C5A_YSTPSCH$01 C5A_YSTPSCH$02 C5A_YSTPSCH$03 C5A_YSTPSCH$04 C5A_YSTPSCH$05 C5A_YSTPSCH$06 C5A_YSTPSCH$07 C5A_YSTPSCH$08 C5A_YSTPSCH$09 C5A_YSTPSCH$10 C5A_YSTPSCH$11 C5A_YSTPSCH$12 C5A_YSTPSCH$13 C5A_YSTPSCH$14 C5A_YSTPSCH$15 C5A_YSTPSCH$16 C5A_YSTPSCH$17 C5A_YSTPSCH$18 C5A_YSTPSCH$19 C5A_YSTPSCH$20 C5A_YSTPSCH$21 C5A_YSTPSCH$22 C5A_YSTPSCH$23 C5A_YSTPSCH$24 C5A_YSTPSCH$25 C5A_YSTPSCH$26 C5A_YSTPSCH$27 C5A_YSTPSCH$28 C5A_YSTPSCH$29 C5A_YSTPSCH$30 /MAKE C5b FROM C5B_YSTPSCH$01 C5B_YSTPSCH$02 C5B_YSTPSCH$03 C5B_YSTPSCH$04 C5B_YSTPSCH$05 C5B_YSTPSCH$06 C5B_YSTPSCH$07 C5B_YSTPSCH$08 C5B_YSTPSCH$09 C5B_YSTPSCH$10 C5B_YSTPSCH$11 C5B_YSTPSCH$12 C5B_YSTPSCH$13 C5B_YSTPSCH$14 C5B_YSTPSCH$15 C5B_YSTPSCH$16 C5B_YSTPSCH$17 C5B_YSTPSCH$18 C5B_YSTPSCH$19 C5B_YSTPSCH$20 C5B_YSTPSCH$21 C5B_YSTPSCH$22 C5B_YSTPSCH$23 C5B_YSTPSCH$24 C5B_YSTPSCH$25 C5B_YSTPSCH$26 C5B_YSTPSCH$27 C5B_YSTPSCH$28 C5B_YSTPSCH$29 C5B_YSTPSCH$30 /MAKE C6a FROM C6A_YNEVATSC$01 C6A_YNEVATSC$02 C6A_YNEVATSC$03 C6A_YNEVATSC$04 C6A_YNEVATSC$05 C6A_YNEVATSC$06 C6A_YNEVATSC$07 C6A_YNEVATSC$08 C6A_YNEVATSC$09 C6A_YNEVATSC$10 C6A_YNEVATSC$11 C6A_YNEVATSC$12 C6A_YNEVATSC$13 C6A_YNEVATSC$14 C6A_YNEVATSC$15 C6A_YNEVATSC$16 C6A_YNEVATSC$17 C6A_YNEVATSC$18 C6A_YNEVATSC$19 C6A_YNEVATSC$20 C6A_YNEVATSC$21 C6A_YNEVATSC$22 C6A_YNEVATSC$23 C6A_YNEVATSC$24 C6A_YNEVATSC$25 C6A_YNEVATSC$26 C6A_YNEVATSC$27 C6A_YNEVATSC$28 C6A_YNEVATSC$29 C6A_YNEVATSC$30 /MAKE C6b FROM C6B_YNEVATSC$01 C6B_YNEVATSC$02 C6B_YNEVATSC$03 C6B_YNEVATSC$04 C6B_YNEVATSC$05 C6B_YNEVATSC$06 C6B_YNEVATSC$07 C6B_YNEVATSC$08 C6B_YNEVATSC$09 C6B_YNEVATSC$10 C6B_YNEVATSC$11 C6B_YNEVATSC$12 C6B_YNEVATSC$13 C6B_YNEVATSC$14 C6B_YNEVATSC$15 C6B_YNEVATSC$16 C6B_YNEVATSC$17 C6B_YNEVATSC$18 C6B_YNEVATSC$19 C6B_YNEVATSC$20 C6B_YNEVATSC$21 C6B_YNEVATSC$22 C6B_YNEVATSC$23 C6B_YNEVATSC$24 C6B_YNEVATSC$25 C6B_YNEVATSC$26 C6B_YNEVATSC$27 C6B_YNEVATSC$28 C6B_YNEVATSC$29 C6B_YNEVATSC$30 /MAKE C7a FROM C7A_IMPRETEN$01 C7A_IMPRETEN$02 C7A_IMPRETEN$03 C7A_IMPRETEN$04 C7A_IMPRETEN$05 C7A_IMPRETEN$06 C7A_IMPRETEN$07 C7A_IMPRETEN$08 C7A_IMPRETEN$09 C7A_IMPRETEN$10 C7A_IMPRETEN$11 C7A_IMPRETEN$12 C7A_IMPRETEN$13 C7A_IMPRETEN$14 C7A_IMPRETEN$15 C7A_IMPRETEN$16 C7A_IMPRETEN$17 C7A_IMPRETEN$18 C7A_IMPRETEN$19 C7A_IMPRETEN$20 C7A_IMPRETEN$21 C7A_IMPRETEN$22 C7A_IMPRETEN$23 C7A_IMPRETEN$24 C7A_IMPRETEN$25 C7A_IMPRETEN$26 C7A_IMPRETEN$27 C7A_IMPRETEN$28 C7A_IMPRETEN$29 C7A_IMPRETEN$30 /MAKE C7b FROM C7B_IMPRETEN$01 C7B_IMPRETEN$02 C7B_IMPRETEN$03 C7B_IMPRETEN$04 C7B_IMPRETEN$05 C7B_IMPRETEN$06 C7B_IMPRETEN$07 C7B_IMPRETEN$08 C7B_IMPRETEN$09 C7B_IMPRETEN$10 C7B_IMPRETEN$11 C7B_IMPRETEN$12 C7B_IMPRETEN$13 C7B_IMPRETEN$14 C7B_IMPRETEN$15 C7B_IMPRETEN$16 C7B_IMPRETEN$17 C7B_IMPRETEN$18 C7B_IMPRETEN$19 C7B_IMPRETEN$20 C7B_IMPRETEN$21 C7B_IMPRETEN$22 C7B_IMPRETEN$23 C7B_IMPRETEN$24 C7B_IMPRETEN$25 C7B_IMPRETEN$26 C7B_IMPRETEN$27 C7B_IMPRETEN$28 C7B_IMPRETEN$29 C7B_IMPRETEN$30 /MAKE C9 FROM C9__HOWREGAT$01 C9__HOWREGAT$02 C9__HOWREGAT$03 C9__HOWREGAT$04 C9__HOWREGAT$05 C9__HOWREGAT$06 C9__HOWREGAT$07 C9__HOWREGAT$08 C9__HOWREGAT$09 C9__HOWREGAT$10 C9__HOWREGAT$11 C9__HOWREGAT$12 C9__HOWREGAT$13 C9__HOWREGAT$14 C9__HOWREGAT$15 C9__HOWREGAT$16 C9__HOWREGAT$17 C9__HOWREGAT$18 C9__HOWREGAT$19 C9__HOWREGAT$20 C9__HOWREGAT$21 C9__HOWREGAT$22 C9__HOWREGAT$23 C9__HOWREGAT$24 C9__HOWREGAT$25 C9__HOWREGAT$26 C9__HOWREGAT$27 C9__HOWREGAT$28 C9__HOWREGAT$29 C9__HOWREGAT$30 /MAKE C10a FROM C1A_REAMISSCH$01 C1A_REAMISSCH$02 C1A_REAMISSCH$03 C1A_REAMISSCH$04 C1A_REAMISSCH$05 C1A_REAMISSCH$06 C1A_REAMISSCH$07 C1A_REAMISSCH$08 C1A_REAMISSCH$09 C1A_REAMISSCH$10 C1A_REAMISSCH$11 C1A_REAMISSCH$12 C1A_REAMISSCH$13 C1A_REAMISSCH$14 C1A_REAMISSCH$15 C1A_REAMISSCH$16 C1A_REAMISSCH$17 C1A_REAMISSCH$18 C1A_REAMISSCH$19 C1A_REAMISSCH$20 C1A_REAMISSCH$21 C1A_REAMISSCH$22 C1A_REAMISSCH$23 C1A_REAMISSCH$24 C1A_REAMISSCH$25 C1A_REAMISSCH$26 C1A_REAMISSCH$27 C1A_REAMISSCH$28 C1A_REAMISSCH$29 C1A_REAMISSCH$30 /MAKE C10b FROM C10_REAMISSCH$01 C10_REAMISSCH$02 C10_REAMISSCH$03 C10_REAMISSCH$04 C10_REAMISSCH$05 C10_REAMISSCH$06 C10_REAMISSCH$07 C10_REAMISSCH$08 C10_REAMISSCH$09 C10_REAMISSCH$10 C10_REAMISSCH$11 C10_REAMISSCH$12 C10_REAMISSCH$13 C10_REAMISSCH$14 C10_REAMISSCH$15 C10_REAMISSCH$16 C10_REAMISSCH$17 C10_REAMISSCH$18 C10_REAMISSCH$19 C10_REAMISSCH$20 C10_REAMISSCH$21 C10_REAMISSCH$22 C10_REAMISSCH$23 C10_REAMISSCH$24 C10_REAMISSCH$25 C10_REAMISSCH$26 C10_REAMISSCH$27 C10_REAMISSCH$28 C10_REAMISSCH$29 C10_REAMISSCH$30 /MAKE C11 FROM C11_TIMEMISCH$01 C11_TIMEMISCH$02 C11_TIMEMISCH$03 C11_TIMEMISCH$04 C11_TIMEMISCH$05 C11_TIMEMISCH$06 C11_TIMEMISCH$07 C11_TIMEMISCH$08 C11_TIMEMISCH$09 C11_TIMEMISCH$10 C11_TIMEMISCH$11 C11_TIMEMISCH$12 C11_TIMEMISCH$13 C11_TIMEMISCH$14 C11_TIMEMISCH$15 C11_TIMEMISCH$16 C11_TIMEMISCH$17 C11_TIMEMISCH$18 C11_TIMEMISCH$19 C11_TIMEMISCH$20 C11_TIMEMISCH$21 C11_TIMEMISCH$22 C11_TIMEMISCH$23 C11_TIMEMISCH$24 C11_TIMEMISCH$25 C11_TIMEMISCH$26 C11_TIMEMISCH$27 C11_TIMEMISCH$28 C11_TIMEMISCH$29 C11_TIMEMISCH$30 /MAKE C12 FROM C12_YLESSAT$01 C12_YLESSAT$02 C12_YLESSAT$03 C12_YLESSAT$04 C12_YLESSAT$05 C12_YLESSAT$06 C12_YLESSAT$07 C12_YLESSAT$08 C12_YLESSAT$09 C12_YLESSAT$10 C12_YLESSAT$11 C12_YLESSAT$12 C12_YLESSAT$13 C12_YLESSAT$14 C12_YLESSAT$15 C12_YLESSAT$16 C12_YLESSAT$17 C12_YLESSAT$18 C12_YLESSAT$19 C12_YLESSAT$20 C12_YLESSAT$21 C12_YLESSAT$22 C12_YLESSAT$23 C12_YLESSAT$24 C12_YLESSAT$25 C12_YLESSAT$26 C12_YLESSAT$27 C12_YLESSAT$28 C12_YLESSAT$29 C12_YLESSAT$30 /MAKE C13 FROM C13_YLESREG$01 C13_YLESREG$02 C13_YLESREG$03 C13_YLESREG$04 C13_YLESREG$05 C13_YLESREG$06 C13_YLESREG$07 C13_YLESREG$08 C13_YLESREG$09 C13_YLESREG$10 C13_YLESREG$11 C13_YLESREG$12 C13_YLESREG$13 C13_YLESREG$14 C13_YLESREG$15 C13_YLESREG$16 C13_YLESREG$17 C13_YLESREG$18 C13_YLESREG$19 C13_YLESREG$20 C13_YLESREG$21 C13_YLESREG$22 C13_YLESREG$23 C13_YLESREG$24 C13_YLESREG$25 C13_YLESREG$26 C13_YLESREG$27 C13_YLESREG$28 C13_YLESREG$29 C13_YLESREG$30 /INDEX = Rec#(30) /KEEP = Schoolfeeding A1_HHNO QNUM A3C_REG B10__TOTMEM age7to15andgoingtoschool Eincomegroup Ewealthgroup_revised Eassetsgroup Csummary /NULL = DROP. ===================== 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 |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |