Converting a Single Name Variable into Two: First Name and Last Name

InspectahDex — Wed, 20 Jan 2021 21:54:28 GMT

I have a dataset with one variable that contains name information along with suffixes and titles. There are also commas and slashes and there are also blanks. It looks like this:

BusinessContact

Dr. Moon S. Park, FCAP

Stacy Petersen

Dr. Andrew Schwartz

Katie Bova

Ms. Melissa Guiba

Mr. Leonard Licina

OM is Shelly

W.M. Morrow

Business Managaer - Sandy Nikaitani

Mr. Kevin A. Roberts

Tracy Sawada

Faith

Mr. George Newton

Angie Bugaran

Chris

Henry Yim/Kelly Tuamoheloa

Ms. Merilyn Harris

Faith

Gerald McKenna, M.D.

Mr. Herbert Yim

Mr. Ira Walton

Ms. Orianna Skomoroch

How can I take that column and convert it into two where it's split out by First Name and Last Name with the titles (Mr., Mrs., Ms., Dr.) and suffixes (M.D., FCAP) excluded?

Re: Converting a Single Name Variable into Two: First Name and Last Name

ChrisNZ — Fri, 22 Jan 2021 04:10:37 GMT

You need to develop a step-by-step clean-up logic. This is an iterative process by trial and error. For example:

1. Remove titles

when that's done

2. split records with several names into several observations

then

3. extract name components as desired

topic Converting a Single Name Variable into Two: First Name and Last Name in SAS Programming

Converting a Single Name Variable into Two: First Name and Last Name

Re: Converting a Single Name Variable into Two: First Name and Last Name