topic Leadin 0's Removal in SAS Programming

Leadin 0's Removal

Kwok — Fri, 29 Jan 2010 19:58:33 GMT

Hi,

Is there any SAS function that will remove all leading zeop from a string ? I check all the CAT(x) functions but non of them deal with leading zero alone.

Thanks

Re: Leadin 0's Removal

sbb — Fri, 29 Jan 2010 20:11:22 GMT

The presumption here is that you are dealing with a SAS CHARACTER variable - one that has zero character(s) as part of the string? If so, look at using the combination of an INPUT function invocation (to convert the number char-string to a SAS NUMERIC variable, and then using the PUT function in an assignment statement to convert back to character -- add the -l operand as part of the PUT function's second argument to left-justify, if desired.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument for this topic/post:

convert number character remove leading zeros site:sas.com

Re: Leadin 0's Removal

RickM — Fri, 29 Jan 2010 20:16:16 GMT

maybe

x=translate(left(translate(x,' 0','0 ')),' 0','0 ');

this should switch 0's and ' ', take off the leading blanks and switch back any 0's and ' '

Re: Leadin 0's Removal

data_null__ — Fri, 29 Jan 2010 21:52:07 GMT

An alternative using the "new" SUBSTRN function.

[pre]
99 data _null_;
100 input s:$20.;
101 z = substrn(s,verify(s,'0'));
102 put 'NOTE: '(_all_)(=);
103 cards;

NOTE: s=000ABC z=ABC
NOTE: s=00aa z=aa
NOTE: s=001 z=1
NOTE: s=100 z=100
NOTE: s=Help z=Help
[/pre]

Re: Leadin 0's Removal

Kwok — Mon, 01 Feb 2010 13:42:32 GMT

Thanks for all your sample codes. The issue solved.

Regards
David