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!
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;
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.