Concatentating two variables

Posted by The Burl on Aug 26, 2013; 9:37pm
URL: http://spssx-discussion.165.s1.nabble.com/Concatentating-two-variables-tp5721736.html

Thanks in advance for any advice on this!

The data:
Hospital Id, which is numerical ranging from 1-4 digits (e.g. #3 to #3213)
Combine with a variable that identifies a respondent's work group (e.g., "pharmacy") which I have as a string variable, as well as a numeric (e.g., "a" and "1")

It seems fairly simple to concatentate these two variables but I'm having difficulties... Would RTRIM help here?

A sample of the data is attached...

Thank you!Data_Sample.sav