topic Removing apostrophes between names in SAS Programming

Removing apostrophes between names

SAS_Girl1 — Fri, 16 May 2025 20:11:09 GMT

Hi -

I would like to get rid of these apostrophes from first and last names.

Currently names appear as:

"Martha" and I would want to and up with Martha

Should be simple enough,

Thank you,

PaigeMiller — Fri, 16 May 2025 20:25:03 GMT

These are not apostrophes, those are double-quotes. So, do you want to remove single-quotes and double-quotes from the name?

If so, try this:

new_name=compress(name,'"');

to get rid of the double-quotes and if you also want to get rid of single-quotes, use one more command

new_name=compress(new_name,"'");

SAS_Girl1 — Fri, 16 May 2025 20:40:46 GMT

Thank you so much for the prompt reply!

I will test your suggestions.

Best,