The STRIP function call has too many arguments.

[Bal23]

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:

The STRIP function call has too many arguments.

anybody helps to solve this?

thanks

[Haikuo · Accepted solution]

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;