It is assumed that all values in the original variables consist of single digits.

Although the syntax combines two variables, it can be expanded to incorporate three or more variables.

SPSS Combine Categorical Variables - Assumptions Proceed with remaining syntax from here.Īfter doing so, the resulting value label will look as follows:ĭoctor_rating = 3 (Neutral) nurse_rating = 7 (System missing).įurther, note that the syntax we used made a couple of assumptions. add value labels doctor_rating nurse_rating 7 'System missing'. recode doctor_rating nurse_rating (sysmis = 7). Recode system missing into value that doesn't occur in variable yet. 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. How to Combine Categorical Variables in Stata | Stata Tutorial string tmp(a1000).

Merge many to one in spss version 25