Hi - I had a similar problem. Some other environment (maybe from an Excel import to SAS) had created some kind of padding some places after a character string in my data set. I tried everything mentioned but couldn't get TRIM, STRIP etc to work. Also, I didn't know what kind of control characters they were - they didn't display. In the end this solution worked (where fixed_string is a character value and problem_string is the same value followed by unknown non-characters):
fixed_string=upcase(reverse(substrn(reverse(problem_string),anyalpha(reverse(problem_string)))));
It's a bit convoluted but did the trick.
Ronan
... View more