Extracting Two Variables from One

[JAR]

Hi,

I need help with the following:

I have one variable (string) in a dataset with variable name Record. eg.

automation:The use of largely automatic equipment in a system of manufacturing or other production process

I need to break it into two variables, namely word (automation), and meaning (everything after colon). Could someone tell me a clean way of doing this in SAS.

Jijil

[Reeza · Accepted solution]

Scan function.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

[TarunKumar]

pls try this code.

data test;

input cust_name$14.;

datalines;

Tarun|Kumar

Richa|Jain

Jaya|Jain

Rakesh|Kumar

;

run;

data test_1 (drop = cust_name);

set test;

Fisrt_Name = scan(cust_name,1,'|');

Last_name = scan(cust_name,-1,'|');

run;

[JAR]

Thanks a lot Tarun. I did not know how to use scan (string, -1, "dlm").

Regards,

Jijil