topic Replcaing quotes with spaces in SAS Programming

Replcaing quotes with spaces

shubham1 — Fri, 06 Dec 2019 06:37:59 GMT

Hello

I have a macro varible whose value can be like this

%let x='a''b';

%letx='ab''bc';

%letx='a''b''c';

what I want is have spaces between words

my output should be

1st one ='a' 'b'

2nd one='ab' 'bc'

3rd one ='a' 'b' 'c'

how can i achieve this

PeterClemmensen — Fri, 06 Dec 2019 06:48:34 GMT

And you still want it in a macro variable?

Jagadishkatam — Fri, 06 Dec 2019 06:51:35 GMT

Please try as below

%let x=%sysfunc(tranwrd('a''b','',' '));
%put &x;

shubham1 — Fri, 06 Dec 2019 06:52:16 GMT

not really

what my aim is that I want to extract each word and then apply scan function

for example in this case

%let x='a''b'

once i get the value as 'a' 'b' the i can easily apply scan function and extact 'a' and 'b' separately

Jagadishkatam — Fri, 06 Dec 2019 06:57:48 GMT

you can extract from within the macro variable as well as below

%let x=%sysfunc(scan('a''b',2,''));
%put &x;