compress single and double quote

[milts]

hi all,

let's say i have a value '00012345

how can i remove the single quote or double quote?

if i use compress i'll get a compilation error since syntax for compress is
compress(var,"");

it is enclosed in double quotes so when you put a single quote and a double quote as your arguements, you wont be able to run the code. hope i was able to explain it correctly

are there any ways to remove quotes?

thanks in advance!

[KevinQin]

The function COMPRESS should be OK.

Please try the code below:
data _null_;
a = "'00012345"""; *string with single quote and double quote;
put a=;
b = compress(a, "'""");
put b=;
run;

[milts]

thanks a lot kevin! got it now

[sfleming]

There is also a third parameter to the compress function that can remove all characters of a certain type. For example, 'p' removes all punctuation characters.

data test;
x = "''x''";
y = '""y""';
z = cats(x, y);
w = compress(z,,'p');
run;
proc print data=test;
run;