=========================================================================
Date:         Mon, 31 Jul 2006 13:45:48 -0400
Reply-To:     emaguin <emaguin@buffalo.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         emaguin <emaguin@buffalo.edu>
Subject:      Recode question
In-Reply-To:  <200607311711.k6VFCSvs016332@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="US-ASCII"

All,

I must be doing something wrong or misunderstanding the documetation but ...

This is the frequencies for the variable going in to the recode (apologies
if tabs are not preserved).

P1RAAC1  A1 Par: Alcohol Abuse Count
                Frequency       Percent Valid Percent   Cumulative Percent
Valid   .00             89      13.2    13.6    13.6
        1.00            102     15.1    15.6    29.2
        2.00            58      8.6     8.9     38.1
        ...
        12.00           24      3.6     3.7     98.3
        13.00           11      1.6     1.7     100.0
        Total           654     97.0    100.0
Missing 99.00   19      2.8
        System  1       .1
        Total           20      3.0
Total                   674     100.0

This the recode statement.

RECODE P1RAAC1(0 1=0)(2=2)(3 THRU 13=3)(MISSING=9).

And this is the result

P1RAAC1  A1 Par: Alcohol Abuse Count
                Frequency       Percent Valid Percent   Cumulative Percent
Valid   .00  0-1 NonAlc 191     28.3    28.4    28.4
        2.00  2 Maybe   58      8.6     8.6     37.0
        3.00  3+ Definite       405     60.1    60.2    97.2
        99.00                   19      2.8     2.8     100.0
        Total                   673     99.9    100.0
Missing 9.00            1       .1
Total                           674     100.0

As I read the documentation for 13, the 'missing' keyword causes user
missing and system missing value to be coded to sysmis on the output. It
doesn't look like this is happening here. Comments?