topic Re: HOW CAN I GET F_NAME M_NAME AND L_NAME ? in SAS Programming

HOW CAN I GET F_NAME M_NAME AND L_NAME ?

Saikiran_Mamidi — Wed, 12 Feb 2020 18:00:30 GMT

DATA HAVE;

INPUT NAME$30.;

CARDS;

SAI KIRAN PATEL

UMA

RAVI KIRAN

;

RUN;

I WANT DATA LIKE THIS WITHOUT USING ARRAYS

F-NAME M-NAME L-NAME

SAI KIRAN PATEL

UMA

RAVI KIRAN

CAN I GET CODE PLEASE? THANKS

Re: HOW CAN I GET F_NAME M_NAME AND L_NAME ?

PeterClemmensen — Wed, 12 Feb 2020 17:53:50 GMT

Try this

data want(drop=name);
   set have;
   f_name = scan(name, 1);
   m_name = scan(name, 2);
   l_name = scan(name, 3);
run;

Re: HOW CAN I GET F_NAME M_NAME AND L_NAME ?

Saikiran_Mamidi — Wed, 12 Feb 2020 18:02:53 GMT

EDITED DATA ABOVE PLEASE CHECK AGAIN?

Re: HOW CAN I GET F_NAME M_NAME AND L_NAME ?

PeterClemmensen — Wed, 12 Feb 2020 18:21:25 GMT

Quick fix

data want(drop=name);
   set have;
   f_name = scan(name, 1);
   m_name = scan(name, 2);
   if countw(name) = 2 then do;
      call missing(m_name);
      l_name = scan(name, 2);
   end;
   else l_name = scan(name, 3);
run;