Removing 0s from a character string

[v2murthy]

I am looking for a way to remove any 0s in a character string. I've found many threads about removing *leading* zeros, but not about removing 0s in general. For example:

Data I have:

AB001234

C01403

D00003456

Data I want:

AB1234

C143

D3456

Any ideas?

Thank you in advance!

[Reeza · Accepted solution]

COMPRESS function allows you to specify it.

want = compress(word, '0');

[VDD]

Data have;
input string $25.;
cards;
AB001234
C01403
D00003456
;
 
Data  want;
set have;
new_string = COMPRESS (string,0 );
run;

[novinosrin]

Hi @VDD  You are missing quotes around the 0. This will unnecessarily make SAS write a note to the log about the auto conversion. Just watch out for that