topic Re: first name and last name in SAS Programming

first name and last name

BrahmanandaRao — Mon, 17 Jul 2023 10:14:51 GMT

Hi Guys,

name='George W. Bush'

required output:

Fname lname

George W. Bush

Re: first name and last name

MarkusWeick — Mon, 17 Jul 2023 11:56:18 GMT

Hi @BrahmanandaRao; have a look here: Separate Full Name to FirstName and LastName - SAS Support Communities

(And next time please look for existing solutions before asking already answered questions.)

Cheers

Markus

Re: first name and last name

himself — Mon, 17 Jul 2023 12:02:20 GMT

data output;
   set YourDataset; /* Replace "YourDataset" with the name of your actual dataset */

   Fname = scan(full_name, 1); /* Assuming the full name is stored in a variable called "full_name" */
   Lname = scan(full_name, -1); /* Extracts the last word in the full name */

   /* Output the formatted names */
   put "Fname: " Fname;
   put "Lname: " Lname;
run;

In this code, you need to replace "YourDataset" with the actual name of your dataset containing the full names. The SCAN function is used to extract the first name (Fname) and last name (Lname) from the variable full_name. The -1 as the second argument of SCAN tells SAS to extract the last word in the string. Finally, the put statements are used to display the formatted output in the SAS log.

Make sure to adjust the code according to your specific dataset and variable names.

Re: first name and last name

Ksharp — Mon, 17 Jul 2023 12:03:41 GMT

data have;
name='George W. Bush';

call scan(name,-1,p,l,' ');
firstname=substr(name,1,p-1);
lastname=substr(name,p);
run;

proc print;run;

Re: first name and last name

ballardw — Mon, 17 Jul 2023 14:38:31 GMT

Now, what do you expect for a "first" and "last" name from these names

Sun Flower Moon Child

John Richard II Van Opdorp

Maria Garcia Y Mendoza

Smith, John David Junior

Junior Childs Junior

There are rules for parsing names that are cultural and almost any simple one or two line programming solution won't "work" for all of them and may not work for large numbers.

If the question is "what are the first two words out of this list of 3 words" that is one thing.