testing - SPSS Chi-square test on raw data -

i want run chi square test on raw data spss not reading raw data want to.

the raw data summarizes several test conditions, locations, groups of participants , results in 1 file. example data:

#   country gender  question 1  question 2 1   chile   f   yes no 2   chile   f   no  no 3   chile   m   no  yes 4   chile   m   yes no 5   chile   f   yes no 6   chile   f   yes yes 7   chile   m   no  yes 8   france  f   yes no 9   france  f   no  no 10  france  f   no  no 11  france  m   yes yes 12  france  m   yes no 13  france  f   yes no 14  france  f   no  yes 15  china   m   yes yes 16  china   f   no  yes 17  china   f   no  yes 18  china   f   yes yes 19  china   m   yes yes 20  china   m   yes no ..... 

i want do chi-square test on comparing french men , chilean women , responses question 1 through 14. problem 1: filter not make spss ignore remaining rows such chinese participants.

problem 2: furthermore if try , compare male , female participants spss produces following error message after calculating:

no statistics computed because (question) constant.<

i cannot accept forced summarize data manually frequency table, how make spss automatically this?

---

edit: allow me rephrase. (protip: don't ask online when frustrated problem)

problem 1 again: move rows need different file if/when need many times becomes increasingly cumbersome. there way select combination of filters (for example) 2 columns in contingency table?

i using filters ("select cases...") wrong!

solution: first make filter data want compare. (pseudo code menu data>select cases...) filter: if french , male.

now filter (i label 'filtera' in variable view) , creates new filter column in data view row variable = 1 french , male, , 0 rest.

now women chile 0 want them in filter (this important) chinese, french women , on.

so define second filter: if chile , female or french , male

now data filtered out shown diagonal line through row-counter column on far left in spss. when statistical test run data not included in test.

now can perform test chi-square: choose descriptive statistics>crosstabs. column choose "filtera" created. row choose questionx/whatever data want calculated.

fin.