Concatenating two or more strings is creating a new string consisting of the characters of the first string followed by the characters of the subsequent string(s) in their original order.
SPSS CONCAT Function
- Concatenating in SPSS is done by the
CONCATfunction. - The most basic usage is
COMPUTE A = CONCAT(B,C,D). - Note that you can concatenate only strings. For concatenating numbers, first convert them to strings, for example by using the string function.
- Note that you may sometimes need RTRIM within
CONCATas demonstrated by the syntax below.
SPSS Concatenate Syntax Example
data list free/first_name(a5) last_name(a5) cars.
begin data
‘John’ ‘Doe’ 2
‘Chris’ ‘Colt’ 1
end data.
*2. Concatenate first and last name.
string full_name(a10).
compute full_name = concat(rtrim(first_name),’ ‘,rtrim(last_name)).
exe.
*3. Convert cars to string and concatenate into sentence.
string has_cars (a25).
compute has_cars = concat(rtrim(full_name),’ has ‘,string(cars,f1),’ cars.’).
exe.
*4. Correct plural if needed.
if cars eq 1 has_cars = replace(has_cars,’cars’,’car’).
exe.
SPSS Concatenation Result
Concatenating in Python
- In Python, the
+operator is used for concatenating. - As in SPSS, you can only concatenate strings, not numbers in Python. Convert numbers into strings before concatenating them.
Python Concatenate Example
begin program.
firstName = “John”
lastName = “Doe”
cars = 2
sentence = firstName + ‘ ‘ + lastName + ‘ has ‘ + str(cars) + ‘ cars.’
print sentence
end program.
