topic Re: remove salutations in name in SAS Programming

remove salutations in name

Miracle — Sat, 17 Sep 2016 16:34:58 GMT

Hi everyone.

Can I please ask how can I remove the salutations ie Mr, Ms, Mrs, Miss, Dr. from the variable 'name' in my data?

Thank you.

Reeza — Sat, 17 Sep 2016 22:43:18 GMT

Use TRANWRD but you need to be careful and test it.

For example, if you try and replace Miss, what about a first name as Missy?

Shmuel — Sun, 18 Sep 2016 00:44:48 GMT

Usually salutations are the first/prefix of a name followd by a space.

In such case :

%let salut_list = Mr Ms Mrs Miss Dr. ;

data want;

set have;

test = scan(name,1) ;

if test in (&salut_list)

then name = left(substr(name, length(test)+1));

/* drop or rename test to salut */

run;

Shmuel — Sun, 18 Sep 2016 00:46:46 GMT

change to:
%let salut_list = "Mr" "Ms" "Mrs" "Miss" "Dr." ;