DATA Step, Macro, Functions and more

parsing characters with prefix

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

parsing characters with prefix

As i have used the scan function to parse the string of characters . the modifier used like ' ' , - and so on. i need to parse them furthermore. data like: 

 xcode1130

tmun3340bf

i have no idea about how to parse them ,like this     xcode 1130

                                                                                  tmun 3340 bf  

  the characters didnot contain - . and other modifiers.

 

Thank you!                                                          


Accepted Solutions
Solution
‎01-18-2017 05:09 AM
Super User
Super User
Posts: 7,403

Re: parsing characters with prefix

Here is an example, I first pull out the numeric part (using compress keep digitis), then use this to replace in the original string a comma I then use for scan:

data want;
  length theline $100;
  input theline $;  
  numeric_part=compress(theline,"","kd");
  theline=tranwrd(theline,strip(numeric_part),",");
  word1=scan(theline,1,",");
  word2=scan(theline,2,",");
datalines;
 xcode1130
tmun3340bf
;
run;

View solution in original post


All Replies
Solution
‎01-18-2017 05:09 AM
Super User
Super User
Posts: 7,403

Re: parsing characters with prefix

Here is an example, I first pull out the numeric part (using compress keep digitis), then use this to replace in the original string a comma I then use for scan:

data want;
  length theline $100;
  input theline $;  
  numeric_part=compress(theline,"","kd");
  theline=tranwrd(theline,strip(numeric_part),",");
  word1=scan(theline,1,",");
  word2=scan(theline,2,",");
datalines;
 xcode1130
tmun3340bf
;
run;
☑ This topic is SOLVED.

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

Discussion stats
  • 1 reply
  • 105 views
  • 0 likes
  • 2 in conversation