topic Re: text functions in SAS Programming

text functions

Prateek1 — Tue, 28 Jun 2016 12:53:51 GMT

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 — Tue, 28 Jun 2016 13:06:10 GMT

Use the Scan function

Prateek1 — Tue, 28 Jun 2016 15:55:33 GMT

hi,

what should be the code ?

Reeza — Tue, 28 Jun 2016 18:43:06 GMT

RTM

scan(variable, 1, ",")