Remove an apostrophe only at the end of a word

WorkUser — Tue, 21 Mar 2023 16:36:09 GMT

Is it possible to remove an apostrophe only at the end of a word in SAS EG query builder?

I have the following data:

EMPLOYEES' BANK
ARTISANS' BANK
TEACHERS' RETIREMENT SYSTEM
DEVELOPER'S MORTGAGE COMPANY

And would like a new computed column to show:

EMPLOYEES BANK
ARTISANS BANK
TEACHERS RETIREMENT SYSTEM
DEVELOPER'S MORTGAGE COMPANY

Thanks

Re: Remove an apostrophe only at the end of a word

ballardw — Tue, 21 Mar 2023 18:04:22 GMT

Don't know if the query builder uses the TRANWRD function.

The tranwrd function replaces in the first parameter, the string found in the second parameter if present, with the third parameter. We use double quotes to encase a single quote to avoid syntax:"' " to indicate single quote followed by space.

If you have other characters that occur after the the single quote that are not letters that may indicate something else to change then repeat.

Here is an example with code:

data have;
  input var $30.;
datalines;
EMPLOYEES' BANK
ARTISANS' BANK
TEACHERS' RETIREMENT SYSTEM
DEVELOPER'S MORTGAGE COMPANY
;

data want;
   set have;
   var = tranwrd(var,"' "," ");
run;

topic Remove an apostrophe only at the end of a word in SAS Enterprise Guide

Remove an apostrophe only at the end of a word

Re: Remove an apostrophe only at the end of a word