removing a character from a string

[hein68]

Hello.  What is the easiest way to:

• remove the " character from a character variables values?
• remove the ' character from a character variables values?

Thanks!

[Reeza]

COMPRESS() function to remove specific characters.

[maguiremq · Accepted solution]

We need more information here. What exactly are we looking at? As @Reeza said, you can remove things with COMPRESS. This example shows how to only keep (k) alphabetical characters (a) and spaces (s).

data have;
x = 'This "is" a great string';
y = "This 'is' a great string";
run;

data want;
	set have;
		x_no_double = compress(x,,"kas");
		y_no_single = compress(x,,"kas");
run;

Obs	x	y	x_no_double	y_no_single
1	This "is" a great string	This 'is' a great string	This is a great string	This is a great string

[Reeza]

So you have no other punctuation in your strings?

Try it with this as your input data and ensure it meets your needs.

data have;
x = 'This, "is" a great string!!';
y = "This 'is' a great-string!" ;
run;