The STRIP function call has too many arguments.

Bal23 — Wed, 20 Jul 2016 16:04:41 GMT

I want to remove leading zero and trailing zero, so I want to modify my variable by doing below:

var2 = strip(var1,'0');

I got the error message:

anybody helps to solve this?

thanks

Re: The STRIP function call has too many arguments.

Haikuo — Wed, 20 Jul 2016 16:29:34 GMT

Unfortunately STRIP() does not have that function. For details, please refer strip function

For your problems, you can either try using a combination of multiple functions/multiple steps, Or using PRX function in one shot:

DATA HAVE;
INPUT STR $20.;
CARDS;
0012200
00023
22000
200340
;


DATA WANT;
SET HAVE;
NEW_STR=PRXCHANGE('s/^ *0*|0* *$//io', -1, str);
run;