Thank you for the brilliant idea! As I'm still relatively new, I'm not quite sure on how to execute the compress function. The function: COMPRESS (character-value <,'compress-list'>) My coding: **compress**; data test3; set test2; Postcode = COMPRESS (" X ") run; Now, the problem is that there are a multitude of differing postcodes. One dataset contains 'UB8 1TF' whereas another may possibly have 'UB10 8TF', and hence I am not too sure as to what to replace 'X' with. Just to clarify, I want the postcodes to become 'UB81TF' and 'UB108TF' instead of the above - also, there are A LOT of postcodes for this to be done to.
... View more