topic Re: Removing 0s from a character string in SAS Programming

Removing 0s from a character string

v2murthy — Fri, 25 Jan 2019 20:55:43 GMT

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!

Re: Removing 0s from a character string

Reeza — Fri, 25 Jan 2019 21:00:36 GMT

COMPRESS function allows you to specify it.

want = compress(word, '0');

Re: Removing 0s from a character string

VDD — Fri, 25 Jan 2019 21:08:15 GMT

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

Re: Removing 0s from a character string

novinosrin — Fri, 25 Jan 2019 21:37:57 GMT

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