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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.