topic Re: Want to take out last name from string in New SAS User

Want to take out last name from string

aanan1417 — Fri, 30 Apr 2021 09:56:37 GMT

i want to take out last name from given string

data have;

length a $200.;

input a;

datalines;

;

run;

output

yadav

dhoni

kumari

PaigeMiller — Fri, 30 Apr 2021 10:12:03 GMT

Please explain the rules you followed to determine the output of the first line is yadav.

aanan1417 — Fri, 30 Apr 2021 10:13:18 GMT

i want to take out yadav from first line
dhoni from second line
kumari from last line

PaigeMiller — Fri, 30 Apr 2021 10:14:24 GMT

I specifically asked for the rules that let you know how to figure out what the last name is. Without rules, we can't write a program.

aanan1417 — Fri, 30 Apr 2021 10:18:14 GMT

their is space between name for example
rahul yadav @gmail.com
mahender singh doni @gmail.com
ava kumari @gmail.com

PaigeMiller — Fri, 30 Apr 2021 10:19:44 GMT

There is no space in the names in your input data.

E-mail addresses cannot have spaces.

aanan1417 — Fri, 30 Apr 2021 10:20:18 GMT

sorry typing error

PaigeMiller — Fri, 30 Apr 2021 10:25:36 GMT

@aanan1417 wrote:
sorry typing error

I don't believe e-mail addresses can have spaces, and so you need to address that, and provide rules given that restriction