Saturday, 27 November 2010


recode var names (1 2 = 1 low)  ///
(3 = 2 medium) ///
(4 5 = 3 high) ///
(nonmissing = 9 "something else") ///
(missing = .) ///
, gen(Rx Ry) label(Cat3)

Use mvencode and mvdecode to deal with missing values.
For example to convert 99 into sysmis
in the variable mstatus,

mvdecode mstatus, mv(99)

For the opposite effect,
mvencode mstatus, mv(99)

Wednesday, 24 November 2010

Computing Age from DOB in SPSS

There are million ways to do this. but here is what worked for me. You will need your date of birth variable to have month, day and year.

COMPUTE age_year = (DATE.MDY(11,01,2010) - BirthDate) / (60*60*24*365.25) .

COMPUTE age=RND(age_year).
FORMATS age (F3.0).
*fre age.

NOTE: This will create an AGE variable, as of now, not the age of respondent at the time of survey. To do that you would need survey date.

Tuesday, 23 November 2010

String to Numeric in SPSS

STRING m1 (A10).


compute m1 = substr(query_co,1,1).


list m1.