merging spss one to many data sets version 25

Use a value that's not yet present in the original variables and apply a value label to it. Prior to running this syntax, simply RECODE ().Ī nicer result can be obtained without changing the basic syntax for combining categorical variables. An example of such a value label isĭoctor_rating = 3 (Neutral) nurse_rating =. You may have noticed that the value labels of the combined variable don't look very nice if system missing values are present in the original values. SPSS Combine Categorical Variables - System Missing Values

replace “doctor_and_nurse_rating” by the variable name you'd like to use for the final result.

replace “nurse_rating” by the name of the second variable you'd like to combine.

Note that you can do so by using the ctrl + h shortkey.

replace “doctor_rating” by the name of the first variable you'd like to combine.

So instead of rewriting it, just copy and paste it and make three basic adjustments before running it: We realize that many readers may find this syntax too difficult to rewrite for their own data files. SPSS Combine Categorical Variables - Other Data

variable labels doctor_and_nurse_rating 'Combination of doctor_rating and nurse_rating'.

Optionally, apply variable label to end result. autorecode tmp /into doctor_and_nurse_rating.

compute tmp = concat( 'doctor_rating = ',string(doctor_rating,f1),' (',rtrim(valuelabels(doctor_rating)),') ', 'nurse_rating = ',string(nurse_rating,f1),' (',rtrim(valuelabels(nurse_rating)),') ' ). Combine values and value labels of doctor_rating and nurse_rating into tmp string variable.

Merging spss one to many data sets version 25