text functions

[Prateek1]

 hi,

this is the data set 

name:

Nicholas,KregFL

Reddy,RamanBT

Strehle,FlorainGE

Debergh,ChristopherFL

MY CODE IS :

Data First_name3;
set Starting_position;
First_name=SUBSTR(Name,Starting_postion,",");
Run;

i am not getting the first name from this code.

please help ?

 how to create a new variable first name from  name variable using SUBSTR function ?

[Reeza]

Use the Scan function

[Prateek1]

hi,

what should be the code ?

[Reeza]

RTM

scan(variable, 1, ",")

https://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#p0jshdjy2z...

http://support.sas.com/documentation/cdl/en/basess/68381/HTML/default/viewer.htm#p1ka2ln1wb9voin0zlo...