Splitting up a variable

marleeakerson — Tue, 13 Oct 2020 20:42:52 GMT

Hello,

I currently have a variable that contains a last name and first name, and I want to split it up into two separate variables, one for the last name and one for the first name.

For example, I want the data to go from:

Name

Smith Julia

Johnson Mark

Reynolds Steve

to this:

Last Name First Name

Smith Julia

Johnson Mark

Reynolds Steve

Does anyone have any advice?

Thanks!

Re: Splitting up a variable

Reeza — Tue, 13 Oct 2020 20:53:47 GMT

What would you do for a name like "Eddie Van Halen"?

Otherwise, in a simplistic situation illustrated, SCAN() works.

data want;
set have;

firstName = scan(name, 2);
lastName = scan(name, 1);

run;

@marleeakerson wrote:

Hello,

I currently have a variable that contains a last name and first name, and I want to split it up into two separate variables, one for the last name and one for the first name.

For example, I want the data to go from:

Name

Smith Julia

Johnson Mark

Reynolds Steve

to this:

Last Name First Name

Smith Julia

Johnson Mark

Reynolds Steve

Does anyone have any advice?

Thanks!

topic Re: Splitting up a variable in New SAS User

Splitting up a variable

Re: Splitting up a variable