Identify unseen characters and resolve in SAS dataset for a particular column

[Tom · Accepted solution]

Those all looks like zeros.

Try replacing the zeros with spaces 

string = translate(string,' ','00'x);

and then re-check to see if there are other characters.

[JJP1]

Thanks @Tom . rechecked i can see the below character values in output data. can i use translate function to resolve the both cases please

[Tom]

Sure.  The TRANSLATE() function matches the two lists of characters by position.  So to map both the '00'x and the 'FF'x characters to spaces use:

string = translate(string,'  ','00FF'x);