Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Thank you Jon. I am splitting afile. What do you mean by "change the condition to 0 for the other half." I would like to get two different data files.

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

When I read the initial post, I thought you wanted to apply the SPLIT FILE command.  But in your later post, you've said that you want to have two separate datasets, one with the odd-numbered rows and one with the even-numbered rows.  There may be an extension command to do that, or you could use XSAVE.  But here's another way you could try.  I'll illustrate using one of the datasets that comes with SPSS.

NEW FILE. 
DATASET CLOSE ALL.
* Change path to point to folder with SPSS sample datasets.
GET FILE = "C:\SPSSdata\survey_sample.sav".
DATASET NAME original.
COMPUTE OrigRow = $CASENUM.
FORMATS OrigRow (F5.0).
**************************************************.
* Frank would like to get two different data files,
* one with the odd rows, one with the even rows.
**************************************************.
* Make two copies of the original dataset.
DATASET COPY Copy1.
DATASET COPY Copy2.
* Keep the odd-numbered rows in Copy1.
DATASET ACTIVATE Copy1.
SELECT IF MOD(OrigRow, 2) EQ 1.
COMPUTE NewRow = $Casenum.
FORMATS NewRow (F5.0).
LIST OrigRow NewRow /CASES=FROM 1 to 10.
DESCRIPTIVES OrigRow NewRow.
* Keep the even-numbered rows in Copy1.
DATASET ACTIVATE Copy2.
SELECT IF MOD(OrigRow, 2) EQ 0.
COMPUTE NewRow = $Casenum.
FORMATS NewRow (F5.0).
LIST OrigRow NewRow /CASES=FROM 1 to 10.

Notice how the two SELECT IF commands differ.

Here is the output from the two LIST commands.

OrigRow NewRow 
 
     1       1 
     3       2 
     5       3 
     7       4 
     9       5 
    11       6 
    13       7 
    15       8 
    17       9 
    19      10 
 
Number of cases read:  10    Number of cases listed:  10

OrigRow NewRow 
 
     2       1 
     4       2 
     6       3 
     8       4 
    10       5 
    12       6 
    14       7 
    16       8 
    18       9 
    20      10 
 
Number of cases read:  10    Number of cases listed:  10

I hope this helps.

Thank you Jon. I am splitting afile. What do you mean by "change the condition to 0 for the other half." I would like to get two different data files.

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Just tried this. It deselected all of the cases! Idid not do anything with the condition...

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Just tried this. It deselected all of the cases! Idid not do anything with the condition...

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Thank you,

I did the following in the first half:

compute half = mod($casenum, 2) eq 1.
filter by half.
freq jobcat.

I did the following in the second half, but all cases were deselected..
compute half = mod($casenum, 2) eq 0.
filter by half.
freq jobcat.

I must be missing something...

Just tried this. It deselected all of the cases! Idid not do anything with the condition...

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.

Thank you,

I did the following in the first half:

compute half = mod($casenum, 2) eq 1.
filter by half.
freq jobcat.

I did the following in the second half, but all cases were deselected..
compute half = mod($casenum, 2) eq 0.
filter by half.
freq jobcat.

I must be missing something...

Just tried this. It deselected all of the cases! Idid not do anything with the condition...

Hello All,

iO did not see an option to select every other case in in SPSS data. I am trying to split a dat file into two by selecting every other case. I do not want random selections. Thank you in advance.