topic Re: parsing characters with prefix in SAS Programming

parsing characters with prefix

JNWong — Wed, 18 Jan 2017 09:26:20 GMT

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!

Re: parsing characters with prefix

RW9 — Wed, 18 Jan 2017 09:56:06 GMT

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;