Help using Base SAS procedures

Extracting Two Variables from One

Accepted Solution Solved
Reply
Contributor JAR
Contributor
Posts: 45
Accepted Solution

Extracting Two Variables from One

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


Accepted Solutions
Solution
‎06-24-2013 11:58 PM
Super User
Posts: 17,828

Re: Extracting Two Variables from One


All Replies
Solution
‎06-24-2013 11:58 PM
Super User
Posts: 17,828

Re: Extracting Two Variables from One

Contributor
Posts: 74

Re: Extracting Two Variables from One

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;

Contributor JAR
Contributor
Posts: 45

Re: Extracting Two Variables from One

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

Regards,

Jijil

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 176 views
  • 4 likes
  • 3 in conversation