topic Re: Extracting Two Variables from One in SAS Procedures

Extracting Two Variables from One

JAR — Tue, 25 Jun 2013 03:56:48 GMT

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

Re: Extracting Two Variables from One

Reeza — Tue, 25 Jun 2013 03:58:16 GMT

Scan function.

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

Re: Extracting Two Variables from One

TarunKumar — Tue, 25 Jun 2013 04:37:06 GMT

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;

Re: Extracting Two Variables from One

JAR — Tue, 25 Jun 2013 07:53:03 GMT

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

Regards,

Jijil