topic substring a string dynamically in SAS Programming

substring a string dynamically

SASuserlot — Fri, 22 Jul 2022 19:05:09 GMT

I would like to substring a string dynamically. in the following example I have to separate each number (x and y) coordinates from the 'text' string 'xy(x,y)'

data have;
 input x $25.;
cards;
'xy(1,1)'
'xy(1,10)'
'xy(10,1)'
'xy(10,10)'
'xy(100,1)'
;
run;

output Want

text x y

'xy(1,1)' 1 1
'xy(1,10)' 1 10
'xy(10,1)' 10 1
'xy(10,10)' 10 10
'xy(100,1)' 100 1

Thank you for your inputs

Re: substring a string dynamically

WarrenKuhfeld — Fri, 22 Jul 2022 19:25:32 GMT

https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm

Scan using parens and comma as delimiters.

Re: substring a string dynamically

pink_poodle — Fri, 22 Jul 2022 19:47:17 GMT

Thank you, @WarrenKuhfeld! The text string does not need quotation marks. Third argument in quotes lists delimiters.
x = scan( text, 2, '(),' );
y = scan( text, 3, '(),' );

Re: substring a string dynamically

ballardw — Fri, 22 Jul 2022 19:51:28 GMT

Probably should ask if a numeric result is desired so the appropriate INPUT could be added.

Re: substring a string dynamically

pink_poodle — Fri, 22 Jul 2022 19:56:39 GMT

x = input( scan( text, 2, “(),” ), 8.);
y = input( scan( text, 3, “(),” ), 8.);

Re: substring a string dynamically

SASuserlot — Mon, 25 Jul 2022 13:44:38 GMT

Thank you @pink_poodle and @WarrenKuhfeld @ballardw